Question

CSV to XLS

  • 2 September 2022
  • 1 reply
  • 23 views

Is it possible to convert CSV  file to XLS using Streamsets?


1 reply

Userlevel 3
Badge

@Priyabala

there is no out of box solution for this. Best bet would be to create a customer processor using java and then use it if there are multiple pipelines that would need this functionality.

 

Look at this example here: https://blog.aspose.com/2020/09/10/convert-csv-excel-java/

And tutorial for creating a customer processor: https://github.com/streamsets/transformer-sample-processor

There is also a youtube video if you need more help.

Reply