Issue in SSIS Debug mode not finding EPPlus.dll

I created a new SSIS project in BIDS (Visual Studio) 2008 and created a C# script task. I set the framework to 3.5 and added a reference to EPPlus.dll. I am getting the following error when attem...

Id #35328 | Release: None | Updated: Jun 26 at 4:24 PM by billiam904 | Created: Jun 26 at 4:24 PM by billiam904

Reading "excel" file using openxml concept

environment : no ms office installed. Hi, i tried reading the excel file in the environment by open xml concept ,where the ms office is not installed.It worked fine. but if a cell value contai...

Id #35156 | Release: None | Updated: Apr 25 at 10:05 AM by aravindmunna | Created: Apr 25 at 10:04 AM by aravindmunna

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: Jun 2 at 10:01 AM by JainPrince | 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