Read Range error (Your stream was neither an OLE2 stream, nor an OOXML stream)

Help Forms
, , ,
#1

Hello Forum

I’m having issues with the “Read Range” activity this is the error message: (Your stream was neither an OLE2 stream, nor an OOXML stream)

This is the scenario:
I have 2 excel files and I need to read the “” range from one of the files and paste the data to another excel file, that error appears and cannot continue.

PD: excel file format: xls
The Excel Activities Scope cannot be used in the read range activity because it opens the files in the background

Do someone here knows what to do?
Thanks
Antuan

#2

@Antuan_Ulate You can Try using Excel Application Scope with Visible Property Set to False, in that way it won’t open the file in the Foreground. Check if it works.

#3

Hi, thanks for your answer, I already tried it, and as I mentioned before the file opens in the background even with the visible property set to False , the read range activity cannot continue due to this.

#4

@supermanPunch

I already found a workaround for this, I changed the file extension to xlsx and now everything is fine, but that do not answers the original question, why the read range with xls presents that error.

Regards
Antuan

1 Like