Error reading an excel file

Help Studio
, ,
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!!