How to read XLSB

aposkala2

• March 07, 2018 00:00

• Answered

Follow

Hello,

Is there a component that can read XLSB files?

• 

  Vladimir Barton

  • March 07, 2018 13:41

  0

  Comment actions Permalink

  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,

  • XLSBReading.zip
• 

  aposkala2

  • March 08, 2018 10:10

  0

  Comment actions Permalink

  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
• 

  Vladimir Barton

  • March 13, 2018 12:45

  0

  Comment actions Permalink

  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,

  • XLSBReading_original.zip

Please sign in to leave a comment.