Excel - Print Titles - jxl

[mermaid]

Hi. This is for anybody that knows JXL. Still trying to figure out how to make setPrintTitles() work properly.

workbook = Workbook.getWorkbook(new File("output2.xls"));

WritableWorkbook workbookFinal = Workbook.createWorkbook(new File("output3.xls"), workbook);

WritableSheet sheet3 = workbookFinal.getSheet(0);
sheet3.getSettings().setPrintTitlesRow(0,1);

workbookFinal.write();
workbookFinal.close();

The very first time "output3.xls" is created, where file "output2.xls" has no Print Titles set, everything works fine. Then let's say I want to take "output3.xls" and override it. So I change the code to the following:

workbook = Workbook.getWorkbook(new File("output3.xls"));

WritableWorkbook workbookFinal = Workbook.createWorkbook(new File("output3.xls"), workbook);

WritableSheet sheet3 = workbookFinal.getSheet(0);
sheet3.getSettings().setPrintTitlesRow(0,1);

workbookFinal.write();
workbookFinal.close();

Green represents which parts I changed when I executed the code a second time. This effectively opened "output3" and wrote over it. When I tried to open the file, I got this error:


"Name cannot be the same as a built-in name.
Old name: Print_Titles
New name:"

For some reason, if Print Titles have been set in an *.xls file and a JXL code re-writes it, something in the file gets screwed up. Now mind, I know what this error is. What I'd like to know is if anybody found a way around it.

THANK YOU!!

[palnika]

Hey, were you able to solve this?? I am having the exact same problem. I tried many jxl classes, like NameRecord, BuiltinName etc, but cant seem to resolve this Name Conflict issue.!

Thanks in advance.

[mermaid]

I did find out the solution for this but I can't remember off the top of my head. I'll reply again when I look into my documentation. Cheers!

[palnika]

Hey, thanx for the reply, but i found it.! something to do with the properties.!

[Cifer69]

Hands down to you guys. This problem has been pestering me for days! I was wondering how you guys solved this?

Please guide me to the right path.

Thanks in advance!

[rtstone]

Hey, thanx for the reply, but i found it.! something to do with the properties.!

Please tell me what the solution you found was. I have been trying to solve this same problem for a while now, and I can't seem to figure it out.

Thanks