Generate Excel for a SQL query

[shubhamshah1412]

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.

[shubhamshah1412]

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.