Adding hyperlink corrupts the file

I am trying to add a hyperlink (URI) to an external website from the content of a cell. It does not give any error during run-time. However, when I try to open the file, I cannot. It says that the ...

Id #35051 | Release: None | Updated: Mar 19 at 7:37 AM by Geekays | Created: Mar 19 at 7:37 AM by Geekays

Deleting a worksheet...

I noted that when I try delete a worksheet that i have created it gives me a "IndexOutOfRangeException" but if i create a worksheet into excel manually and not by ExcelPackage.Workbook.Worksheets.A...

Id #35041 | Release: None | Updated: Mar 17 at 6:44 PM by cristiano2w | Created: Mar 17 at 6:44 PM by cristiano2w

Generate xlsx file with lot of data

Hello There, I am trying to generate excel file using the ExcelPackage DLL. I have a dataset, with multiple data table. I want to put all the data from different tables to one excel file. It is wo...

Id #34947 | Release: None | Updated: Jan 30 at 9:54 AM by ashwinkhan | Created: Jan 30 at 9:54 AM by ashwinkhan

EP2P or EPPlus Excel creation Issue

Hi, I am using EP2P in my project to generate excel sheets(inside SSIS). Its working fine in lower environments, but in production its giving the below error System.IO.IsolatedStorage.IsolatedSto...

Id #34203 | Release: None | Updated: Jun 26, 2013 at 6:48 AM by murali2123 | Created: Jun 26, 2013 at 6:43 AM by murali2123

ExcelColumn.Width parsing error

While trying to get column width, which is not integer (eg. 40.25), I got FormatException - it is raised because Width getter contains "int.Parse" instead of "double.Parse". I think that changing t...

Id #33665 | Release: None | Updated: Oct 2, 2013 at 7:31 AM by MaxMommersteeg | Created: Jan 15, 2013 at 12:58 PM by Ardhad

Catastrophic failure . with merged cells

/xl/worksheets/sheet.xml part with XML error. Catastrophic failure . I am generating Excel using C#. The Excel contains merged cells. If I remove these merged cell there is no issue.

Id #32712 | Release: None | Updated: Sep 12, 2013 at 6:56 PM by MG42 | Created: May 14, 2012 at 1:18 PM by PraneetR

Getting error Converter failed to open the file

I have create Excel file using the sample code "ExcelPackageSamples". When I open the excel I get error "Converter failed to open the file". I am using Office 2003

Id #32690 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by vilasgaykwad | Created: May 10, 2012 at 3:00 PM by vilasgaykwad

Number formats and datatypes

Hello,   After opening created file by excel itself, I see that numeric areas are seen as text instead of numeric so orderings are not working properly. User needs to update these cells definitions...

Id #32126 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by domeniconeri | Created: Jan 24, 2012 at 5:14 PM by zokkan

Apostrophe in Cell Value String causes an Exception

setting the Value property of a Cell to a string that contains an apostrophe causes an XPathException:   See the following code: FileInfo newFile = new FileInfo(@"test.xlsx"); using...

Id #31571 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by rupello | Created: Oct 10, 2011 at 5:31 PM by rupello

Does this Lib support all the special charactors like , ' # .... etc

Does this Lib support all the special charactors like , ' # .... etc if yes then how. can any one me code snippet.

Id #31457 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by mcamail2002 | Created: Sep 15, 2011 at 3:30 PM by mcamail2002