@acaciomelo (Acacio Melo) posted a new topic, subject "Read range : Your stream was neither an OLE2 stream, nor an OOXML stream". It read:

   ####  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 - BR.xls (43.7 KB)

@vvaidya (Vinay Vaidya) replied

    Works fine for me with both Excel Activities. Any package updates recently?
    
    You need to downgrade your excel package
    
    Read Range error Help
    
    > Yes …!! Sure  UiPath.Excel.Activities.+1-705-622-6804.nupkg (102.4 KB) Regards…!! AKsh

Then @acaciomelo (Acacio Melo) said

    Hi @vvaidya,
    
    Yes, this is really odd, I'll try to reinstall this package.

Then @acaciomelo (Acacio Melo) said

    I reinstalled this package and the error continues.

So @vvaidya (Vinay Vaidya) replied

    Can you double check your excel version which is installed should be 1.2.6256. Restart your studio if possible.

Then @acaciomelo (Acacio Melo) said

    I don't think downgrading this package is a good solution, let's escalate this to the UiPath team, so they can properly analyze it.
    
    @qateam

So @vvaidya (Vinay Vaidya) replied

    Read Range error Help
    
    > ok then, so previous package is fine. we will investigate more. thank you

So @Gabriel_Tatu (Gabriel Tatu) replied

    you`ll need the workbook activity in order to work with xls files.

@acaciomelo (Acacio Melo) replied

    Hi @Gabriel_Tatu,
    
    I'm not using Excel Scope activity in this case. I'm just using the **Read Range** activity as you may see in the screenshot.

To which @Gabriel_Tatu (Gabriel Tatu) replied

    its a specific issue this, with your excel file. we will investigate further.  
    as a workaround, save it as xlsx and try again.

So @acaciomelo (Acacio Melo) replied

    Hi @Gabriel_Tatu,
    
    Did you manage to test it? I mean using the same UiPath version and the same Excel Activities package?
    
    I don't think I'm going do this workaround because it was working before this update and I have several .xls files in my current project, so saving them as .xlsx would cost me too much time.

Then @Gabriel_Tatu (Gabriel Tatu) said

    xls support was not available until this update, which package have you used so far and worked?

Then @acaciomelo (Acacio Melo) said

    Really? Because it stopped to work properly this week.
    
    I believe that the previous version from Excel activities package was working, I didn't try to install the previous one, but what I'm sure is that this current one is not working and also we have another topic talking about some problems with the latest Excel activities package here:
    
    Read Range error Help
    
    > Yes …!! Sure  UiPath.Excel.Activities.+1-705-622-6804.nupkg (102.4 KB) Regards…!! AKsh

@Gabriel_Tatu (Gabriel Tatu) replied

    Please read this topic:
    
    UiPath Activities
    
    ### About the Excel Activities Package
    
    The Excel activities package aids users to automate all aspects of Microsoft Excel, as we know it is an application intensely used by many in all types of businesses. It contains activities that enable you to read information from a cell, columns,...

@beesheep (Eduardo Bernabe Sacahui Diaz) replied

    I solved mine by installing previous excel activities.

To which @Gabriel_Tatu (Gabriel Tatu) replied

    then, also as workaround you can try using excel scope activities,if you still have office installed. it should work.

Then @Gabriel_Tatu (Gabriel Tatu) said

    if you provide the test file and maybe the workflow too, i can investigate more.

So @acaciomelo (Acacio Melo) replied

    Yes, kindly check it.
    
    I'm using the same excel file that I have uploaded below and I'm using the latest Excel activities package.
    
    Main.xaml (4.8 KB)  
    project.json (236 Bytes)
    
    It works if use it inside Excel application scope. But, my main concern here is that it was working before without using Excel application scope, but now it's needed.

To which @Gabriel_Tatu (Gabriel Tatu) replied

    this issue should be fixed in a future update, check Package Manager for updates frequently.

After which, @Rynn added

    Hi @acaciomelo
    
    I've met the same problem and we found the .xls file we use is actually a csv format file name end with .xls so trials of using read range and read csv activities are all failed. Our Uipath ver is usullivan@example.net due to development environment, is there any solution for this in this version?

To which @andrzej.kniola (Andrzej Knioła) replied

    Try renaming the file to `.csv` before using ReadCsv activity.  
    Should work, we've had similar issues with SAP generated Excels and Excel package `2.0+` (don't remember which one)

So @Rynn replied

    Excel application scope activity could read csv file and, done. Thanks.

To which @priyanka.yadav18 (Priyanka Yadav) replied

    I have also got this error while I am using the same read range activity.  
    Is this an issue of the read range activity of workbook or a limitation.

To which @Awesomeness replied

    I found this error happens due to Excel format.  
    Some systems make Excel files with regular excel format, which means the file ends with “.xls” or “.xlsx” but if you open the files you may encounter certain errors about format and you need to re-save them.  
    it is because the systems make the excel file with text file, using or other seperators. So, in this case, you need to open excel file and save it first to use Read Range Activity.

To which @system (system) replied

    


{'source': 'discourse', 'url': 'https://forum.uipath.com/t/read-range-your-stream-was-neither-an-ole2-stream-nor-an-ooxml-stream/5235', 'title': 'Read range : Your stream was neither an OLE2 stream, nor an OOXML stream', 'views': 21758, 'has_accepted_answer': True, 'word_count': 826, 'like_count': 14, 'reply_count': 16, 'participant_count': 8, 'posts': 25, 'tags': 'activities excel', 'author': '@acaciomelo (Acacio Melo)', 'participants': '@acaciomelo (Acacio Melo), @vvaidya (Vinay Vaidya), @Gabriel_Tatu (Gabriel Tatu), @beesheep (Eduardo Bernabe Sacahui Diaz), @Rynn, @andrzej.kniola (Andrzej Knioła), @priyanka.yadav18 (Priyanka Yadav), @Awesomeness, @system (system)', 'image_url': ['https://global.discourse-cdn.com/uipath/original/2X/e/efff619d591e24107e3b1380a643a37ecce7ad57.png'], 'created_at': '2017-05-24T13:14:01.948Z', 'last_posted_at': '2018-10-29T09:22:30.320Z'}