topic errormessage when import csv in Product Forum

errormessage when import csv

KristianHolm1 — Thu, 01 Oct 2020 12:31:00 GMT

Hi Blueprism support I have an error message when I using the VBO object Import CSV:

Want to create a excel xlsx file from the csv file.

I have attached a description file to the message.

greetings

------------------------------
Kristian Holm
RPA programmer
PenSam (Pension Company)
Copenhagen Denmark
------------------------------

RE: errormessage when import csv

gmarquez — Thu, 01 Oct 2020 13:26:00 GMT

Hi Kristian,

This is an excel error. We have the following KB about it:

Why do I get error "HRESULT: 0x800200B (DISP_E_BADINDEX)" when using MS Excel?

When automating Excel using the MS Excel VBO, you may be experiencing the following error:

"Could not execute code stage because exception thrown by code stage: Invalid index. (Exception from HRESULT: 0x800200B (DISP_E_BADINDEX))"

The error indicates that an incorrect reference to the Excel Workbook or Worksheet is being used.

How to resolve this issue

Double-check the parameters being used for the input and output of the Action being used for the VBO.

Also, please also see the following online article:
https://stackoverflow.com/questions/28830758/exception-from-hresult-0x8002000b-disp-e-badindex-for-system-runtime-interops

------------------------------
Gabe Marquez
Technical Support Engineer
Blue Prism
------------------------------

RE: errormessage when import csv

KristianHolm1 — Thu, 01 Oct 2020 15:41:00 GMT

Hi Blueprism is the issue wrong parameter setup from me.?

Should there be two files in the directory path.?
path = path/Filename csv
Destinaton = path/Filename xlsx

Worksheet in the excel will have the name from the Filename when you use VBO Write Text File.

Have uploaded the two files from path and destination from the VBO Import CSV in a zip file

Greetings

------------------------------
Kristian Holm
RPA programmer
PenSam (Pension Company)
Copenhagen Denmark
------------------------------

RE: errormessage when import csv

NicholasZejdlik — Fri, 02 Oct 2020 14:48:00 GMT

Your destination workbook name appears to be off. After creating the Excel instance, you'll need to make a call to either Create Workbook or Open Workbook. Both of those actions output the Workbook Name, which is what Import CSV is looking for as the Destination Workbook.

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------