写excel(二)
来源:互联网 发布:阿里云9.9学生机怎么用 编辑:程序博客网 时间:2024/05/16 14:39
String path = getServletContext().getRealPath("/excel");
// Method1: 创建可写入excel的工作簿
WritableWorkbook ww = Workbook.createWorkbook(new File(path+"/abc.xls"));
// Method2: 直接写入到工作流
// OutputStream os = new FileOutputStream("abc.xls");
// WritableWorkbook ww = Workbook.createWorkbook(os);
// 创建Excel工作表
WritableSheet ws = ww.createSheet("Test Sheet 1", 0);
// 添加Label对象
try {
//1. 添加Label对象
Label label0 = new Label(0,0,"This is Label cell");
ws.addCell(label0);
// 创建一个Times类型,18号,粗体,斜字体
WritableFont wf = new WritableFont(WritableFont.TIMES,18,WritableFont.BOLD,true);
WritableCellFormat wcf = new WritableCellFormat(wf);
Label label1 = new Label(0,1,"This is lable cell font format",wcf);
ws.addCell(label1);
// 添加带有字体颜色 Formatting 的对象
WritableFont wf2 = new WritableFont(WritableFont.ARIAL, 10,WritableFont.NO_BOLD, false,
UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED);
WritableCellFormat wcf2 = new WritableCellFormat(wf2);
Label label2 = new jxl.write.Label(1, 0, "This is a Label Cell", wcf2);
ws.addCell(label2);
//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);
} catch (RowsExceededException e) {
e.printStackTrace();
} catch (WriteException e) {
e.printStackTrace();
} finally{
if(ww != null){
try {
ww.close();
} catch (WriteException e) {
e.printStackTrace();
}
}
}
// Method1: 创建可写入excel的工作簿
WritableWorkbook ww = Workbook.createWorkbook(new File(path+"/abc.xls"));
// Method2: 直接写入到工作流
// OutputStream os = new FileOutputStream("abc.xls");
// WritableWorkbook ww = Workbook.createWorkbook(os);
// 创建Excel工作表
WritableSheet ws = ww.createSheet("Test Sheet 1", 0);
// 添加Label对象
try {
//1. 添加Label对象
Label label0 = new Label(0,0,"This is Label cell");
ws.addCell(label0);
// 创建一个Times类型,18号,粗体,斜字体
WritableFont wf = new WritableFont(WritableFont.TIMES,18,WritableFont.BOLD,true);
WritableCellFormat wcf = new WritableCellFormat(wf);
Label label1 = new Label(0,1,"This is lable cell font format",wcf);
ws.addCell(label1);
// 添加带有字体颜色 Formatting 的对象
WritableFont wf2 = new WritableFont(WritableFont.ARIAL, 10,WritableFont.NO_BOLD, false,
UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED);
WritableCellFormat wcf2 = new WritableCellFormat(wf2);
Label label2 = new jxl.write.Label(1, 0, "This is a Label Cell", wcf2);
ws.addCell(label2);
//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);
} catch (RowsExceededException e) {
e.printStackTrace();
} catch (WriteException e) {
e.printStackTrace();
} finally{
if(ww != null){
try {
ww.close();
} catch (WriteException e) {
e.printStackTrace();
}
}
}
- 写excel(二)
- jexcelapi写excel文件的抽象类(二)
- 关于 jsp servlet 将Excel表格内容写进数据库,将数据库导出到Excel中。(二)
- 基于jcom,java写数据到excel方式二(IDispatch)
- python 写excel(1)
- python 写excel(2)
- 导出Excel(二)
- 导出Excel(二)
- Excel导出(二)
- 导出excel(二)
- 随便写(二)
- 写Makefile(二)
- 写makefiles(二)
- Excel嵌入网页(二)
- Excel导入DataTable(二)
- Excel导入DataTable(二)
- Silverlight 导出excel (二)
- Excel使用大全(二)
- mybatis 学习二、SQL语句映射文件(1)resultMap
- 细说 #pragma pack(n)
- 如何去掉打印网页时自带的网址以及页码等内容
- Android 怎么样使用shape
- silverlight 乐动魔方 实战三
- 写excel(二)
- mybatis generator eclipse插件的安装
- Dom笔记5:document对象的属性
- mybatis 学习 二、SQL语句映射文件(2)增删改查、参数、缓存
- C#程序实现动态调用非托管的DLL文件
- CString GetBuffer 获得 TCHAR指针
- 让DIV在弹出位置在屏幕中间
- Unicode汉字编码表
- sdsd