Hello, No, there is no easy way to copy a chunk of cells from one sheet to another, you would have to write it and to be honest, it should not be too hard. All you would need to do is iterate through all of the cells on the 'input' sheet, get the type, format and contents then re-create this on another sheet. Other aspects such as column widths and row heights would need to be addressed but this should, again, not be too hard at all. If I have the time today - and I cannot promise - then I will try to put something quick and dirty together.
There may be other options - what happens if you try to get row 51 for instance. Is it possible for you to post a copy of one of your workbooks here so that I can take a look at it just to see how it has been populated? Obviously, this will depend upon it's contents and your company policy so check with your bosses firstly of course. The 'extra' rows MUST be in there somewhere, it is just a matter of our finding them. As a final track, rather than have BO output a worksheet for you, is it possible to it to output a comma separated file? If so, this could simply be imported into Excel Yours Mark B dgv123 wrote: > > 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] > > > -- View this message in context: http://www.nabble.com/POI-%28Excel%29-usage-questions.-tp24116860p24160773.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]
