Excel Workbook Image

I am trying to add an image to the worksheet but i am getting a error at the following line picture = ws.Drawings.AddPicture("profile" + rowIndex.ToString() + columnIndex.ToString(), image ); b...

Id #15639 | Release: None | Updated: Mon at 9:37 PM by nbenjamin | Created: Mon at 9:37 PM by nbenjamin

Replace functionality in Excel sheet

Hello, I would like to know how to replace text in Excel sheet. I have few tags like @@Customer which I need to replace with actual customer name. Please let me know. Thanks,

Id #15638 | Release: None | Updated: Mon at 7:36 PM by amitshinde | Created: Mon at 7:36 PM by amitshinde

Error "row cannot be less than 1" while using 'InsertRow' in version 4.1.0 when worksheet has broken reference in NamedRange

Our project is upgraded from 4.0.5 to 4.1.0 and noticed this error The following code results in exception "row cannot be less than 1" int xlRow = 18; using (ExcelPackage xl = new ExcelPackage(p...

Id #15637 | Release: None | Updated: Fri at 4:07 AM by tshaikh | Created: Fri at 4:07 AM by tshaikh

about EPPlus dll

Hi I am using EPPlus lib to read excel stream in my project but my CEO asking about compatibility of EPPlus and support if we will facing any issue in feature for excel file version change so...

Id #15636 | Release: None | Updated: Aug 11 at 10:56 AM by vilasborate | Created: Aug 11 at 10:56 AM by vilasborate

Enumerator skips first column if it's empty

If you have an ExcelRange for a header row, and the first column happens to be empty, the enumerator will skip the first column and cause "index out of range" exception when you loop through the ac...

Id #15635 | Release: None | Updated: Jul 27 at 6:46 AM by dreamputer | Created: Jul 27 at 6:46 AM by dreamputer

Issue(s) with PrinterSettings.RepeatColumns

Issuing a PrinterSettings.RepeatColumns on an excel file that has either been written to disk (editing an existing xlsx or issuing a package.save and then issuing a RepeatColumns) causes an error. ...

Id #15634 | Release: None | Updated: Jul 26 at 4:26 PM by CMDayton | Created: Jul 26 at 4:22 PM by CMDayton

ConditionalFormatting causing HIGH overhead

I have a process that builds a rather large spreadsheet. About 30,000 rows, roughly 300 columns. (don't knock me, I'm the developer, I tried to convince the user it was ludicrous, but what do I k...

Id #15633 | Release: None | Updated: Jul 19 at 3:41 PM by briankitt | Created: Jul 19 at 3:40 PM by briankitt

A bug when copying a worksheet (ExcelWorksheet) from one document to another

I try to copy a worksheet from one Excel document to another one and encountered a problem. I found an error in the method 'Worksheets.Add' Here is the code: private static byte[] CombineXlses(p...

Id #15632 | Release: None | Updated: Jul 17 at 8:38 AM by ahmadinurov | Created: Jul 17 at 8:38 AM by ahmadinurov

Formula which includes cell ref like "A:B" cannot copy correctly.

// with cell1.Formula == "VLOOKUP(C1, A:B, 2)" // do cell1.Copy(cell2) // then cell2.Formula == "VLOOKUP(C2, #REF!, 2)" It is probrem of ExcelCellBase::UpdateFormulaReferences() or ExcelAddressBas...

Id #15631 | Release: None | Updated: Aug 14 at 4:12 AM by anothersphere | Created: Jul 16 at 10:24 AM by narazaka

NRE when getting ExcelRange.Text from custom formatted cells

See attached example file. It can read Value but when trying to get Text throws NRE.

Id #15630 | Release: None | Updated: Jul 5 at 8:35 PM by N1ghtblade | Created: Jul 5 at 8:35 PM by N1ghtblade