Load .xlxb workbook with multiple sheets to oracle table. Load only one or specific sheet data only
I have .xlsx file on remote server. My requirement is to load the file content into an oracle table.
Any help is appreciable, Thanks in advance.
Forum Discussion
I’ve created a sample pipeline that successfully reads a small dataset. Formatting of the source file is inline with your setup. Can you review the xlsx file and pipeline (attached) and let me know if that matches with what you have?
Excel-Test_2019_02_20.slp (4.3 KB)
Test-Excel-File.xlsx (29.9 KB)
The pipeline works fine to read xlsx file. But if you look at the file type I am mentioning it is xlsb(Microsoft Excel Binary Worksheet) so Excel Parser is throwing error as it is getting binary document.
The Snap is only compatible with xlsx or xls which represents data as XML internally. However, the Snap appears to be incompatible with parsing a file that is in xlsb format. Can you please reach out to our Support channel (support@snaplogic.com) to track this as an enhancement request for the Excel Parser Snap?
@sriram, Can you please forward this to the concerned team on my behalf? Thanks
I am facing same issue, unable to parse xlsb file. Please share solution if you have figured out.
@nmadulapally as per the discussion it seems the snap is incompatable to parse xlsb file.
Can you brief your requirement?Thanks Siva, my requirement is to parse xlsb file and read one worksheet.
@nmadulapally I suggest you to use Excel parser snap
