Error reading an excel file

[lrtetala (Lakshman Reddy)]

@marquezd

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

Hi @marquezd

Please check on this thread

Read range : Your stream was neither an OLE2 stream, nor an OOXML stream

Scenario: Read Range Excel File (.xls extension) Steps to reproduce: Try to read an excel file with Read Range activity. Current Behavior: Throws an exception: Read range : Your stream was neither an OLE2 stream, nor an OOXML stream. Expected Behavior: Returns the spreadsheet as a Datatable Studio/Robot/Orchestrator Version: UiPath Studio version: 2016.2.6274 OS Version: Windows 7 (64 bits) Others if Relevant: (workflow, logs, .net version, service pack, etc): Excel file: VL06O - B…

Read range:Your Stream was neither an OLE2 stream, nor an OOXML Stream

Yeah exactly Only this is changed It won’t impact other projects To just check open another project’s PROJECT .JSON file you can see the version of excel package being different @Jayavignesh_G

Error "Read Range: Your Stream Was Neither An OLE2 Stream, Nor An OOXML Stream "

Error fix for "Read Range: Your stream was neither an OLE2 stream, nor an OOXML stream" thrown while trying to read an Excel file in the automation workflow? Sometimes, when using the "Read Range" activity to read an Excel file in your workflow, you may run into the error that says "Read Range: Your stream was neither an OLE2 stream, nor an OOXML stream". [image] Troubleshooting Steps: Check if the file trying to open is corrupt. Verify this by opening it manually. Also try opening an alt…

Read Range error (Your stream was neither an OLE2 stream, nor an OOXML stream)

@supermanPunch I already found a workaround for this, I changed the file extension to xlsx and now everything is fine, but that do not answers the original question, why the read range with xls presents that error. Regards Antuan

Hope this helps!!