Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Write Flowfile content into Excel (or xls) file by Groovy (and Ivy)

avatar
Contributor

Hi

 

I need to extract data from a SQL query into Excel file (or xls)

Is it possible to do it by Groovy script ?

 

1 ACCEPTED SOLUTION

avatar
Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
5 REPLIES 5

avatar
Expert Contributor

Hello,

 

you can use after you received the result from your SQL-Database the ConvertRecord Processor to convert from Avro (Reader) to CSV (Writer). That should handle your question to do it without some Script.

 

Greetings

avatar
Contributor

My input should be XLS file not csv

I think about Groovy script but did not find anything about it

avatar
Expert Contributor

Sorry, I misread 😞 

But after convertion to csv you could check out topics like https://community.cloudera.com/t5/Support-Questions/how-to-convert-CSV-to-excel-using-apache-nifi/td... 

avatar
Contributor

Any ideas please ?

avatar
Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login