Can you open your excel file via MS Excel 2007 without any errors or warning messages? How have you created the Excel file that you want to export? Perhaps with a previous FlowHeater definition? In this case the errors occur from this. By now FlowHeater can only create the default Excel file supported by the Excel version you have installed on your machine.
Excel 97-2003 = xls
Excel 2007/2010 = xlsx
To fix this you have only to use the .xlsx extension for the file name in the
unluckily also the test file attached can't be read by flowheater.
anyway, i succesfully managed to read the file after changing the "standard and format" option, under control panel-->regional and language option, from italian to english uk.
basically, my version of excel is in english language, and so, i've had to change the regional and language option of the pc to english, in order to make flowheater able to read the excel file (in other words, the "language" selected under the regional and language option must be the same of the excel version installed).
obviously, this is a workaround 'cause i'd like to use my preferred language option, instead of changing it.
You can download a workaround (BETA) version of FlowHeater
. In this version we switch the current culture to en-GB.
NOTE: If you create new FlowHeater definitions with this version, the number and date/time format is set by default to this culture. You must switch manually the format settings to it-IT in the
adapter format settings
if you want to use Italy format for number and date/time. E.g. for CSV input or output.
You can use both versions at the same time. You just have to use this BETA Version only for Excel imports/exports.
In the next release version (1.2.4) we fix this issue.
Hope you can work with this little workaround for the next few days?
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.