This project has moved and is read-only. For the latest updates, please go here.

Unable to change cell background colour, EPPlus in C#

I'm trying to verify that a cell in a row is not null. If it is null, I want to change the background colour of the cell to red. After reading how to do that, I have come up with the following code...

Id #15646 | Release: None | Updated: Sep 13 at 10:08 PM by TGills | Created: Sep 13 at 10:08 PM by TGills

Sharepoint 2013 Compatability

I deployed this over to Sharepoint 2013 on-premise and it seems like it fails with following error: "Could not load file or assembly 'EPPlus, Version=4.1.0.0, Culture=neutral, PublicKeyToken=ea15...

Id #15645 | Release: None | Updated: Sep 6 at 4:31 PM by snehalrana | Created: Sep 6 at 4:31 PM by snehalrana

Error throws while loading excel workbook using epplus if excel contains picture and empty row before the content

We are tying to read excel using EPPLUS. In this scenario, if the excel in a format like image in a first row and second row as empty and from third row main content it throws error wile loading wo...

Id #15644 | Release: None | Updated: Sep 6 at 7:04 AM by meygnanam | Created: Sep 6 at 7:04 AM by meygnanam

Insert Slicer with EPPlus

Hello, I would like to know how can I insert slicer(to filter data) with EPPlus library. Actually I created a pivot table with this library and I want to create slicer for it as we can do it in Ex...

Id #15643 | Release: None | Updated: Sep 4 at 11:46 AM by sepid_amin | Created: Sep 4 at 11:46 AM by sepid_amin

Pivot Table : System.Xml.XmlException: An error occurred while parsing EntityName. Line 1, position 2102.

Hello, I encountered issue related with pivot, Please help me. Thanks in advance any help var fileInfo = new FileInfo(path); using (var package = new ExcelPackage(fileInfo)) ...

Id #15642 | Release: None | Updated: Aug 30 at 9:04 AM by gorbatuk | Created: Aug 30 at 8:51 AM by gorbatuk

Copying array formulas creates normal formulas

ExcelPackage ep = new ExcelPackage(); ExcelWorksheet sheet = ep.Workbook.Worksheets.Add("A Sheet"); sheet.Cells[1, 1].CreateArrayFormula("IF(SUM(B1:J1)>0,SUM(B2:J2))"); //A1 sheet.Cells[2, 1].Val...

Id #15641 | Release: None | Updated: Aug 25 at 7:14 AM by AntiHeadshot | Created: Aug 25 at 7:14 AM by AntiHeadshot

Avoid modify the excel file when save with out change.

I build a tool to refresh my excel file, and the excel files is under the version control. Each time I save the excel file using EPPlus, the file modified without any change(If the meta data of th...

Id #15640 | Release: None | Updated: Aug 24 at 5:24 PM by watsonsong | Created: Aug 24 at 5:24 PM by watsonsong

Excel Workbook Image

I am trying to add an image to the worksheet but i am getting a error at the following line picture = ws.Drawings.AddPicture("profile" + rowIndex.ToString() + columnIndex.ToString(), image ); b...

Id #15639 | Release: None | Updated: Aug 21 at 10:37 PM by nbenjamin | Created: Aug 21 at 10:37 PM by nbenjamin

Replace functionality in Excel sheet

Hello, I would like to know how to replace text in Excel sheet. I have few tags like @@Customer which I need to replace with actual customer name. Please let me know. Thanks,

Id #15638 | Release: None | Updated: Aug 21 at 8:36 PM by amitshinde | Created: Aug 21 at 8:36 PM by amitshinde

Error "row cannot be less than 1" while using 'InsertRow' in version 4.1.0 when worksheet has broken reference in NamedRange

Our project is upgraded from 4.0.5 to 4.1.0 and noticed this error The following code results in exception "row cannot be less than 1" int xlRow = 18; using (ExcelPackage xl = new ExcelPackage(p...

Id #15637 | Release: None | Updated: Aug 18 at 5:07 AM by tshaikh | Created: Aug 18 at 5:07 AM by tshaikh