添加內容
Lable 物件 (文字類型)
jxl.write.WritableFont wfc = new jxl.write.WritableFont(
WritableFont.ARIAL, //字型樣式
14, //字體大小
WritableFont.BOLD, //字體樣式
false,
UnderlineStyle.NO_UNDERLINE,
jxl.format.Colour.BLACK //文字顏色
);
jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);
jxl.write.Label Lable_name = new jxl.write.Label(
0, //列數
0, //行數
"This is a Label cell", //內容
wcfF //樣式,可以不輸入
);
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 //樣式,可以不輸入
);
Boolean 物件 (Boolane類型)
jxl.write.Boolean labelB = new jxl.write.Boolean(
0, //列數
2, //行數
false //boolane值
);
DateTime 物件 (時間日期類型)
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 //樣式,可以不輸入
);