Ask Your Question
1

Best way to convert Excel file to CSV in Pipeline

asked 2018-02-20 21:22:56 -0600

rthebest gravatar image

Hello, We need to convert Excel files to CSV within our Pipeline. One thought we had was to install LibreOffice and then create a custom processor to do the conversion, but is there is a different way? Thanks!

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted
0

answered 2018-02-21 15:38:30 -0600

metadaddy gravatar image

updated 2018-02-21 15:38:40 -0600

Currently there's no built-in support for processing Excel files - SDC-4254 tracks this issue.

edit flag offensive delete link more
1

answered 2018-02-22 10:37:19 -0600

daryll-g gravatar image

You can look at this article. It would have to be a pre StreamSets step:

https://github.com/dilshod/xlsx2csv

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-02-20 21:22:56 -0600

Seen: 288 times

Last updated: Feb 22