Hi Robin,
Hope you are doing great! Attached is the pipe slp.
The contettype of excel formatter in pipe says “application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”, which is content type for xlsx.
.xlsb contenttype will be “application/vnd.ms-excel.sheet.binary.macroEnabled.12”.
I don’t find any option to define mimetype in formater snap so i used the extension in file writer directly as Test.xlsb. I can see file in sldb but on downloading it is converting it to .xlsx
xlsbTest_2022_02_14.slp (9.4 KB)
TestXLSBIn.xlsx (10.2 KB)
With File Reader snap followed by excel parser i tried reading TestXLSBIn.xlsb file but the parser snap failed to parse data. I am unable to attatch .xlsb here but please convert attached xlsx into xlsb as below by save as ‘Excel Binary Book’
Any help on how do we read or write xlsb.
Thanks,
Rakesh
