Read range work makes an error

[ani_panch]

I’ve selected the xlsx file I want to read, inserted the sheet name and connected it to the datatable variable, but when I run the fil this is the error I get:

[ani_panch]

[Suraj_B_Shetty (Suraj)]

Hi @ani_panch

Select entire path of the excel file and check.

[ani_panch]

It gave another error

[Harshith_Adyanthaya]

Hi @ani_panch

Excel file you are reading is empty. There is no data in that file. Hence it gave object reference error.

[Suraj_B_Shetty (Suraj)]

Hi @ani_panch

Check the excel file has data or not.

[ani_panch]

it doesn’t because I’m extracting data from invoice and inputting in the file

[Harshith_Adyanthaya]

Then use write range workbook activity. It writes the data table into excel file.

[Suraj_B_Shetty (Suraj)]

@ani_panch

If u try to store empty data from excel to data table it will throw error. Give default value of the data table variable as New DataTable in the variable panel and check once.

[ani_panch]

I deleted that step but now I have an error here: It asks me to insert something into DataRow. What should I put there?

[Harshith_Adyanthaya]

Nothing. If you pass array of datarow, you need not enter datarow. Keep it empty.

[ani_panch]

Here’s the error, I really don’t understand why it’s not working, I’m following a tutorial…

[Harshith_Adyanthaya]

There is no data in at least one of those variables which you have passed inside a array.

[saritha]

Hi ,

Can u please try by upgrading package version for excel.

Thanks
Saritha

[ani_panch]

Hi friends, thanks for the responses, I solved the problem the following way: added headers to the columns in excel file. Afterwards every step worked: from read range to add row