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

excel import/export broken in

Jul 6, 2015 at 11:14 AM
Edited Jul 6, 2015 at 11:17 AM
importing excel files appears broken in my project after the latest update, existing files that used to import ok, no longer import.
I'm getting an
InvalidCastException: Unable to cast object of type IEnumerable<string> to IList<String> at importmultiplesheets.....

I've tried exporting a fresh excel file, and reimporting it, same problem.

is it just me?

thanks for any info


i've just tried this on a different project, export/import works in single sheet mode, fails with the above error with multiple sheets.
Jul 6, 2015 at 11:47 AM
ImportMultipleSheets method needs

this (@Line 203)
var data = (IList<IList<string>>)rows.Select(row => row.GetCellValues(sharedStrings)).ToArray();
changing to this
 var data = (IList<IList<string>>)rows.Select(row => row.GetCellValues(sharedStrings).ToList()).ToArray();
Jul 24, 2015 at 2:49 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.