AsDataSet fails with excel 2010 files

Mar 7, 2011 at 2:48 PM

As the title says, the function AsDataSet fails with excel 2010 files. When I save the file with a 2007 version it works perfectly. Even more so, the function does not return any error. It simply does not create any tables in the dataset.

Please verify this is a bug and include it in the release plan.

Mar 7, 2011 at 3:08 PM

hmm, after I copied the files content to a new worksheet, saved that, everything works fine. So it must be an issue with the file itself. The only problem now is that I have no idea what that would be. The reader does not throw an error and excel doesn't report anything. Also, I've noticed that the new file (where I copied all of my contents to) is about 2-3 times smaller in filesize. Where is all that overhead coming from?