Using FME Desktop 2017.1.0.0 (20170731 - Build 17539 - WIN64) reading an Excel xlsx file on Windows fails and returns the following error:
...|ERROR |Excel Reader: Could not open file '...\input.xlsx', file is too large. Try
switching to 64-bit FME, or exporting the Excel file to CSV. If the file is exported to
CSV, formulas and formatting will be lost...
The file is 47KB, has 2 sheets with a couple of rows and columns. The data is imported with a Query from 2 csv files, what might cause the problem.Converting to CSV is not an option as this is part of an repetitive automatized process.Copy pasting the data to a new excel document / saving the file as xls solved the problem. But I would like to keep the source data original as I want to integrate this in FME server / external application.I did discuss this issue earlier with @Mark2AtSafe on StackExchange when the forum was down, but wanted to register the topic at the right place.