"message": "Read Range: Value cannot be null.\r\nParameter name: String",

[Dorothy_lee]

Hello, all

I’ve just suddenly encountered below error message.
Since I haven’t faced error before with same excel file. I’m not sure how to resolve it.
Could you please help for finding which is wrong…?
[Error Code]
“message”: “Read Range: Value cannot be null.\r\nParameter name: String”,
[File Name]

[Uipath- error occurred on Read Range]

And also, below error occurred on different read activities.

[Emman_Pelayo]

Anyeong,

Possible root cause is on the file extension. Is the file in xlsx format not in xls?

You may check on this too.

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…

[Dorothy_lee]

Hello,
Extension seems like correctly set.

str_arr_HANA is referring .xlsx
str_arr_SMS is referring .xls

[Emman_Pelayo]

Hello,

Most of the discussions with this issue in the forum is related on using read range activity for .xls file. Maybe you can check using excel app scope.

[Dorothy_lee]

Thank you !! It’s resolved with using Excel Application Scope