When a version for .NET Core too

We are moving on .NET Core, and like many others the migration issues is not about if our custom code can migrate on .NET Core, but if the third part library already have a version working on .Net ...

Id #15624 | Release: None | Updated: Thu at 9:45 AM by michaelsogos | Created: Thu at 9:45 AM by michaelsogos

Adding filters in RowFields

Hi all, I wrote here because I have a lot time trying to add a filter in RowFields. I made an example test and this is what I got: This is what I need: Example data: This is what ...

Id #15623 | Release: None | Updated: Wed at 7:59 AM by Alemax | Created: Wed at 7:59 AM by Alemax

Applying formula to selected range of non-contiguous cells

I'm able to use the following code to apply a formula to a range of selected cells. Worksheet.Select(new ExcelAddress("T2:T10")); Worksheet.SelectedRange.Formula = "=if(A2=\"\",\"empty\",\"not empt...

Id #15622 | Release: None | Updated: Wed at 1:32 AM by 3milio | Created: Wed at 1:32 AM by 3milio

InsertRow with Copy not worked with merged cells

There is row pattern B2:F2 Cell B2 = "Text" Cell C2 = "Text" Cell D2:E2 is merged = "Text" Cell F2 = "Text" If this is done without "method IinsertRow", it works correctly and the row templa...

Id #15621 | Release: None | Updated: Tue at 6:08 PM by evgnib123 | Created: May 20 at 8:52 PM by evgnib123

Password protected documents

Hey guys! First of all - great library! Recently I had to create a password protected spreadsheet and right now I am just passing the password to the save method like this package.Save("pass...

Id #15620 | Release: None | Updated: May 15 at 3:35 PM by DZhelev | Created: May 15 at 3:35 PM by DZhelev

[Solved]:Set cell value with named cell/range instead of coordinates

I would like to be able to set cell values with named cells/ranges instead of coordinates: ws.Range("profits").Value = 66; Also see https://stackoverflow.com/questions/43910827/how-to-set-valu...

Id #15619 | Release: None | Updated: May 11 at 12:25 PM by eis | Created: May 11 at 9:16 AM by eis

Considering migrating away from CodePlex

CodePlex is about to be shut down. Are you considering to migrate your projet to another platform (like GitHub) ?

Id #15618 | Release: None | Updated: Wed at 4:12 PM by 3milio | Created: May 10 at 8:02 AM by Skalp

Set value of certain cells causes the cell to blank

I have a excel spreadsheet template created in excel. One of my cells has text in it like this "blah blah blah[blah_replacement] blah". I'm able to see the text using EPP in my code correctly usi...

Id #15617 | Release: None | Updated: May 2 at 7:53 PM by ckasturi | Created: May 2 at 7:52 PM by ckasturi

AutoFitColumns ignores content width of wrapped text

I am trying to programmatically insert values separated by newlines, then autofit the cell width to the longest value. In Excel 2007, this can be done by: Type in: 1234567890(Alt-Enter)123456(Alt...

Id #15616 | Release: None | Updated: May 1 at 6:26 PM by seanevanm | Created: May 1 at 6:26 PM by seanevanm

'OfficeOpenXml.Packaging.Ionic.Zip.BadReadException' in EPPlus.dll

I am using EPPlus in VS to read in roughly 300+ excel files, each around 5-15MB. The output will be written to a single excel file. Sometimes i get the error "'OfficeOpenXml.Packaging.Ionic.Zip....

Id #15615 | Release: None | Updated: May 1 at 4:24 PM by RoyBJY | Created: May 1 at 4:18 PM by RoyBJY