Hi all,
I was getting the Below Error when i was trying to read my excel file,
“Read range: Your Stream was neither an OLE2 stream, nor an OOXML Stream”
@Palaniyappan Could anyone is there to help me on this one ?
Thanks in advance,
Jayavignesh G
1 Like
Hi
Try to upgrade or downgrade UiPath.excel.activities package and run once
Or
Did we try with WORKBOOK ACTIVITIES
Under which we have read range activity
Pls refer for this more details
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…
Cheers @Jayavignesh_G
@Palaniyappan … Yes Using "Read Range " from WORKBOOK ACTIVITIES.
So, Downgrade or Upgrade will not affect my other project then ??
No it won’t impact
Each project has its own set of package and package versions
@Jayavignesh_G
I was Changing the Version from “Manage Package” as it Current Version is “2.7.2”.
As you said it will not affect to other project. Will go-ahead and Apply “Downgrade” Since Upgrade is not available.
Yeah pls go ahead
It won’t impact other projects
@Jayavignesh_G
Still Same Error.
@Palaniyappan
After upgrading excel package did we try with excel activities or workbook activities
Cheers @Jayavignesh_G
Workbook Activities -“Read Range”
@Palaniyappan
Try with excel activities buddy
As we have now made changes with package version
Cheers @Jayavignesh_G
Yes… It is Fixed now. Thank you so much !!
And Sorry to ask again again - I worried that this Version “Downgrade” will affect other excel Workbook project
1 Like
Sorry … My Last Question.
So, Other My Projects will Run in 2.7.2 Version then ??
Only the Above Project will run in 2.5.2 ?
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
system
(system)
Closed
July 22, 2021, 10:39am
17
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.