Hello everyone!
If any of you guys can help me solve a little tid bit with the ol' JExcelAPI, it'd be great!

Objective: Copy an excel file. Take a row in the duplicated excel file and make it repeat when the spreadsheet is printed. I'm using the "getPrintTitlesRow()" method to do this.

Here's the failed code:

public static void main(String args[]) throws Exception
{

Workbook workbook = null;

try {

workbook = Workbook.getWorkbook(new File("../someFile.xls"));
}
catch(IOException e)
{
System.err.println(">>>>" + e.getMessage());
e.printStackTrace();
}

WritableWorkbook workbook2 = Workbook.createWorkbook(new File("output.xls"), workbook);

WritableSheet sheet = workbook2.getSheet(0);
SheetSettings setting = new SheetSettings(sheet);

setting.setPrintTitlesRow(2,2);

workbook2.write();
workbook2.close();

}
I think the issue may be that I can't seem to actually apply the settings to the duplicated file.

Thanks!