excel import/export broken in 1.0.0.57?

Jul 6, 2015 at 10:14 AM
Edited Jul 6, 2015 at 10: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

john

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 10: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();
John
Coordinator
Jul 24, 2015 at 1:49 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.