Worksheet position out of range.while reading data from excel from azure storage

(0) Share

Report

Posted on by Koti9999

Hi Experts,

I'm getting below error "Worksheet position out of range" while reading data from excel file from Azure storage.

error line number error causing.

Thank you in advance

I have the same question (0)

All responses (8)

Answers (0)

André Arnaud de Cal... 299,704 Super User 2025 Season 2 on at

Like (0)

Report

RE: Worksheet position out of range.while reading data from excel from azure storage

Hi Koti9999,

Does the stream variable has a valid Excel workbook?

Was this reply helpful? Yes No
Koti9999 55 on at

Like (0)

Report

RE: Worksheet position out of range.while reading data from excel from azure storage

Hi Andre,

yes it contains valid workbook.

Was this reply helpful? Yes No
Koti9999 55 on at

Like (0)

Report

RE: Worksheet position out of range.while reading data from excel from azure storage

Hi Experts,

please help on this.

Thanks

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: Worksheet position out of range.while reading data from excel from azure storage

Hi Koti999,

how did you determine that the stream contains a valid Excel workbook?

Was this reply helpful? Yes No
Martin Dráb 236,751 Most Valuable Professional on at

Like (0)

Report

RE: Worksheet position out of range.while reading data from excel from azure storage

If there is a single worksheet, it's index is 0 (not 1), isn't it?

Was this reply helpful? Yes No
YY Lim 960 on at

Like (0)

Report

RE: Worksheet position out of range.while reading data from excel from azure storage

I think the value should be 0 instead of 1 in the get_item().

Should be get_item(0). Please try and see.

Was this reply helpful? Yes No
Koti9999 55 on at

Like (0)

Report

RE: Worksheet position out of range.while reading data from excel from azure storage

Hi Yuvan,

tried with get_item(0)..no luck, same error ..

is there any issue with my stream? this is how i'm downloading azure file and capturing to target stream.and from the stream i'm reading excel data.

Thanks

Was this reply helpful? Yes No
Martin Dráb 236,751 Most Valuable Professional on at

Like (0)

Report

RE: Worksheet position out of range.while reading data from excel from azure storage

Correct me if I'm wrong, but it seems to me that you don't want for the download to complete, therefore the file content doesn't have to be downloaded in full when you're trying to import it.

Also, if you want to see what's inside the stream, why don't you into the file and take a look?

Was this reply helpful? Yes No