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.