Error using datatable

  • Error using datatable

     calculus updated 2 weeks, 2 days ago 2 Members · 3 Posts
  • calculus

    Member
    September 1, 2022 at 6:17 pm

    Hi everyone

    I’m trying to run a flow using visual automation and a datable to input data into a webpage.

    My flow worked just fine when my datatable was an Excel workbook using a Power Query, but I broke the Power Query connection and had to redo the workbook. I now have a simple Excel workbook that has no formulas or formatting, but the flow no longer works.

    Here is my flow for one column of the Excel workbook:

    vision click(Location(1330,394))

    wait <w:sdt>2</w:sdt>

    keyboard <w:sdt>Input Date</w:sdt>

    The first row in that column of the workbook reads “Input Date” (without the quotation marks).

    When I load the workbook and try to run the flow, I get this error message:

    Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

    Details:

    System.Runtime.InteropServices.COMException (0x8002000B): Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

    at Microsoft.Office.Interop.Excel.Sheets.get__Default(Object Index)

    at TagUIWordAddIn.Ribbon1.ValidateExcelCheckBoxFields(CheckBox checkBox)

    What does this mean and how do I fix it?

    My TagUI Word and Excel add-ins are up-to-date.

    Many thanks.Hi everyone

    I’m trying to run a flow using visual automation and a datable to input data into a webpage.

    My flow worked just fine when my datatable was an Excel workbook using a Power Query, but I broke the Power Query connection and had to redo the workbook. I now have a simple Excel workbook that has no formulas or formatting, but the flow no longer works.

    Here is my flow for one column of the Excel workbook:

    vision click(Location(1330,394))
    wait 2
    keyboard Input Date

    The first row in that column of the workbook reads “Input Date” (without the quotation marks).

    When I load the workbook and try to run the flow, I get this error message:
    Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
    Details:
    System.Runtime.InteropServices.COMException (0x8002000B): Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
    at Microsoft.Office.Interop.Excel.Sheets.get__Default(Object Index)
    at TagUIWordAddIn.Ribbon1.ValidateExcelCheckBoxFields(CheckBox checkBox)

    What does this mean and how do I fix it?

    My TagUI Word and Excel add-ins are up-to-date.

    Many thanks.

  • ruthtxh

    Organizer
    September 12, 2022 at 10:03 am

    Hi @calculus perhaps the datatable is not referencing to the correct workbook/sheet. Can you check from the taskpane that you have referenced to the new workbook/sheet?

  • calculus

    Member
    September 13, 2022 at 2:02 pm

    Hi @ruthtxh, I found the problem and fixed it. It had to do with the contents of my workbook. Thanks!

Viewing 1 - 3 of 3 replies