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

How to do Color "Excel Cell"

Hi All How to do Color "Excel Cell"?     Regards, mcamail2002@gmail.com

Id #31456 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by mcamail2002 | Created: Sep 15, 2011 at 2:58 PM by mcamail2002

How to read 2003 Excel Fileformat data with out installing Office 2003

Hi,   I need to read the data from excel 2003 (xls) file format but i don't want to install Office 2003 in the server. Is it possible to read the data's by using any assembilies.

Id #30758 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by Nagamanickam | Created: May 26, 2011 at 11:23 AM by Nagamanickam

Error while usine excel 2003 template

I got error "file contains corrupted data" while using excel 2003 template to create excel report.

Id #26468 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by Nagamanickam | Created: Mar 13, 2010 at 5:03 AM by satyajitn

Hiding Rows

Hi,   Is there a way to hide the Excel rows? I am using the code which has the performance fix with Load function. This creates Excel sheet based on the XML generation and attributes set to it. So ...

Id #26430 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by PBalanagendra | Created: Mar 8, 2010 at 10:51 PM by PBalanagendra

System.OutOfMemoryException when dealing with large amount of data

Hi,   I am trying to implemnt excelpackage to eport large amount of data (approximately 90,000 rows with 20 columns). While saving the worksheet, I am getting 'System.OutOfMemoryException'.   Pleas...

Id #26125 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by sowji250 | Created: Feb 3, 2010 at 8:14 PM by sowji250

System.OutOfMemoryException when dealing with large amount of data

Hi,   I am trying to implemnt excelpackage to eport large amount of data (approximately 90,000 rows with 20 columns). While saving the worksheet, I am getting 'System.OutOfMemoryException'.   Pleas...

Id #26124 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by sowji250 | Created: Feb 3, 2010 at 8:09 PM by sowji250

Error opening Excel file created from ExcelPackage

File, saved from this package, shows "Excel found unreadable content ... " message when the Excel file is opened. Is there any resolution for this? Please let me know.

Id #25888 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by PBalanagendra | Created: Jan 11, 2010 at 4:23 AM by PBalanagendra

some error with ms ex2007 file

Hello,   i dont know where can I write this correction. Example with template its ok. But when I creating my own excel file in Microsoft Excel 2007, it is problem. Causes in ExcelWorksheet.cs on li...

Id #25382 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by peterkucera | Created: Nov 18, 2009 at 4:28 AM by peterkucera

Cannot add dates formatted in Swiss-German style

I really enjoy the ExcelPackage component - unfortunately, I cannot seem to add dates formatted in the Swiss-German style "dd.MM.yyyy" to the output sheet.   When I do so, I get a message about "in...

Id #24655 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by jsetzer | Created: Sep 16, 2009 at 8:37 AM by mscheuner

Problem with decimal numbers

I'm opening the file that has a 5.1 (or 5,1 - depanding on regional settings) in a cell. When calling worksheet.Cell(7, 5).Value I expect to receive "5.1", whereas I receive "5.0999999999999996". ...

Id #23424 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by dleblanc | Created: Jul 8, 2009 at 2:52 PM by wosiu

Unable to calculate Range, get_range

Unable to Calculate Range, get_range using ExcelPackage

Id #23398 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by s4saravanan | Created: Jul 7, 2009 at 1:18 PM by s4saravanan

ExcelRow.Height can not be retrieved - period vs. comma issue

Hi, this is similar to Item #7537 but is more a bugReport.   When I want to read the ExcelRow.Height a FormatException occurs. This might be hard for some of you to simulate.   It is a matter of pe...

Id #22495 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by BayerMeister | Created: May 20, 2009 at 7:20 AM by BayerMeister

Excel Cell Styles

A few people have asked for style in Excel Cells and nobody have really come up with a solution so I have done some work to get it done. I have unfortunately not been able to complete it because of...

Id #21845 | Release: None | Updated: Dec 4, 2013 at 10:13 PM by sola_mhb | Created: Mar 30, 2009 at 2:35 PM by mieliespoor

Scientific Notation in Cells

When trying to write values to a cell, the code doesn't recognize it as a number as outputs as a string in excel.   My proposed solution is to replace the regular expressions in ExcelCell.cs:   Reg...

Id #21776 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by mieliespoor | Created: Mar 25, 2009 at 7:02 PM by bbloudek

System.Exception: ExcelCell Constructor: Negative row and column numbers are not allowed at OfficeOpenXml.ExcelCell..ctor(ExcelWorksheet xlWorksheet, Int32 row, Int32 col) in ExcelCell.cs:line 68

if (row < 1 || col < 1) throw new Exception("ExcelCell Constructor: Negative row and column numbers are not allowed");   0 (zero) is not negative number -)   Most programmers expect indexing to sta...

Id #21217 | Release: None | Updated: Dec 17, 2013 at 11:38 AM by Basha | Created: Feb 17, 2009 at 3:41 PM by bpipe

Excel File

Unable to load file.

Id #19518 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by vijai_soft | Created: Nov 13, 2008 at 6:37 AM by vijai_soft

System.ApplicationException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) exception

