You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Stuart Houston <st...@pha.co.za> on 2003/02/13 15:39:54 UTC

Remove Of Rows

Hi

I have the problem that when i use sheet.removerow(HSSFRow) it removes the
row, but does not remove it from the print completely, so that when you go
to look at the print preview, you are able to print the blank pages where
the row used to be

How would i remove the rows properly AND/OR compress the sheet to take these
rows out

Is there a way for excell to ignore these empty row markers?



advice needed: use of excel templates

Posted by Steve <st...@Basit.COM>.
Hi,
I am seeking some general guidelines/advice or references to articles
on how to programmatically (using the Java apache.poi.hssf ) create
new xls reports, starting from a template.
I know the basic concept:
- have a template xls file that is saved previously
- programmatically read the template
- programmatically add/change data in the template
- programmatically write the revisions to a new file.

However, how does one "find"/"identify" the particular cells that
one wants to modify. Do you put special tag values in those cells
and then search for those values, before replacing the value.

Bascially, what are the techniques/tricks to be used in this process?

THANKS,
Steve