I’m in need of converting bunch of excel.xlsx files to excel.xlsb files.I couldn’t find any activity regarding that and i’m not too familiar with macro kind of things.pl give me a solution.
You can use Command prompt to convert it. Get the file path and run below line in cmd:
“C:\Program Files (x86)\Microsoft Office\root\Office16\excelcnv.exe” -oice “D:\filePath\excelName.xlsx” “D:\filePath\excelName.xlsb”
Or you can use SaveAs option also. Note, it will crate new file with xlsb format. Let me know in case of further queries. Hope you can manage to open CMD and run a command in Uipath.
To convert xlsx and xlsb files tool used is Total Excel Converter, Allowed file types: xls, xlsx, csv, tsv, xlsm, xlsb, xlt, xltm, xltx, xlk, xlw, xlr, pxl, ods, ots, qpw, wb3, wb2, wb1, wq2, wq1, sdc, vor, dbf, slk, uos, uof, wk1, wk2, wk3, wk4, wks, wab, 123, dif, et, wab, uof, uot, uos, uop, db, adt, dat, mdb. It is a nice tool that is easy yo use and fast in processing. you can easily convert your file by going to official ewebsite of coolutils and convert the file.