Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Issue opening excel file

Issue opening excel file 6 years 2 months ago #2034

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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

Attachments:
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.
The administrator has disabled public write access.

Re:Issue opening excel file 6 years 2 months ago #2035

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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

Attachments:
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.
The administrator has disabled public write access.

Re:Issue opening excel file 6 years 2 months ago #2036

  • Gennaro
  • Gennaro's Avatar
  • Offline
  • Junior Member
  • Posts: 25
First of all, thanks for the reply.

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.

Hope it helps to find a solution...

thank you

Best regards

Attachments:
The administrator has disabled public write access.

Re:Issue opening excel file 6 years 2 months ago #2037

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.
The administrator has disabled public write access.

Re:Issue opening excel file 6 years 2 months ago #2038

  • Gennaro
  • Gennaro's Avatar
  • Offline
  • Junior Member
  • Posts: 25
The beta version does the trick...
Thank you very much.

Best regards.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.082 seconds