Error reading an excel file

Help Studio
, ,
1

Hi everyone, I’m trying to read an excel file with a read range activity, I provide the full path, the sheet name and the range is open because I try to read the entire document but the excel sheet has more than 500 rows and the robot send me the following error :

Read Range Workbook: Your stream was neither an OLE2 stream, nor an OOXML stream.
image

Does anyone can help me to solve this issue ??

2

Hi @marquezd
May be you could try these steps to get your error resolved.

  1. Check File Format:
    Ensure that the file you’re trying to read is in a valid Excel format, such as XLSX (OOXML) or XLS (OLE2). Older formats like XLS might not be supported by the Read Range activity.

  2. Verify File Path:
    Double-check that the file path you provided is correct and that the file exists at the specified location.

  3. Confirm Sheet Name:
    Make sure that the sheet name you provided in the Read Range activity is correct and exists within the Excel file.

  4. Check for File Corruption:
    The error message might be related to file corruption. Try opening the Excel file manually to see if it opens without issues. If it’s corrupt, you might need to restore a backup or obtain a valid version of the file.

  5. Use Full Range:
    Instead of specifying an open range, try specifying a specific range within the Excel sheet that you want to read, such as “A1:Z500” if you want to read the first 500 rows.

Check out this thread

Hope it helps!!

3

Hi @marquezd

Please check on this thread

Hope this helps!!

4

Tnks so much, the problem was the excel file was corrupt I did it win excel scope with the check read only and it works

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.