Forum Discussion

kenm's avatar
kenm
Contributor
9 years ago

Is it possible to add column headers to excel file for DataSink

Good afternoon all,   I'm using DataSink to excel to generate an input file for my application however I need the first row to contain column headers. Can this be done natively?   I don't see an...
nmrao's avatar
nmrao
Community Hero
9 years ago
Not sure if it is mandatory to write into excel. Handling with csv is always simple; for at least these kind of stuff. A line can be easily added with groovy i.e., for headers if datasink can support csv file(hope it does).
kenm's avatar
kenm
Contributor
9 years ago

Thanks guys,

 

Unfortunately excel is mandatory for my requirements. I ended up having to workaround leveraging groovy script to output headers to csv, data generator then appending to csv, then in turn use that CSV as a data source which in turn we'll utilize for a second data sink into excel.

 

A bit of an ugly long winded workaround but hope it helps someone.