Skip to main content
Solved

excel reader issue


pearly1
Contributor
Forum|alt.badge.img+5

anyone know why Im getting these errors. Its an export to excel from gogov. I think the export is a bad file format?

Excel Reader: Failed to open the dataset 'R:\Rubicon FME\GoGOV\Input\**\*.xlsx'.  Error message was 'File does not exist'
Excel Reader: Failed to open the dataset 'R:\Rubicon FME\GoGOV\Input\*.xlsm'.  Error message was 'File does not exist'
Excel Reader: Failed to open the dataset 'R:\Rubicon FME\GoGOV\Input\report (17).xls'.  Error message was 'It is not a xls file. Use the xlCreateXMLBook() for a xlsx file.'
Failed to obtain any schemas from reader 'XLSXR' from 3 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information
Workspace generation failed.  Parameter file was C:\Users\pearly\AppData\Local\Temp\FME_1750261216546_26960.
 

Best answer by alexbiz

This file is not an Excel file. Opening it with a text editor show HTML code.

View original
Did this help you find an answer to your question?

2 replies

alexbiz
Enthusiast
Forum|alt.badge.img+12
  • Enthusiast
  • Best Answer
  • June 18, 2025

This file is not an Excel file. Opening it with a text editor show HTML code.


pearly1
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • June 18, 2025

Thanks ​@alexbiz I would not have figured this out! 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings