This project has moved. For the latest updates, please go here.

Epplus corrupt style after package save - Office 2013

Jul 21, 2014 at 2:30 PM
Edited Jul 23, 2014 at 8:41 AM
I am using EPPlus 4.0 beta 2 and writing in c#. I opened excel file (Office 2013), modified content and saved package with using EPPlus. Then I open file and file styles are corrupted. The Problem is after calling method save() on package.
Is any way to fix it? Will EPPlus develop to compatible with Office 2013?
Oct 12, 2015 at 2:51 PM
Edited Oct 13, 2015 at 9:51 AM
Hello, I'm facing the same problems, but with big files only (~10MB Size). (Version 4.0.4)
  • It takes very long to open the xlsx-File (~15 Minutes)
  • Then Excel comment that the file seems corrupt
  • After repairing, the file has been opened but all hyperlinks have been removed
    (there are a lot of hyperlinks)
Is there a solution for Big Files (with hyperlinks) in Office 2013 with a new version on the way?

thanks and kr
Phil
Oct 13, 2015 at 11:05 AM
Ok I've recognised that the root of the problem is the amount of hyperlinks in the xlsx-document.

In my case there were more than 118'000 rows and each row has had a cell with a hyperlink. => 118'166 hyperlinks ...

In the c#-Code, I've limited the creation of hyperlinks to <=10'000 and this solved the problem..