Jexcelapi (protecting with password and removing all grids)
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);
Able to solve the problem...
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.