B4J Question setRepeatingRows

[Robert Valentino]

Need to do a setRepeatingRows http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Sheet.html#setRepeatingRows%28org.apache.poi.ss.util.CellRangeAddress%29

So that I can set the column headers to print on every page.

I cannot seem to find the routine in RunMethod not am I sure how to pass the cell range

 

[stevel05]

I don't know the library but when you say "I cannot seem to find the routine in RunMethod " Do you get an error when trying it?

You will need to create a cellrangeaddress object to pass to the method.

 

[Robert Valentino]

   Dim sheetJo As JavaObject = Sheet
   sheetJo.RunMethod("setRepeatingRows", Array("Sheet.Name!$1:$1"))

gives me this error:
Waiting for debugger to connect...
Program started.
Error occurred on line: 69 (cPoiRoutines)
java.lang.RuntimeException: Method: setRepeatingRows not matched.
at anywheresoftware.b4j.object.JavaObject.RunMethod(JavaObject.java:129)
at b4j.example.cpoiroutines._setheadercenter(cpoiroutines.java:434)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

 

[Robert Valentino]

Yes. Can't figure how to call this example below

http://poi.apache.org/spreadsheet/quick-guide.html#Repeating

Repeating rows and columns
It's possible to set up repeating rows and columns in your printouts by using the setRepeatingRows() and setRepeatingColumns() methods in the Sheet class.

These methods expect a CellRangeAddress parameter which specifies the range for the rows or columns to repeat. For setRepeatingRows(), it should specify a range of rows to repeat, with the column part spanning all columns. For setRepeatingColums(), it should specify a range of columns to repeat, with the row part spanning all rows. If the parameter is null, the repeating rows or columns will be removed.

Workbook wb = new HSSFWorkbook(); // or new XSSFWorkbook();
Sheet sheet1 = wb.createSheet("Sheet1");
Sheet sheet2 = wb.createSheet("Sheet2");

// Set the rows to repeat from row 4 to 5 on the first sheet.
sheet1.setRepeatingRows(CellRangeAddress.valueOf("4:5"));
// Set the columns to repeat from column A to C on the second sheet
sheet2.setRepeatingColumns(CellRangeAddress.valueOf("A:C"));

FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();

 

[Erel]

Try this:

Dim cellrange As JavaObject
cellrange = cellrange.InitializeStatic("org.apache.poi.ss.util.CellRangeAddress").RunMethod("valueOf", Array("4:5"))
Dim jo As JavaObject = sheet1
jo.RunMethod("setRepeatingRows", Array(cellrange))

 

[Robert Valentino]

Thanks. That lets me set a cell range.

But the setRepeatingRows does not seem to do anything.

Tried $1:$1 like I would do in any other Excel sheet (as a cell range and even SheetName !$1:$1)

Also tried the call method "setPrintRowAndColumnHeadings" (called on sheet level) according to the docs that is suppose to turn on and off the printing of column heading.

But that crashes as "java.lang.RuntimeException: Method: setPrintRowAndColumnHeadings not found in: org.apache.poi.xssf.streaming.SXSSFSheet"

Like always, seems like simple stuff.

 

[Robert Valentino]

Figured it out. Turns out ValueOf for CellRange want just numbers and not the $