Excel to Binary

Hi All,

We are trying to save the normal Excel Worksheet into Excel Binary Worksheet, however its not working.

Could anyone please help here.

Thank you
Archana Gaur

@gaurar

Use MoveFile Activity
Properties:
Path: YourWorkBookFilePath.xlsx
Destination:YourWorkbookFilePath.xlsb

It will save your Normal ExcelWorkbook to Binary WorkBook.

Regards,
Mahesh

Hi @MAHESH1

Are you sure this will actually change the underlying file’s format and not just the extension?

@gaurar

How about surface automation, where you open the Excel File, navigate to Save As menu and choose the binary file from the list?

1 Like

Hi @loginerror

I tried to Convert .xlsx file to .xlsb by using MoveFile Activity. Yes it’s Converting only File extension not the File Format. I am not able to open the File once after Changing the Extension to xlsb.

Regards,
Mahesh

1 Like

excelToExcelBinary.zip (7.5 KB)

Hi @gaurar,
use hotkey to save as the file…

1 Like

This did not work for me too…,however thank you so much!:slight_smile:

Hi,

I combined this with what @loginerror suggested.
It worked!!
Thank you,Both!!
:slight_smile:

1 Like