Quote:
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.