Blue Prism Product

last person joined: 12 minutes ago 

Chat about Blue Prism products
Expand all | Collapse all

errormessage when import csv

  • 1.  errormessage when import csv

    Posted 27 days ago
      |   view attached
    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
    ------------------------------

    Attachment(s)

    pdf
    Error in import csv.pdf   40K 1 version


  • 2.  RE: errormessage when import csv

    Posted 27 days ago
    Hi Kristian,

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

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



  • 3.  RE: errormessage when import csv

    Posted 26 days ago
      |   view attached
    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
    ------------------------------

    Attachment(s)



  • 4.  RE: errormessage when import csv

    Posted 26 days ago
    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
    ------------------------------