Forum Discussion
Its a custom header and footer. The data I have looks like:
Now here I want to add custom header in footer in the content.
- RakeshKumar14 years agoNew Contributor
Correction - The extension type of file is .xlsb (not .xslb) which i am trying to write, Please suggest if .xlsb extension is supported by Excel formatter and file writer snaps or any other workaround.
Thanks!
- RakeshKumar14 years agoNew Contributor
Hello Team,
Please let me know if this possible ?
With xlsx the file size is becoming big which will block us from sending mail as attachment so want to make it .xlsb.
File is getting corrupted if i am using file extension xlsb.Thanks!
Example of grid Excel file is attached, where we can do filtertation, sort etc on each column.
Do you have that example? I didn’t see an attachment
- RakeshKumar14 years agoNew Contributor
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 - RakeshKumar14 years agoNew Contributor
Initially i was looking for writing .xlsb file with the filters and some colouring/formating grid options on file headers as in attachment, But found that In sldb SL manager tab it shows .xlsb file but on downloading from sldb, the file is converting to xlsx.
TestFileWithFilters.xlsx (19.1 KB)To be clear, you wish to write an .XLSB file and then be able to read/parse it later within a SnapLogic pipeline? The reason I ask is that when reading about the Binary format for Excel, one of the listed disadvantages I found was
Disadvantages Of Binary Files
Binary files cannot not be accessed by programs that understand the XSLX, XLSM file format only.
Thank you for the sample file. I’ll attempt to reproduce and report back to you on my findings.
- RakeshKumar14 years agoNew Contributor
Yes i see some cons, I was looking for xlsb to send file as an email attachment as .xlsb will reduce size and we can easily open xlsb file with excel sheet. If i use xlsx the file size is more than twice and exchange servers will reject it due to size limits.
To reproduce please upload any xlsb file in file reader followed by excel parser it throws error, Excel formatter snap output is xlsx binary data.
As per this blog xlsb is not supported. Load .xlxb workbook with multiple sheets to oracle table. Load only one or specific sheet data only - #13 by Siva_Venna
Regards,
Rakesh
Related Content
- 2 years ago
- 5 years ago