RakeshKumar1
New Contributor
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Does Snaplogic support writing Grid format headers for Excel Binary Spreadsheet(.xslb files)?
Thanks for the update, I need to check with user for zipping but i am replacing an existing process with Snaplogic tool so user may not agree and would like to see the file in mail same as as-is process where he can easily open it without downloading etc. If this is the primary reason to consider Binary format, I’d like to read up a bit more about whether those limits can be relaxed (depending on the Exchange Server version)----> xlsx extension is not an issue but its making the size twice+ which can cause issues in mail exch server limits. I am not aware if these is anything which can reduce xlsx attachment size. Any plan on supporting xlsb in near time?2.3KViews0likes0CommentsRe: Does Snaplogic support writing Grid format headers for Excel Binary Spreadsheet(.xslb files)?
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, Rakesh2.3KViews0likes2CommentsRe: Does Snaplogic support writing Grid format headers for Excel Binary Spreadsheet(.xslb files)?
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)2.3KViews0likes4CommentsRe: Does Snaplogic support writing Grid format headers for Excel Binary Spreadsheet(.xslb files)?
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, Rakesh3.9KViews0likes0CommentsRe: Does Snaplogic support writing Grid format headers for Excel Binary Spreadsheet(.xslb files)?
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!3.9KViews0likes1CommentRe: Does Snaplogic support writing Grid format headers for Excel Binary Spreadsheet(.xslb files)?
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!3.9KViews0likes0CommentsDoes Snaplogic support writing Grid format headers for Excel Binary Spreadsheet(.xslb files)?
Hello Team, I have requirement of writing excel binary spreadsheet .xslb extension type. Used Excel formatter snap followed by file writer and able to write the .xslb file , But how do i apply Grid format for Excel table headers for filters on each column ? Is there any way in Snaplogic to write .xslb files with grid on table columns(the drop down list in screenshot for headers) , Please suggest ? Example of grid Excel file is attached, where we can do filtertation, sort etc on each column. Thanks, Rakesh7.1KViews0likes9CommentsRe: AES Decrypt Snap - Urgent help
Thanks for looking in this Mathew, Yes Secret Key we can parametrize through account. But the field decryption will happen through both IV and Secret Key and both will be coming dynamically for my usecase, Snap has IV as a static property on UI so looking for any other workaround in SL if anyone else can suggest. Thank you!3KViews0likes3CommentsAES Decrypt Snap - Urgent help
Hello Smart folks, I am having a requirement to AES Decrypt a field(the field was encrypted with ‘AES/CTR/NoPadding’ algo with dynamic Secret key and initialization vector key by external system). Dynamic mean here is my input fields are supposed to be decrypted by different Secret key and Initialization vector in each pipe run so need to pass the keys dynamically in the snap. Tried to decrypt with AES Decrypt snap, but the snap has static property for ‘Secret Key’ and ‘initialization vector key’ which has blocked me to pass these 2 values dynamically from upstream snap or params to decrypt the input data. Any suggestion or any other way to do it in Snaplogic, please help.3.8KViews0likes5Comments