Jexcelapi (protecting with password and removing all grids)

[gretags]

Hi guys,

I was working on converting some PHP excel program into Java (j2se). I used jexcelapi, so far I have not encountered any issue until I was trying to:
1.) protect workbook with password.
- I was able to protect the workbook, unfortunately I did not find anything in DOCS on how to protect it with password.
2.) remove all grids.
- I wanted to remove all grids. I can only remove the grid if I write into a cell, I don't want to do that... Still wasn't able to find anything on the DOCS...

I hope anybody of you here had experienced with the Jexcelapi. Also below I attached the code.

WritableSheet worksheet = this.excel.createSheet("HEADCOUNT ANALYSIS", 0);
SheetSettings sheet_settings = new SheetSettings(worksheet);
sheet_settings.setPrintGridLines(false);
sheet_settings.setPassword("test");
sheet_settings.setProtected(true);
sheet_settings.setShowGridLines(false);
worksheet.setProtected(true);

[gretags]

Ops...

SheetSettings sheet_settings = worksheet.getSettings();

This is the only solution... Sorry guys, I thought it passed object of the worksheet into the new object sheet_settings.