You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by JayaGowri <jd...@duanemorris.com> on 2009/06/19 21:32:29 UTC
setRepeatingRowsandColumns - Not working in the latest Excel
Following is the test i created with 3.5beta poi jars and i dont see any
repeating rows and columns.
Can you please take a look and report if there is a bug.
Thanks
Gowri
package com.duanemorris.portfoliorebalance;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class RepeatingRowsAndColumns
{
public static void main(String [] args)
throws IOException
{
try{
XSSFWorkbook hwb = new XSSFWorkbook();
Sheet sheet = hwb.createSheet("new sheet");
for(int i=0;i<3;i++)
{
Row row = sheet.createRow((short)0+i);
Cell cell = row.createCell((short)0);
cell.setCellValue(111111);
Cell cell2 = row.createCell((short)1);
cell2.setCellValue(111111);
Cell cell3 = row.createCell((short)2);
cell3.setCellValue(111111);
}
hwb.setRepeatingRowsAndColumns(0,-1,-1,3,9);
FileOutputStream fileOut = new
FileOutputStream("reaptingRow.xlsx");
hwb.write(fileOut);
fileOut.close();
System.out.println("Your excel file has been generated");
}catch ( Exception ex ) { }
}
}
--
View this message in context: http://www.nabble.com/setRepeatingRowsandColumns---Not-working-in-the-latest-Excel-tp24117547p24117547.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org