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.
Anyeong,
Possible root cause is on the file extension. Is the file in xlsx format not in xls?
You may check on this too.
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…
1 Like
Hello,
Extension seems like correctly set.
str_arr_HANA is referring .xlsx
str_arr_SMS is referring .xls
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.
1 Like
Thank you !! It’s resolved with using Excel Application Scope
1 Like
system
(system)
Closed
May 11, 2021, 2:34am
6
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.