You will have to write code to perform all of these options I am sorry to say.
The best place to start would be to take a look at the Quick Guide - http://poi.apache.org/spreadsheet/quick-guide.html - which shows you how to create Autofilters and freeze panes. How to create an optional totals row is something that I am not at all clear on as, to be honest, I do not know what it looks like, but am confident it should (might) be possible. As to appearance, well, you will have to create that yourself by formatting cells. All possible but it will require code. There are plenty of people on the list who can help you out when you hit specific problems. Also, you may want to take a look at the examples section - http://poi.apache.org/spreadsheet/examples.html. It contains lots of code demonstrating how to 'real world' worksheets. If it were me - and this is not meant to sound patronising so forgive me please if it does as that was not my intention - I would begin by writing the code to simply create the table, headings and all. Next, find out how to create the style objects for the header row and then move on to styling the cells in the rest of the table. Then, look at locking the header and the autofilter before tackling the optional totals row. Must admit that it is the final step that most intrigues me and I hope we can help you to achieve it. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Format-as-a-table-in-Excel-tp5709811p5709813.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
