Thanks Mark. I used your code(modified) to copy data within the same sheet. It worked fine.
Another issue i am having now is with respect to page breaks. I do a sheet.setColumnBreak((short)7); but then when i do a page break preview on Excel, I see my defined page break and also one on column 6(dotted). I tried doing a HSSFPrintSetup ps = sheet.getPrintSetup(); ps.setFitWidth((short)1); but that didnt help. Have you encountered the same error before? Maybe I should post this question as a new post..not sure. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
