Hi
I am generating an excel sheet using POI. I am
trying
to set the page breaks and it is not working.
Please help....
The code i am using is :
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet(Trades);
sheet.setAutobreaks(false);
//Create columns and one row...
sheet.setColumnBreak((short) 11);
for(int i=0; i < 1000 < i++)
{
//Create Rows and cells ..
if(i != 0 && i %100 == 0)
{
sheet.setRowBreak(i);
}
}
But when i open the generated excel sheet the page
breaks are present at the specified locations and also
there are additional page breaks... like on the row 48
, column 6 ....
Please help...
Thanks,
Ravi
____________________________________________________
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
http://football.fantasysports.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
