Read Range Activity not working for .xls files

[Gaurav_Gupta1 (Gaurav Gupta)]

Read Range Activity is not working for .xls file
Its throwing error "Your stream was neither an OLE2 stream, nor an OOXML stream. "

[Nandhuba (Nandhini Balasubramanyam)]

Hai @Gaurav_Gupta1 can u share a screenshot of this issue?

[Anand007 (Anand Jaiswal)]

Hi @Gaurav_Gupta1,

Please check below thread, this might help you.

Your stream was neither an OLE2 stream, nor an OOXML stream

Using a “Read Range” activity in opening a file of format .xls format gives an error. The error is “Stream was neither an OLE2 stream nor an OOXML stream” Version of UiPath: 2019.7.0 Version of Excel Package:2.6.2 Tried upgrading the Uipath and downgrading the excel package but nothing solves the above error. The format is of excel is of Single Webpage format. Not sure how to handle reading its rows and columns for such an excel file. Request inputs on solving the issue. [ExcelFormat]

Thanks & Regards,
Anand