Data Nitro error attempting to copy row

Question

I am trying to check against two value in a row, if that check passes then I want to copy the entire row at the end of the sheet.

LAST_ROW = 4488
CURRENT_ROW = 3
NEW_ROW = LAST_ROW + 2

while CURRENT_ROW <= LAST_ROW:
    if Cell(CURRENT_ROW, 63).value == "12" or Cell(CURRENT_ROW, 63).value == 12:
        if Cell(CURRENT_ROW, 65).value == "12" or Cell(CURRENT_ROW, 63).value == 12:
            for column in range(200):
                Cell(NEW_ROW, column).copy_from(Cell(CURRENT_ROW, column))
            NEW_ROW += 1
    CURRENT_ROW += 1

I get an "Exception: Exception from HRESULT: 0x800A03EC" error from the line "Cell(NEW_ROW..." and I am not sure why. Thank you as I have little to no experience with python and none with Data nitro.

score 2 · Answer 1 · answered Aug 18 '13 at 23:18

2

Just incase anyone else stumbles upon this. Excel column and row values start at 1 not 0.

answered Aug 18 '13 at 23:18

Flexo1515

1,007
1
10
27

1

could be worth elaborating on this. The problem was in the range(200) statement right? – Woody Pride Oct 01 '13 at 02:31

score 1 · Accepted Answer · answered Aug 31 '13 at 01:22

HRESULT: 0x800A03EC is an unknown (to VB.Net) COM error. This usually happens when Excel throws some error because your input or parameters were wrong or didn't work. I suggest you test your code in Excel VBA to make sure it works. It will be easier to diagnose there.

Data Nitro error attempting to copy row

2 Answers2