完全用jxl包
首先写java文件
package com.test.excel;
import java.io. * ;
import jxl. * ;
import jxl.write. * ;
import jxl.format. * ;
import java.util. * ;
import java.awt.Color;
public class TestExcel ... {
public static void writeExcel(OutputStream os) throws Exception ...{
WritableWorkbook wwb = Workbook.createWorkbook(os);
WritableSheet ws = wwb.createSheet("TestSheet1", 0);
Label labelC = new Label(0, 0, "哈哈");
ws.addCell(labelC);
WritableFont wfc = new WritableFont(WritableFont.ARIAL,20, WritableFont.BOLD, false,
UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.GREEN);
WritableCellFormat wcfFC = new WritableCellFormat(wfc);
wcfFC.setBackground(jxl.format.Colour.RED);
labelC = new Label(4, 1, "gagaga呷呷机阿姐阿",wcfFC);
ws.addCell(labelC);
for(int i = 5;i<9;i++)...{ //循环操作写单元格
for(int j=0;j<4;j++)...{
labelC = new Label(j, i, i+""+j);
ws.addCell(labelC);
}
}
// 写入Exel工作表
wwb.write();
// 关闭Excel工作薄对象
wwb.close();
}
// 最好写一个这样的main方法来测试一下你的这个class是否写好了。
public static void main(String[] args)throws Exception...{
File f=new File("kk.xls");
f.createNewFile();
writeExcel(new FileOutputStream(f));
}
}
然后在页面显示:
excel,jsp
<% @page import = " com.test.excel.TestExcel " %>
<%
response.reset();
response.setContentType( " application/vnd.ms-excel " );
TestExcel.writeExcel(response.getOutputStream());
%>
首先写java文件
package com.test.excel;
import java.io. * ;
import jxl. * ;
import jxl.write. * ;
import jxl.format. * ;
import java.util. * ;
import java.awt.Color;
public class TestExcel ... {
public static void writeExcel(OutputStream os) throws Exception ...{
WritableWorkbook wwb = Workbook.createWorkbook(os);
WritableSheet ws = wwb.createSheet("TestSheet1", 0);
Label labelC = new Label(0, 0, "哈哈");
ws.addCell(labelC);
WritableFont wfc = new WritableFont(WritableFont.ARIAL,20, WritableFont.BOLD, false,
UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.GREEN);
WritableCellFormat wcfFC = new WritableCellFormat(wfc);
wcfFC.setBackground(jxl.format.Colour.RED);
labelC = new Label(4, 1, "gagaga呷呷机阿姐阿",wcfFC);
ws.addCell(labelC);
for(int i = 5;i<9;i++)...{ //循环操作写单元格
for(int j=0;j<4;j++)...{
labelC = new Label(j, i, i+""+j);
ws.addCell(labelC);
}
}
// 写入Exel工作表
wwb.write();
// 关闭Excel工作薄对象
wwb.close();
}
// 最好写一个这样的main方法来测试一下你的这个class是否写好了。
public static void main(String[] args)throws Exception...{
File f=new File("kk.xls");
f.createNewFile();
writeExcel(new FileOutputStream(f));
}
}
然后在页面显示:
excel,jsp
<% @page import = " com.test.excel.TestExcel " %>
<%
response.reset();
response.setContentType( " application/vnd.ms-excel " );
TestExcel.writeExcel(response.getOutputStream());
%>