This project has moved and is read-only. For the latest updates, please go here.

Creating a table

Oct 6, 2010 at 5:29 PM


I was trying to define tables in a spreadsheet using EPPlus, but I've come up against a few bugs.  I am going to send you a patch for them, but just wanted to check whether you'd already addressed any of them:

 + When using the LoadFromDataTable method to add a Table, the range that epplus selects has 1 more column than it should have

 + Setting the rowstripe to hidden causes an error at save time

 + Excel complains about the display name if it contains non alphanumberic characters

 + Excel complains if you don't set a style because EPPlus leaves the attribute blank

 + When adding a table, there is no common store of TableID is not incremented, so if a spreadsheet contains more than one table there is an error at save time.  Excel appears to scope tables to the workbook, so the table Ids have to be unique across the whole thing. EPPlus assumes they are unique in the worksheet.

As I say, I'm happy to sort out patches for all of these if it's no trouble/not duplicating anything else.

Thanks for a great library!



Oct 7, 2010 at 6:29 AM

Great!, thanks