# Unable to read Xlsb fike

**URL:** <https://community.automationedge.com/t/unable-to-read-xlsb-fike/5282>\
**Category:** Process Studio\
**Tags:** rpa\
**Created:** [January 15, 2022, 7:43am UTC](https://community.automationedge.com/t/unable-to-read-xlsb-fike/5282 "2022-01-15T07:43:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![amolrahate](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@amolrahate](https://community.automationedge.com/u/amolrahate)\
**Post date:** [January 15, 2022, 7:43am UTC](https://community.automationedge.com/t/unable-to-read-xlsb-fike/5282/1 "2022-01-15T07:43:42Z")

</div>

How to read .xlsb format file using process studio.

---

<div class="post-metadata">

**Author:** ![pranav.sharma](https://avatars.discourse-cdn.com/v4/letter/p/3e96dc/32.png) [@pranav.sharma](https://community.automationedge.com/u/pranav.sharma)\
**Post date:** [January 18, 2022, 9:26am UTC](https://community.automationedge.com/t/unable-to-read-xlsb-fike/5282/2 "2022-01-18T09:26:07Z")

</div>

Hello @amolrahate !  
We read **.xlsb** file using **Microsoft Excel Input** step. Please refer to the below screenshots for more details.

Step 1: Input **.xlsb** file  
 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/8/8c050cecc8d644f73867450cd5a0ec32e126dc91.png)

Step 2: In process studio, open **Microsoft Excel Input** step and substitute below values:

 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/e/e1f62f6e2fa39f96867be364d496c3efe9769abb.png)

Then execute the workflow.

---

<div class="post-metadata">

**Author:** ![amolrahate](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@amolrahate](https://community.automationedge.com/u/amolrahate)\
**Post date:** [January 19, 2022, 5:17pm UTC](https://community.automationedge.com/t/unable-to-read-xlsb-fike/5282/3 "2022-01-19T17:17:43Z")

</div>

I’m using old version. This option is available there.

---

<div class="post-metadata">

**Author:** ![pranav.sharma](https://avatars.discourse-cdn.com/v4/letter/p/3e96dc/32.png) [@pranav.sharma](https://community.automationedge.com/u/pranav.sharma)\
**Post date:** [February 4, 2022, 7:59am UTC](https://community.automationedge.com/t/unable-to-read-xlsb-fike/5282/4 "2022-02-04T07:59:16Z")

</div>

Hello @amolrahate!  
Since you are using an older version of AutomationEdge Process Studio, my first suggestion would be to upgrade your AutomationEdge version to the latest one.  
Until that time, you can try the below solution.  
We will use Execute Python Script plugin to read the “ **.xlsb** ” file and convert it to a **CSV** file. Then we will read this CSV file data using the “ **CSV file input** ” step.

Step 1: Input **.xlsb** file  
 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/b/b6e2a2930f5ffc48644c57094df888ef2e638499.png)

Step 2: Prepare workflow as shown below:  
 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/9/91174c3057abf669d7ce0d57ea681002dbf50b7f.png)

Step 3: Open **Execute Python Script** step and substitute below values:

 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/f/f6d577534f05dacdb5be7c54e592759e7fb474bb.png)  
 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/a/ab807cc398830aed1dfd2ce3e710b14e536b96c2.png)  
 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/d/de0ad43403bbc60dd2ff72ff2b2593cc44a03556.png)

Step 4: Open **CSV file input** step and substitute below values:

 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/2/233192f2ed2377940ea7a47292273f3191ff34f0.png)

Then execute the workflow which will give result as below:

 ![image](https://canada1.discourse-cdn.com/flex027/uploads/automationedge/original/2X/c/c390c92a12b4641aa119bb3bfab05b6ccf37f28d.png)

Pre-requisite for Execute Python Script plugin:  
Since you are using an older version of AutomationEdge Process Studio, install **python 3.6.1** on your machine.

You can install Python 3.6.1 by either downloading executable from the below link:  
[Python 3.6.1](https://www.python.org/downloads/release/python-361/)

**OR**

Request for **Python36.zip** from AutomationEdge Support and install python by following steps given in the AutomationEdge guide.

After successfully installing Python 3.6.1, please make sure to install modules viz., **pandas** , and **pyxlsb** required by the python script to execute successfully.

Command to install python modules:  
If Python 3.6.1 setup was done **using an executable** then,  
**pip install pandas**  
**pip install pyxlsb**

If Python 3.6.1 setup was done **using Python36.zip** then,  
**"d:\Python36\python.exe" “d:\Python36\Scripts\pip.exe” install pandas**  
**"d:\Python36\python.exe" “d:\Python36\Scripts\pip.exe” install pyxlsb**

Please note that this operation of reading an .xlsb file can be done using **JAVA** also. Then you will have to use “ **User Defined Java Class** ” step to write JAVA code for the same.