Skip to main content
  • EN

Using a reader to consume a pretty basic spreadsheet, but loading it fails with the following message:

 

Excel Reader: Failed to open the dataset 'C:\path\to\file.xlsx'. Error message was 'Length too short' 
A fatal error has occurred. Check the logfile above for details
Failed to read schema features from dataset 'C:\path\to\file.xlsx' using the 'XLSXR' reader

 

This file has ~450 rows. Other files generated by the same system work just fine. The only difference between this file and the last one that worked is row count, around 150.

@jmcarthur​  You'll probably either have to attach the data file here or open a case with Safe Support. Please also include the version of FME you're using.

@jmcarthur​  You'll probably either have to attach the data file here or open a case with Safe Support. Please also include the version of FME you're using.

I'll look into opening a support request. I can't post the file as it contains sensitive data, but it appears there might be a row limitation in the Excel reader. I cropped the data to 101 rows (header + 100 rows) and the Reader didn't puke.

After deleting all but 100 rows, saving, Ctrl+Z to bring them back, and saving, the dataset was loaded into the reader and the job ran. No idea what's going on with this.

It looks like this issue may be isolated to this particular workbook (possible corruption). We found that simply by opening the .xslx file in Excel and saving the file resolved the issue. If you are experiencing the same behaviour, first try opening the file in Excel and saving the file in Excel before reading it into FME Workbench.

 

If that doesn't resolve the issue or if this is occurring with multiple files, please file a case so our team can look into what might be causing this issue!

Reply


Community Stats

30,186
Posts
114,577
Replies
37,852
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.