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: Error HRESULT Excel opening

Error HRESULT Excel opening 5 years 10 months ago #2083

  • Francis
  • Francis's Avatar
  • Offline
  • New Member
  • Posts: 13
Hi Robert!

I have done many imports with this tool by now and I strangly get the error that I joined as attachment, whatever the Excel I try to open.

I used to have Office 2007. Here's the thing I tried to deal with this in order.

- Delete Registry CURRENT_USER_KEY for Excel
- Repair my Office 2007
- Reinstall Office 2007
- Install Office 2003
- Reinstall FlowHeater

Still get the problem, I tought it might be the path that contains > 255 caracs, but wasn't this too.

Do you have any idea ?? it was working well and i'm not sure about what I've done to get now this error.

Thanks !
Attachments:
The administrator has disabled public write access.

Re:Error HRESULT Excel opening 5 years 10 months ago #2084

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi Francis,

Please have a look to the two links below. I think this workaround will solve your problem.

Bug fixed: Excel Adapter and variant MS Excel language versions!

Issue opening excel file
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.
Last Edit: 1 year 10 months ago by FlowHeater-Team.
The administrator has disabled public write access.

Re:Error HRESULT Excel opening 5 years 9 months ago #2091

  • Francis
  • Francis's Avatar
  • Offline
  • New Member
  • Posts: 13
Hi Robert ! The key I put into my register make this works well !

But by now i'm expecting a problem probably because of this with ForFiles command :S

I used this function a lot in the past : Here's what I do

I have 3 files :

Type-1-1.xls
Type-1-2.xls
Type-1-3.xls

other files are like Type-2 etc..

So I'm doing this command

forfiles /M Type-1-*.xls /C "cmd /c ..\..\..\..\..\BIN\FHBatch.exe /ReadFileName @path 2-Link-tblensembleunepiece-Type-1.fhd"

The first one work, the 2 others, "Invalid Bad Index" like the screen shot
Attachments:
The administrator has disabled public write access.

Re:Error HRESULT Excel opening 5 years 9 months ago #2092

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Please try to import the second excel file manually like

FHBatch.exe /ReadFileName Type-1-2.xls 2-Link-tblensembleunepiece-Type-1.fhd

I think the error message appears because in your other excel files (second and third) the worksheet name you have specified in the Excel Adapter isn’t available?
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.
Moderators: FlowHeater-Team
Time to create page: 0.080 seconds