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

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

@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.

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.

@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