Excel Read range - issue

[prabhu_ponnusamy]

Hi all,

I am getting below error while using read range activity even though the excel sheet is very simple.

System.IndexOutOfRangeException: Index was outside the bounds of the array.

thanks.

[supermanPunch (Arpan)]

@prabhu_ponnusamy What is the Range value you have used in the Read Range ?

[prabhu_ponnusamy]

nothing . just an empty

[supermanPunch (Arpan)]

@prabhu_ponnusamy Are you using Excel Activities or WorkBook Activities ?

[prabhu_ponnusamy]

tried in both method . getting the same issue

[supermanPunch (Arpan)]

@prabhu_ponnusamy So to narrow down the problem whether the problem is due to the Activities or the Excel File, Can you just create a Sample Excel file with some data in it and try to read the file using Read Range Activity, If it works, that would mean the file you’re using may be corrupted or some other kind of file error.

[hubs032 (Aaron Hubbart)]

Double check your sheet name.