Generate Excel for a SQL query
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-27-2024 10:21 PM
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.
- Labels:
-
Download files
-
Table Download
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2024 06:01 AM
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.