Unable to read Xlsb fike

Get Help & Discuss Process Studio
1

How to read .xlsb format file using process studio.

2

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

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

image
image1028×492 16.4 KB

Then execute the workflow.

3

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

4

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

Step 2: Prepare workflow as shown below:
image

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

image
image676×620 12.2 KB

image
image679×623 14.9 KB

image
image676×622 10.5 KB

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

image
image827×543 17.5 KB

Then execute the workflow which will give result as below:

image
image449×536 13.2 KB

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

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.

1 Like