#Java jxl landscape password#

//setRowView(int i,int height) Specify the height of the i-th row (this height seems to be 20 times that in Excel, which is set to 200 here, and the height in Excel is almost 10).

rgeCells( 0, 0,title.length- 1, 0) //Merge the first row of worksheet 1, display the title.

The product of the two is the number of merged cells.

//The result is that m-x+1 rows and n-y+1 columns are merged.

//From column x+1, row y+1 to column m+1, merged with row n+1 (four points define two coordinates, the upper left corner and the lower right corner).

//mergeCells(int x,int y,int m,int n): merge cells, which means.

sheet.getSettings().setPrintHeaders( true)В //Enable print header information.

#Java jxl landscape password#

sheet.getSettings().setPassword( '123456')В //Set protection password.sheet.getSettings().setProtected( true)В //Enable protection.When canceling, the password set below is required //Enable the protection and set the password to retrieve, the generated Excel is read-only, and it can be cancelled in the 'Review-Change-Revoke Worksheet Protection' module.Set protection and add password to lock the cell to work sheet.getSettings().setFooterMargin( 0.07)В //Set footer margin (below).sheet.getSettings().getFooter().getCentre().appendPageNumber()В //add page number for footer.sheet.getSettings().setRightMargin( 0.1).sheet.getSettings().setLeftMargin( 0.1).sheet.getSettings().setBottomMargin( 0.3).sheet.getSettings().setTopMargin( 0.5).sheet.getSettings().setFitWidth( 210)В //Printing area width.sheet.getSettings().setFitHeight( 297) //print area height.

sheet.getSettings().setPaperSize(PaperSize.A4) //Set paper A4.sheet.getSettings().setOrientation(PageOrientation.LANDSCAPE)В //Set to landscape printing.

WritableSheetВ sheet3В =В workBook.createSheet( 'Work Sheet 3', 2).WritableSheetВ sheet2В =В workBook.createSheet( 'Work Sheet 2', 1).WritableSheetВ sheetВ =В workBook.createSheet( 'Work Sheet 1', 0) //0 means the first sheet.//createSheet(param1,param2): param1 is the name of the current worksheet, param2 indicates the number of sheets, starting from 0.WritableWorkbookВ workBookВ =В Workbook.createWorkbook(file).//1, create an Excel workbook that can be written.public static voidВ main(StringВ args)В //Title array.* Practice using JXL to generate Excel files.public staticВ StringВ savePathВ = 'D:'+java.io.parator+ 'saveDir' //The directory where the document is located.