Handling huge ExcelWorksheet

Hello, I'm using EPPlus to create xls report on daily and weekly basis. But sometimes the timeline is greater than one year and, in my last case it was three year, so the total amount of rows are...

Id #15185 | Release: None | Updated: Today at 2:05 PM by Barbacan | Created: Today at 2:03 PM by Barbacan

Load and save the specific xlsx-file produces content unreadable by Excel

Hi All! My problem is -- loaded and saved back xlsx-file can not be loaded by Excel (v. 2010) because of Excel application founds unreadable content and proposes to recover the contents of the wo...

Id #15184 | Release: None | Updated: Tue at 4:25 PM by romanloubet | Created: Tue at 4:25 PM by romanloubet

Open excel file with workbook protection failed

Hi All, I can't open excel file (2007) with workbook protection. Using FileInfo or FileStream lead to an exception with or without password. The same excel file saved with excel 2010 works. Is t...

Id #15183 | Release: None | Updated: Tue at 3:00 PM by romanloubet | Created: Tue at 7:52 AM by Cyril_Baurand

Demo to reproduce unmerge error

Hi friends This is the demo to reproduce this error Regards, Nicholls

Id #15182 | Release: None | Updated: Tue at 4:05 PM by jdnichollsc | Created: Jan 23 at 9:09 PM by jdnichollsc

Workbook.Worksheets.Add from template does not copy column widths

With the new version 4.0.2: FileInfo newFile = new FileInfo("xxxx.xlsx")); FileInfo templateFile = new FileInfo("y.xlsx"); var excelPackage = new ExcelPackage(newFile, templateFile); worksh...

Id #15181 | Release: None | Updated: Jan 23 at 8:11 PM by darko_petreski | Created: Jan 23 at 7:20 PM by darko_petreski

EPPlus seems to be removing the spaces between words in cells

I have a weird problem. It seems that when I use EPPlus to export a GridView to an Excel spreadsheet, the library strips out all of the spaces between words in the cells, adds  's to the empty cel...

Id #15180 | Release: None | Updated: Sun at 5:30 AM by ShauneS | Created: Jan 22 at 11:25 PM by ShauneS

Delete rows after unmerge a range of cells return a exception

Hi guys! I detected that delete rows after unmerge a range of cells return a null reference exception worksheet.Cells["E3:F3"].Merge = false; worksheet.DeleteRow(2, 6); Thanks in advance, Nich...

Id #15179 | Release: None | Updated: Mon at 2:26 PM by jdnichollsc | Created: Jan 21 at 9:37 PM by jdnichollsc

Set StyleID from other cell no copy the horizontal aligment

Gi guys! :D When I set StyleID from other cell destinationCell.StyleID = sourceCell.StyleID; the output is the following (the horizontal alignment is wrong) Because when I copy the horizont...

Id #15177 | Release: None | Updated: Jan 20 at 2:46 PM by jdnichollsc | Created: Jan 20 at 2:46 PM by jdnichollsc

read date value as displayed to the user

I am using EPPlus to read excel data. I need to display the excel cells as-is in the grid to the users. When I do get value to get the value for date column it giving the OADate int value for the...

Id #15176 | Release: None | Updated: Jan 20 at 1:39 PM by hgrathi | Created: Jan 20 at 1:39 PM by hgrathi

Cell value ToString() function return error

Hi friends! :D When I get value from one cell I have an error //cell.Value == 0; string val = cell.Value.ToString(); //Return 0.00000000 and not only 0 Thanks in advance, Nicholls

Id #15175 | Release: None | Updated: Jan 19 at 2:30 PM by jdnichollsc | Created: Jan 19 at 2:30 PM by jdnichollsc