Any idea how to fix this exception? My program get a datatable from sql DB and save all fields to excel file. Sometime will get following error     System.ApplicationException: Access is denied. (E...

Id #17586 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by bralm | Created: Jul 30, 2008 at 2:15 AM by szmulder

It's works great!

it's a very good tools to create excel file. But the file size is big. any idea how to reduce the size?   for example it's carete a 4mb file. I using excel 2007 and do save as. The size reduce to 4...

Id #16566 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by lsdeans | Created: May 14, 2008 at 1:43 AM by szmulder

NullReferenceException

ExcelWorksheet.cs - line: 561 XmlNode pageSetup = _worksheetXml.SelectSingleNode("//d:pageSetup", NameSpaceManager);   _worksheetXml is null when creating new document from template. I repaired it ...

Id #15479 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by haribo256 | Created: Mar 6, 2008 at 9:49 AM by dreamer_zl

Add support for Export XML

Inside Excel, when cells in the spreadsheet are bind to elements in a XML Schema, we are able to export the data as an XML instance of the schema. So far no server side solution to do so.

Id #14711 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by nadro | Created: Jan 11, 2008 at 8:00 AM by patrickyong

Implement ExcelWorksheets.Copy

What is the status of getting this implemented? I'm sure this can get very complicated, but it would be nice to have at least a generic or simple version.

Id #13135 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by Kaltar | Created: Oct 5, 2007 at 2:05 PM by exnels2

File contains corrupted data

I just downloaded the most recent version of the binary. We have a costing spreadsheet that we use to build proposals. Unfortunately I cannot attach the file. It was created in Excel 2000. I op...

Id #13074 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by camluc | Created: Oct 3, 2007 at 3:20 PM by gregchak

Force recalculation of formulas

When dumping data to a template sheet containing formulas, formula results are not updated when you open the sheet, as the formula cells contains values already and Excel does not update them regar...

Id #10667 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by aemadhavan | Created: May 30, 2007 at 4:27 PM by JCOberholzer

Error in UpdateFormulaReferences

Try this one: string sFormula = "=A1 + A2 & \"This is a test of adding a row in front of A1\"";   Console.Out.WriteLine("Before: {0}", sFormula); sFormula = UpdateFormulaRe...

Id #10628 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by roderickkranendon | Created: May 29, 2007 at 6:07 AM by maartenba

speed-up writing large xlsx files

I have noted that when writing more than 1000 rows dramtically slowes down the document generation. I have a fast computer with etc etc and it only writes 160 rows per minute whihc is too slow for ...

Id #10409 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by Milind_Raje | Created: May 20, 2007 at 4:05 PM by magnusd

ExcelCell.cs UpdateFormulaReferences Error?

I had a formula similar to =IF(G6=0, " ", G8/G6). UpdateFormulaReference failed to reassemble this function correctly. The resulting xlsx document had errors.

Id #10174 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by tedshroyer | Created: May 9, 2007 at 5:53 AM by tedshroyer

Cells calculation update

When changing a value of a cell in the runtime which is a part of another formula cell the calculation is not updated in the formula cell. for example: if there are a total cell C3 which get its va...

Id #9854 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by quachnguyen | Created: Apr 25, 2007 at 2:59 PM by kmusaied

Merge Cells

The ability to merge cells would be great.   At the very least, not un-mergeing cells that were merged in the original spreadsheet when you open it and then re-save it would be nice.

Id #9175 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by dleblanc | Created: Mar 27, 2007 at 2:36 PM by davehutz

Strings with single quotes

The shared string implementation does not properly escape singel quotes (and other special characters in xml) in the xpath that it uses to search, so if you try to set a cell's value to "Dave's Pro...

Id #9174 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by fljohwat | Created: Mar 27, 2007 at 1:54 PM by davehutz

Read from stream

In general I think that when reading an excel file, you will find that more people will be reading a file submitted by a user (such as in a PostedFile) rather than reading a file previously saved t...

Id #8665 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by sowji250 | Created: Mar 5, 2007 at 4:06 PM by lsdeans

Read # of Columns/Rows

When reading an excel file it seems that you must know the number of columns/rows in advance.   It seems like there should be something on the worksheet object like .Rows or .Columns, like on a Dat...

Id #8663 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by BradRoberts56 | Created: Mar 5, 2007 at 3:52 PM by lsdeans

Problem opening Excel file

I have a problem with opening a created Excel file. We have a web application that generates reports, in this case a simple report detailing amounts of revenue generated by a company. Every time t...

Id #8450 | Release: None | Updated: Oct 2, 2013 at 5:45 PM by dschonhals | Created: Feb 23, 2007 at 7:47 AM by andymarks

Save fails if you do not update something on all tabs

If you have a template file with multiple tabs you must ensure that you update at least one cell on each tab otherwise the Save() function causes an Exception.

Id #8000 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by leroylll | Created: Feb 5, 2007 at 9:29 PM by andrewjones

Support for Images

Support the insertion of binaries image files into the package and create the necessary drawing.xml, drawing.xml.rels, and relationships

Id #7994 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by adglopez | Created: Feb 5, 2007 at 7:39 PM by PaulSpiegel

Support for international settings

In some countries comma "," is used instead of "." as decimal separator. This may provoke mistakes in recognizing numbers with decimals when a value is assigned to a cell.

Id #7537 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by mscheuner | Created: Jan 22, 2007 at 11:57 PM by Nullaritorna

Provide ability to add comments to cells

This will be complicated but someone may be able to figure out how to write vml code.

Id #7252 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by leroylll | Created: Jan 12, 2007 at 4:09 PM by JohnTunnicliffe

Support "date" data type in cells

Change ExcelCell class to provide support for the "date" data type.

Id #7251 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by jsetzer | Created: Jan 12, 2007 at 4:00 PM by JohnTunnicliffe

Provide support for Charting

Create an ExcelChart class that provides support for Excel's charting capability.

Id #7250 | Release: None | Updated: Feb 22, 2013 at 12:31 AM by jmiller980 | Created: Jan 12, 2007 at 3:59 PM by JohnTunnicliffe

  • 1-48 of 48 Work Items
    • Previous
    • 1
    • Next