Add custom cells - Githubissues

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

Add custom cells #55

Closed apoorva-sriv closed 2 years ago

apoorva-sriv commented 2 years ago

How can I add a title on the first row after using a row offset? I thought I could use public Sheet getSheet() from MempoiSheet and manipulate it with Apache POI, but the private Sheet sheet Javadoc says DON'T POPULATE IT MANUALLY.

firegloves commented 2 years ago

@apoorva-sriv the automated addition of a title will be part of a future release.

Currently what you can do is:

specify an offset
request the generation of the MempoiReport
get the MempoiReport from the resulting Future
access the file property that returns the absolute path of the generated file
open it with plain Apache POI API
add manually the titles you require

Let me know if it is clear enough

apoorva-sriv commented 2 years ago

Got it. Thanks.

Small suggestion: can you add a link to the website or the animation as a GIF to the README? It's really cool and would make others even more interested in using the library!

firegloves commented 2 years ago

@apoorva-sriv thx for the suggestion. I can't add the GIF because it will become too large, but I can add a static example! Good idea!