FlowHeater - The Data Import / Export Specialist
See also the existing examples of using the Excel Adapter , which may answer your question: CSV export with grouping

Error HRESULT Excel opening

  • Francis
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 years 1 week ago #2083 by Francis
Error HRESULT Excel opening was created by Francis
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:

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

More
12 years 1 week ago - 7 years 11 months ago #2084 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Error HRESULT Excel opening
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: 7 years 11 months ago by FlowHeater-Team.

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

  • Francis
  • Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 10 months ago #2091 by Francis
Replied by Francis on topic Re:Error HRESULT Excel opening
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:

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

More
11 years 10 months ago #2092 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Error HRESULT Excel opening
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.

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

Time to create page: 0.284 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en