- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a week ago
Hi
I have to read data from .xlsb file. I tried to use Excel parser but it is throwing error.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
@kumar25 - My dev team is stating that this is currently not supported by our Excel Parser snap. My major concern with using a Script snap to handle the parsing is that the file would either need to be passed as a single binary document, consuming as much memory as the file size, which can be quite large, or you would need to place the file on the Snaplex node before parsing and ensure that the SnapLogic process has read permissions to it.
Having the Script snap perform the parsing also requires that you install and maintain the libraries required to parse.
While is is feasible, I might recommend that you see if the source can provide the more standard XLSX format before going that route.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Wednesday
@koryknick, can you suggest a solution for this.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
@kumar25 - this is not a commonly used format that I do not have personal experience with. I will post to our internal channels to see if I can get an answer.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
@kumar25 - do you happen to know if this file was created on a Linux or Windows machine? This apparently may make a difference to the parser.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
@kumar25 - it might be faster if you open a support ticket to have this question answered. Apparently we have seen this work with other customers, so there may be some conditions that require further investigation by the support team.
