Java operations EXCEL,JXL with borders, JXL merged cells, cell settings, cell

Writablecellformat Headerformat = new Writablecellformat (
                     header_font_style);
            //horizontally aligned
             headerformat.setalignment (Alignment.CENTRE);
            //Vertical Alignment
             headerformat.setverticalalignment

(Verticalalignment.centre);

Create labels, in order: column index, row index, content, format
Label Seqlabel = new label (0, 0, "ordinal", Headerformat);
Add cells
Sheet.addcell (Seqlabel);
Merge cells with the following parameters: Column index, row index, column index + need to merge

Number of columns, row index + number of rows that need to be merged
Sheet.mergecells (0, 0, 0, 1);
Sets the cell width, in characters
Sheet.setcolumnview (0, "serial number". Length () + 10);

Label Basicinfolabel = new label (1, 0, "basic information",

Headerformat);
Sheet.addcell (Basicinfolabel);
sheet.mergecells (1, 0, 3, 0);//The merger collapsed 3 lines.

sheet.mergecells (1, 1, 1, 3);//merged into the collapse of 3 columns.

label = new label (0, 1, "Apple");
Sheet.mergecells (0,1, 0, 3-1);//The merger collapsed 3 columns.
Writablecellformat CellFormat = new Writablecellformat ();
Cellformat.setverticalalignment (verticalalignment.centre);

//Vertical Center
Label.setcellformat (CellFormat);
Sheet.addcell (label);

Note: When you make CellFormat again, you need to renew the new Writablecellformat.