Does Streamsets offer a component that would convert excel to csv?

asked 2019-10-14 03:54:45 -0600

jay66online gravatar image

Hi,

The basic need was to process an excel file with multiple worksheet into Oracle table. while we were able to achieve it, yet the pipeline would just hang for any excel file above 5 mb. Hence, Based on suggestions from the streamset community we were able to get around the issue by converting the excel to csv.

however now the blockade is for the need that we would want to automatically convert the excel files received into a csv and also that the excel has multiple worksheets( a max of 6).

edit retag flag offensive close merge delete