search

firegloves / MemPOI

A library to simplify export from database to Excel files using Apache POI :japanese_goblin:
MIT License
58 stars 7 forks source link

Rearrange and Delete Columns Exported to Excel #56

Closed apoorva-sriv closed 1 year ago

apoorva-sriv commented 2 years ago

If I cannot modify my SQL query, is there a way to rearrange and delete columns before exporting them to Excel?

firegloves commented 2 years ago

@apoorva-sriv currently there is no way to achieve your goal. But it is an interesting improvement that I will add to a future release. Thx for the idea

firegloves commented 2 years ago

As a workaround, you can obviously open the resulting file with plain Apache POI and remove the undesired columns. I don't know how much complicated it is, especially if you want to rearrange their order instead of deleting them

firegloves commented 1 year ago

Functionality released with v1.10.0