How to convert xlsx to xlsb in uipath

[Buvaneshwaran_R]

Hi all, I have one doubt in excel how to convert xlsx to xlsb using uipath.

[THIRU_NANI (NaNi)]

Hi!

Have a view on this

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)

Regards,
NaNi

[Shikhar_Tandon]

Hi @Buvaneshwaran_R ,

You can do that using invoke code activity. In that you need to pass the xlsx to xlsb conversion code.

Thanks

[Buvaneshwaran_R]

Hi Shikhar can you share the code once?

[THIRU_NANI (NaNi)]

you can also try like this!

Save Excel File As

Regards,
NaNi

[Buvaneshwaran_R]

@THIRU_NANI where we can find this activity i couldn’t see in the activities panel

[THIRU_NANI (NaNi)]

Hi!

Try this!

Convert Excel Format - RPA Component | UiPath Marketplace

Package: UiPathTeam.ExcelUtility.Activities

Reference:

Activity:

Regards,
NaNi

[Shikhar_Tandon]

Sure !!

Thanks

[Emna]

@THIRU_NANI it work for me but i have a question, this activity need that excel must be present in the VM?
or i can use it even i don’t have excel in my vm

[THIRU_NANI (NaNi)]

Hi!

If you can able to get the exel file this component convert the one format to another. This will work even if the excel is installed or not installed.

Regards,
NaNi

[Emna]

i have this error
Convert excel format: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

[Emna]

@THIRU_NANI
when i don’t have the software excel i have this error

Convert excel format: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).