Unable to copy a worsheet from one workbook to another workbook in Office Open XML

We are working Web API and using Office Open XML for Excel data. When we tried to copy an ExcelWorksheet from one Workbook to another Workbook in ExcelPackage: 1.The option is not present in the ...

Id #35616 | Release: None | Updated: Oct 14 at 7:08 AM by Geekays | Created: Oct 13 at 4:02 PM by basavarajwadi

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 5:24 PM by billiam904 | Created: Jun 26 at 5: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 11:05 AM by aravindmunna | Created: Apr 25 at 11: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 11:01 AM by JainPrince | Created: Mar 19 at 8: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 7:44 PM by cristiano2w | Created: Mar 17 at 7: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 10:54 AM by ashwinkhan | Created: Jan 30 at 10: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 7:48 AM by murali2123 | Created: Jun 26, 2013 at 7: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 8:31 AM by MaxMommersteeg | Created: Jan 15, 2013 at 1: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 7:56 PM by MG42 | Created: May 14, 2012 at 2: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 1:31 AM by vilasgaykwad | Created: May 10, 2012 at 4:00 PM by vilasgaykwad