Can the code access a read only version when the excel file is open by a user

Just wondering if there is such an option. If the xlsx file is open, I get this message: The process cannot access the file <file_name> because it is being used by another process. Is there a...

Id #15315 | Release: None | Updated: Jul 30 at 9:01 PM by enkay | Created: Jul 30 at 9:01 PM by enkay

Removed Part: (Drawing shape)

I have verified was is happening by inspecting the unpacked XLSX file. This is similar to issue 15167. When deleting one existing worksheet from an existing workbook with multiple worksheets that...

Id #15314 | Release: None | Updated: Jul 30 at 3:03 PM by unsprung | Created: Jul 30 at 3:03 PM by unsprung

Sorting a PivotTable on Count (DataTable)

I can not find a way to sort the DataField colloumn in a PivotTable. The RowField works fine. Is there away? More information take a look at the StackOverflow post: http://stackoverflow.com/q...

Id #15313 | Release: None | Updated: Jul 30 at 12:15 AM by HansOM | Created: Jul 30 at 12:15 AM by HansOM

Modify Table Range in DataModel corruption

See writeup in StackOverFlow Using EPPlus I read an XLSX file. I replace the data in a table and set the table range. When I open the resulting spreadsheet I get an error: "We found a problem w...

Id #15312 | Release: None | Updated: Jul 30 at 8:47 PM by MarownIOM | Created: Jul 29 at 9:29 PM by MarownIOM

Adding comments in more than one worksheet causing excel to be corrupted

We have an requirement to add comments in multiple worksheets with in workbook, I added the below code Worksheets["A"].Cells[1, 1].AddComment("Testing", "Test1"); While saving this workbook I ...

Id #15311 | Release: None | Updated: Jul 28 at 9:51 PM by gthangavelu | Created: Jul 28 at 9:51 PM by gthangavelu

ExcelWorksheet.DeleteColumn() doesn't remove the column

When I call ExcelWorksheet.DeleteColumn(int column), the column data is simply cleared out. How do I remove the column itself? I tried using the solution on this page: http://stackoverflow.com/qu...

Id #15310 | Release: None | Updated: Jul 28 at 5:38 PM by rboada04 | Created: Jul 27 at 11:33 PM by rboada04

ExcelRange public ExcelRange this[...] resets calling range

I might be using this incorrectly, but suppose you have the following range set: ExcelRange DataRange = ws.Cells[1, 1, 5, 5]; And wanted to access a specific cell in that range: ExcelRange MyRange...

Id #15309 | Release: None | Updated: Jul 28 at 12:50 PM by origfla | Created: Jul 25 at 3:01 AM by origfla

Table name not unique

When I am trying to add Two table in the same Worksheet or different worksheet in the same workbook then I am getting error- Table name not unique. How to give different name to table? wsDt1.Ce...

Id #15308 | Release: None | Updated: Jul 23 at 9:55 PM by zippy1981 | Created: Jul 23 at 7:16 PM by anilmaskara

End then arrow key navigation not working

Hi On spreadsheets created using EPPlus the End then arrow key navigation does not work. When on a cell if you press End then Down the next non empty cell below the current cell should be selec...

Id #15307 | Release: None | Updated: Jul 28 at 7:41 AM by mrboring | Created: Jul 23 at 8:21 AM by mrboring

EPPlus limitations

Hi readers, Are there any known limitations or issues with EPPlus? If yes please share a consolidated list of limitations. Thanks.

Id #15306 | Release: None | Updated: Jul 22 at 9:59 AM by TejasSutar | Created: Jul 22 at 9:59 AM by TejasSutar