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

[mailsmithash (Smitha)]

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.

[mailsmithash (Smitha)]

Read the .xls file with ‘Excel Application Scope’ read range and its working for the format of the .xls file.