1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
public class writeXlsFile {
public static void main(String args[]){
try {
WritableWorkbook ProtectWorkbook = Workbook.createWorkbook(new File("C:\\output.xls"));
WritableSheet Worksheet_to_Protect=ProtectWorkbook.createSheet("Page1", 0);
CellView cellHide = new CellView();
cellHide.setHidden(true); //set hidden
Worksheet_to_Protect.setColumnView(6, cellHide); /* Hide column 6 -> G */
Label label = new Label(0, 0, "SomeData"); /* Add data at Cell 0,0 for example */
Worksheet_to_Protect.addCell(label);
Label label1 = new Label(6, 0, "coucou"); /* Add data at Cell 6,0 */
Worksheet_to_Protect.addCell(label1);
SheetSettings Worksheet_settings = Worksheet_to_Protect.getSettings();
Worksheet_settings.setPassword("password"); /* Password for Worksheet */
java.lang.Boolean set_protected = new java.lang.Boolean(true);
Worksheet_settings.setProtected(set_protected); /* Protection */
ProtectWorkbook.write(); /* Save workbook with password settings */
ProtectWorkbook.close(); /* Close Workbook */
System.out.println("The file was created");
}
catch (Exception i){
System.out.println(i);
}
}
} |
Partager