Issue opening excel file
- FlowHeater-Team
- Topic Author
- Offline
- Admin
Less
More
14 years 1 month ago #2034
by FlowHeater-Team
Best wishes
Robert Stark
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.
Issue opening excel file was created by FlowHeater-Team
support request received via email
hi,
i’ve just bought flowheater designer + batch, but i have a problem with the excel adapter (read side).
when i open the excel file, an error message appears: old format or invalid type library (see the attached screenshot)
i am using windows xp (italian language) with office 2007 (english language).
please, can you give me your feedback about?
thank you
best regards
gennaro
hi,
i’ve just bought flowheater designer + batch, but i have a problem with the excel adapter (read side).
when i open the excel file, an error message appears: old format or invalid type library (see the attached screenshot)
i am using windows xp (italian language) with office 2007 (english language).
please, can you give me your feedback about?
thank you
best regards
gennaro
Best wishes
Robert Stark
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.
Attachments:
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Topic Author
- Offline
- Admin
14 years 1 month ago #2035
by FlowHeater-Team
Best wishes
Robert Stark
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.
Replied by FlowHeater-Team on topic Re:Issue opening excel file
Hello Gennaro,
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 excel configurator .
If the error still exists we need a bit more information. Please try the example in the attachment. The example just exports an .xslx Excel workbook 2007 file to a csv text file .
If this example runs on your machine please post your Excel workbook file for further analysis.
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 excel configurator .
If the error still exists we need a bit more information. Please try the example in the attachment. The example just exports an .xslx Excel workbook 2007 file to a csv text file .
If this example runs on your machine please post your Excel workbook file for further analysis.
Attachment excel_test.zip not found
Best wishes
Robert Stark
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.
Attachments:
Please Log in or Create an account to join the conversation.
- Gennaro
- Offline
- User
Less
More
- Posts: 27
14 years 1 month ago #2036
by Gennaro
Replied by Gennaro on topic Re:Issue opening excel file
first of all, thanks for the reply.
unluckily also the test file attached can't be read by flowheater.
anyway, i successfully 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.
hope it helps to find a solution...
thank you
best regards
unluckily also the test file attached can't be read by flowheater.
anyway, i successfully 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.
hope it helps to find a solution...
thank you
best regards
Attachments:
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Topic Author
- Offline
- Admin
14 years 1 month ago #2037
by FlowHeater-Team
Best wishes
Robert Stark
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.
Replied by FlowHeater-Team on topic Re:Issue opening excel file
Hi Gennaro,
Thanks for the information, this helps us a lot.
You can download a workaround (BETA) version of FlowHeater here . 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?
Thanks for the information, this helps us a lot.
You can download a workaround (BETA) version of FlowHeater here . 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?
Best wishes
Robert Stark
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.
Please Log in or Create an account to join the conversation.
- Gennaro
- Offline
- User
Less
More
- Posts: 27
14 years 1 month ago #2038
by Gennaro
Replied by Gennaro on topic Re:Issue opening excel file
The beta version does the trick...
Thank you very much.
Best regards.
Thank you very much.
Best regards.
Please Log in or Create an account to join the conversation.
Time to create page: 0.281 seconds