To Read a Binary excel file

Help Activities
, ,
1

How to read a Binary excel file using Read range?? My file is more than 7MB so i cannot copy it as path.

2

HI @cool_babe

Have you tried with excel activities
Use Excel Application Scope and Give you file with extension and read range
image

If you dont find excel application scope
Activities panel-> Filters-> Show Classic and now search it it will be there

Regards
Sudharsan

3

Yes i have tried it with excel application Scope but i couldnt find the binary file using file explorer

4

Update your excel activities @cool_babe

Don’t browse instead get the path manually from the folder and paste it there

5

I have updated my excel activities and i have manually copied the path and pasted it, it throws error that it doest support Xlsb format.

6

Can you share the workflow screenshot? @cool_babe

7

Screenshot (1)
Screenshot (1)1281×788 60 KB

8

Can you be sure you to read binary file or macro file @cool_babe ?

9

Thanks for your response sry the file is confidential.

10

Yes im sure it is Binary file

11

the extension seems to be macro file xlsm , Binary will be xlsb @cool_babe

12

Screenshot (2)
Screenshot (2)1098×900 88.1 KB

13

Instead of workbook activities @cool_babe
image

Use excel activities like this
image

Regards
Sudharsan

14

even i have used it too

15

Hello @cool_babe
The Xlsb format can’t read by using the workbook activity. Use the Excel application scope to read the the binary file. You can place the Excel application scope inside the other excel application scope as a nested.

16

@cool_babe Let us know the error you are facing. Share the error screenshot.