Trouble converting Excel file (.xlsx) to binary format (.xlsb)

[Sayali8 (Sayali Rodge)]

How to read binary excel sheet using uipath

Could you debug the issue a bit this way: Make a backup of your file Remove all columns except for the first one Try to run in in my example. If it will work, add more columns, one by one and keep testing until it stops. We need to be sure whether it is a bug in the activity or something specific to your file (or maybe both to some extent)

Hi Can you help me with conversion of Excel(.xlsx) to binary format(.xlsb)
Tried following solutions:

1. Move file activity - O/P - Corrupt file generated
2. UiOperation on excel for selecting file type as "Excel Binary Format " using select item - O/P - bot is selecting the option but after saving its still in .xlsx format.
3. UiOperation for export option of excel but resulted same as above.

Any solution for above problem.

Thanks
Sayali

[loginerror (Maciej Kuźmicz)]

Hi @Sayali8

Have you tried running my example to see if it will work?

How to read binary excel sheet using uipath

Hi @cheersrpa, I found this thread: Following it, I made this small example. Could you give it a try if it works, and then replace my example file with yours? Randomprocess.zip (33.0 KB)

[SudhakarAs92 (Sudhakar A S)]

Hi - This example did work for me. However, .xlsb is dynamic file downloaded from web page to a network drive and its accessed from there. Below is the error that I get.

This extension can not be used with the selected file type. Change the file extension in the File name text box or select a different file type by changing the Save as type.

-Sudhakar