Hello,
Is there a component that can read XLSB files?
Hello,
Is there a component that can read XLSB files?
Hello Aposkala2,
unfortunately, reading XLSB files is not supported in CloverETL Designer. However, there are a couple of workaround solutions how to handle this situation. Attached is an example graph which demonstrates one of the possible options that involves converting the XLSB file to a CSV file with Libre Office command line tool. The main idea is the following:
Converting the XLSB file to a CSV file headlessly
Extracting the CSV filename and sending the respective file URL to FlatFileReader
Reading the CSV file by using FlatfileReader
Please note that the graph file uses parameter values related to my local environment. In order to make the graph work on your side, make sure to adjust the parameters accordingly.
Kind regards,
Hi Bartonv,
Thanks for the answer.
I adjusted some parameters, I get an error though saying that it does not recognize the user-defined FLAT_FILE_READER?
Any insight on that?
Thanks in advance,
Apostolos
Hi Apostolos,
feel free to review the attachment (an older version of the same sample graph) which should be compatible with older versions of CloverETL Designer. Another option would be to simply replace the FlatFileReader component with its predecesor - UniversalDataReader. Finally, a recommended option is to download a newer version (or ideally our latest 4.8.1 version) of the Designer from our website and test the original example there.
Kind regards,