Hi Mark, Thanks for your reply. I think hiding the columns is a much easier way of handling this. I'll just hide a couple of columns to the right of my column break.
I am not populating this excel sheet. The doc is created by a tool known as Business Objects (i am thinking it uses a template). The 'getlastrownum' returns 50..but the print preview has way more than 50 rows showing up (4 pages). the 'removerow' does not help either. I even tried doing the setFitHeight (PrintSetup class) to 1...that didnt help either. I am trying to use POI to format the excel documents that come out of this particular tool to make it circulation ready. Apparently Business Objects is not good at formatting documents. Do you know of any way to copy a couple of rows (say A1 - A5) to say A46-A51? --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
