Generate Excel for a SQL query

shubhamshah1412 — Sun, 28 Jan 2024 06:21:01 GMT

Greetings,
I am using a Java Spring boot application that is supposed to respond with an excel based on request. My current approach involves reading data using jdbc drivers, storing them in appropriate data structures, writing them to an excel which will be returned on the output stream.
Was curious to know if we have any provision to directly generate the excel for a given query using some API, libraries etc which I can return on the output stream.

Re: Generate Excel for a SQL query

shubhamshah1412 — Tue, 30 Jan 2024 14:01:42 GMT

Thanks for putting this together @Retired_mod ,
I see that this approach will help to generate an excel after receiving the data from data bricks in the form of resultSet which has to be parsed.
I believe this approach is the appropriate way to generate excel then.
Please correct my understanding if incorrect.

topic Re: Generate Excel for a SQL query in Get Started Discussions

Generate Excel for a SQL query

Re: Generate Excel for a SQL query