Excel cannot open password protected package

When I try to open a password protected file, after typing the password into the pop-up Excel then displays the error message: "Excel cannot open the file 'myfile.xlsx' because the file format or...

Id #15540 | Release: None | Updated: Fri at 12:04 PM by DaveyM | Created: Wed at 5:34 PM by DaveyM

Get all the VBA macros of a workbook

Hello, In "Sample15.cs", I see that EPPlus can write/inject VBA macros. However, I don't see how to read all the VBA macros from a workbook. Does EPPlus support this functionality? Thank you ...

Id #15539 | Release: None | Updated: Sep 20 at 3:44 PM by TimurSoft | Created: Sep 20 at 3:44 PM by TimurSoft

EPPlus Breaks Table Formulas

I have an xlsx file with two worksheets. The first worksheet has a table that is populated by the second worksheet. With just opening it as an EPPlus package and saving the package, the table is ...

Id #15538 | Release: None | Updated: Sep 15 at 3:37 PM by musicalfish8 | Created: Sep 15 at 3:36 PM by musicalfish8

ExcelDataValidation missing showDropDown attribute

When using List validation, it is sometimes beneficial to not provide a drop-down menu for the options. Unfortunately, the "showDropDown" attribute is not recognized by ExcelDataValidation and Ex...

Id #15537 | Release: None | Updated: Sep 14 at 10:04 PM by richardtallent | Created: Sep 14 at 10:04 PM by richardtallent

New file corrupt

-- EDIT -- Apparently the library takes everything from an existing file, this includes empty files. (Line 5 of my code.) So for some reason, using an empty file the relation between root and /xl...

Id #15536 | Release: None | Updated: Sep 15 at 10:36 AM by MusicDemon | Created: Sep 13 at 10:58 PM by MusicDemon

Response.AddHeader - Value does not fall within the expected range

Hello All, I am trying to export a file following the code and examples provided here. Using VS 2015. It continually errors at the Response.AddHeader line, stating "Value does not fall within the...

Id #15535 | Release: None | Updated: Sep 13 at 10:36 PM by Darty17 | Created: Sep 13 at 10:36 PM by Darty17

Page Break Problem

Hi, i might be wrong about this. I tried creating a row page break in EPPLUS and it looks like this in XML: <x:rowBreaks count="2" manualBreakCount="2" xmlns:x="http://schemas.openxmlformats.o...

Id #15534 | Release: None | Updated: Sep 12 at 11:23 AM by iamshotgun | Created: Sep 10 at 7:57 AM by iamshotgun

LookupColor always returns black

Hi Has this bug resurfaced again in the latest version? I've just downloaded 4.1 and experiencing this behavior? I found the same issue that was fixed on the past and now I wonder if it has mad...

Id #15533 | Release: None | Updated: Sep 9 at 1:42 PM by EM1L | Created: Sep 9 at 1:42 PM by EM1L

ExcelWorksheet.Calculate() takes long time to calcuate

Coding Language-C#.Net 4.5 Version-EPPlus 4.1 I have generated Excel using EPPlus. Excel has 7,20,000 rows and 43 columns and 20 columns have formulas. When ExcelWorksheet.Calculate() is execut...

Id #15532 | Release: None | Updated: Sep 9 at 12:10 PM by bvira | Created: Sep 9 at 12:10 PM by bvira

Update worksheet data which is source of Pivot table in other worksheet using EPPlus

I have already code using EPPlus which loads data using LoadFromDataTable in worksheet. It first creates worksheet named Result. if worksheet already exists in the Workbook, it deletes only Result ...

Id #15531 | Release: None | Updated: Sep 8 at 5:21 AM by paaresh | Created: Sep 8 at 5:21 AM by paaresh