Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Chart

Issue opening excel file

  • FlowHeater-Team
  • avatar Topic Author
  • Offline
  • Admin
  • Admin
More
14 years 1 month ago #2034 by FlowHeater-Team
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


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
  • avatar Topic Author
  • Offline
  • Admin
  • Admin
More
14 years 1 month ago #2035 by FlowHeater-Team
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.

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.

More
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

Attachments:

Please Log in or Create an account to join the conversation.

  • FlowHeater-Team
  • avatar Topic Author
  • Offline
  • Admin
  • Admin
More
14 years 1 month ago #2037 by FlowHeater-Team
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?

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.

More
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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.286 seconds
FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.