Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: gmullinCurrently the Excel Node in LAE does not support xlsb files, so we (ltolleson, ryeh and I) started working on a way around this by using an open source program LibreOffice. If you're using a local desktop or enterprise license, you will need to have this installed on your Windows or Linux machine in order for the node to work. This node was tested with LibreOffice 4.4 installed. The windows install is straightforward, you just have to ensure you install it to the following directory (which it does by default):
C:\Program Files (x86)\LibreOffice 4
This guide is good for Linux install. You will need to be root user.
http://www.tecmint.com/install-libre...tu-linux-mint/
What does the node do?
In order to use the data inside the xlsb file within LAE, we currently need to convert it to a format LAE can read. In this case, there is an option to convert the file to either csv or xlsx. A limitation we found with LibreOffice is that any file over around 14mb, has problems converting to xlsx and the process hangs. The node won't convert anything over that size to xlsx, and will instead convert it to csv. We haven't seen any limit on converting xlsb to csv.
The node to use has 3 parameters:
1. ConvertTo: pick between csv or xlsx
2. FileName: full path and file name of the xlsb file
3. OutputDirectory: where the converted file will be placed
There are 2 output pins:
1. The full path and name of the converted file
2. The actual data from either the CSV or Excel Node
I hope you find this useful!
Attachments:
ExcelXLSBConverter.brg