poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From JayaGowri <jdeenadaya...@duanemorris.com>
Subject setRepeatingRowsandColumns - Not working in the latest Excel
Date Fri, 19 Jun 2009 19:32:29 GMT

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


Mime
View raw message