excel worksheet data

  1. H

    Excel VBO - Move Worksheet Error

    Hi, Please help me out in moving the worksheet from one workbook to another. I'm getting the Bad index exception(PFA). Please help!
  2. M

    How to compare data between two different datatables in kofax?

    Hi all, I am trying to compare data in two different datatables. I'm struggle to compare.Guide me to solve this step
  3. H

    Data Extraction From Excel Using OLEDB

    Hi All, I need help on extracting data from Excel file. I cannot use MS Excel VBO - because Sheet has more than 10 duplicate column names(but data inside them is different). So if I try to extract using Excel VBO I get an error stating column name already exists in the data table. So I tried...
  4. B

    Error: Excel Get Worksheet as Collection

    Hey, I'm new at RPA/Blue Prism. I've got a problem with the Action "Get Worksheet as Collection". In the excel sheet are hidden columns. These are not found. Blue Prism returns error message: Internal: Could not execute code stage because exception thrown by code stage: Column 17 was not found...
  5. H

    Copying excel data from multilple worksheets into single worksheet

    Hi All, I have a workbook with few sheets with same headers. I have to get all the worksheets names (Did via MS Excel VBO) and then I have to copy the data from all the worksheets and paste it in a single sheet Please assist on this
Top