//
1.添加Label对象
jxl.write.Label labelC = new jxl.write.Label( 0 , 0 , " This is a Label cell " );
ws.addCell(labelC);
// 添加带有字型Formatting的对象
jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.TIMES, 18 , WritableFont.BOLD, true );
jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);
jxl.write.Label labelCF = new jxl.write.Label( 1 , 0 , " This is a Label Cell " , wcfF);
ws.addCell(labelCF);
// 添加带有字体颜色Formatting的对象
jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL, 10 , WritableFont.NO_BOLD, false ,
UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED);
jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);
jxl.write.Label labelCFC = new jxl.write.Label( 1 , 0 , " This is a Label Cell " , wcfFC);
ws.addCell(labelCF);
// 2.添加Number对象
jxl.write.Number labelN = new jxl.write.Number( 0 , 1 , 3.1415926 );
ws.addCell(labelN);
// 添加带有formatting的Number对象
jxl.write.NumberFormat nf = new jxl.write.NumberFormat( " #.## " );
jxl.write.WritableCellFormat wcfN = new jxl.write.WritableCellFormat(nf);
jxl.write.Number labelNF = new jxl.write.Number( 1 , 1 , 3.1415926 , wcfN);
ws.addCell(labelNF);
// 3.添加Boolean对象
jxl.write.Boolean labelB = new jxl.write.Boolean( 0 , 2 , false );
ws.addCell(labelB);
// 4.添加DateTime对象
jxl.write.DateTime labelDT = new jxl.write.DateTime( 0 , 3 , new java.util.Date());
ws.addCell(labelDT);
// 添加带有formatting的DateFormat对象
jxl.write.DateFormat df = new jxl.write.DateFormat( " dd MM yyyy hh:mm:ss " );
jxl.write.WritableCellFormat wcfDF = new jxl.write.WritableCellFormat(df);
jxl.write.DateTime labelDTF = new jxl.write.DateTime( 1 , 3 , new java.util.Date(), wcfDF);
ws.addCell(labelDTF);
jxl.write.Label labelC = new jxl.write.Label( 0 , 0 , " This is a Label cell " );
ws.addCell(labelC);
// 添加带有字型Formatting的对象
jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.TIMES, 18 , WritableFont.BOLD, true );
jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);
jxl.write.Label labelCF = new jxl.write.Label( 1 , 0 , " This is a Label Cell " , wcfF);
ws.addCell(labelCF);
// 添加带有字体颜色Formatting的对象
jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL, 10 , WritableFont.NO_BOLD, false ,
UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED);
jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);
jxl.write.Label labelCFC = new jxl.write.Label( 1 , 0 , " This is a Label Cell " , wcfFC);
ws.addCell(labelCF);
// 2.添加Number对象
jxl.write.Number labelN = new jxl.write.Number( 0 , 1 , 3.1415926 );
ws.addCell(labelN);
// 添加带有formatting的Number对象
jxl.write.NumberFormat nf = new jxl.write.NumberFormat( " #.## " );
jxl.write.WritableCellFormat wcfN = new jxl.write.WritableCellFormat(nf);
jxl.write.Number labelNF = new jxl.write.Number( 1 , 1 , 3.1415926 , wcfN);
ws.addCell(labelNF);
// 3.添加Boolean对象
jxl.write.Boolean labelB = new jxl.write.Boolean( 0 , 2 , false );
ws.addCell(labelB);
// 4.添加DateTime对象
jxl.write.DateTime labelDT = new jxl.write.DateTime( 0 , 3 , new java.util.Date());
ws.addCell(labelDT);
// 添加带有formatting的DateFormat对象
jxl.write.DateFormat df = new jxl.write.DateFormat( " dd MM yyyy hh:mm:ss " );
jxl.write.WritableCellFormat wcfDF = new jxl.write.WritableCellFormat(df);
jxl.write.DateTime labelDTF = new jxl.write.DateTime( 1 , 3 , new java.util.Date(), wcfDF);
ws.addCell(labelDTF);
在生成的excel文件中可以设定一些内容的格式
A1存在(0,0)里,B1存在(1,0)里