this is an example:
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Sheet1");
for( int j = 0; j <= 70; j++ ) {
HSSFRow titleRow = sheet.createRow(j);
for (int i = 0; i <= 7; i++) {
HSSFCell cell = titleRow.createCell(i);
cell.setCellValue(j + " - " + i);
if( (j == 10) && (i == 7) ) {
cell.setAsActiveCell();
sheet.createFreezePane(2, 8);
sheet.showInPane((short)4, (short)0);
}
}
}
String file = "test.xls";
FileOutputStream out = new FileOutputStream(file);
wb.write(out);
out.close();
the function ShowInPane is working on the top pane (with columns headers,
but i want that scrolls the bottom pane)
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/ShowInPane-with-rows-locked-tp3423129p3423172.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]
