在Java中向Excel文件写入内容-JSP教程,资料/其它

可随意转载，但请注明出处及作者
sonymusic
2003.05.15
==========================================================================
在java中向excel文件写入内容

四、导出数据到excel文件中
下面的例子，设置了数字、日期的格式，还有字体，颜色等。

file tempfile=new file("d:/temp/output.xls");
writableworkbook workbook = workbook.createworkbook(tempfile);
writablesheet sheet = workbook.createsheet("testcreateexcel", 0);

//一些临时变量，用于写到excel中
label l=null;
jxl.write.number n=null;
jxl.write.datetime d=null;

//预定义的一些字体和格式，同一个excel中最好不要有太多格式
writablefont headerfont = new writablefont(writablefont.arial, 12, writablefont.bold, false, underlinestyle.no_underline, jxl.format.colour.blue);
writablecellformat headerformat = new writablecellformat (headerfont);

writablefont titlefont = new writablefont(writablefont.arial, 10, writablefont.no_bold, false, underlinestyle.no_underline, jxl.format.colour.red);
writablecellformat titleformat = new writablecellformat (titlefont);

writablefont detfont = new writablefont(writablefont.arial, 10, writablefont.no_bold, false, underlinestyle.no_underline, jxl.format.colour.black);
writablecellformat detformat = new writablecellformat (detfont);

numberformat nf=new numberformat("0.00000");  //用于number的格式
writablecellformat priceformat = new writablecellformat (detfont, nf);

dateformat df=new dateformat("yyyy-mm-dd");//用于日期的
writablecellformat dateformat = new writablecellformat (detfont, df);

//剩下的事情，就是用上面的内容和格式创建一些单元格，再加到sheet中
l=new label(0, 0, "用于测试的excel文件", headerformat);
sheet.addcell(l);

//add title
int column=0;
l=new label(column++, 2, "标题", titleformat);
sheet.addcell(l);
l=new label(column++, 2, "日期", titleformat);
sheet.addcell(l);
l=new label(column++, 2, "货币", titleformat);
sheet.addcell(l);
l=new label(column++, 2, "价格", titleformat);
sheet.addcell(l);

//add detail
int i=0;
column=0;
l=new label(column++, i+3, "标题 "+i, detformat);
sheet.addcell(l);
d=new datetime(column++, i+3, new java.util.date(), dateformat);
sheet.addcell(d);
l=new label(column++, i+3, "cny", detformat);
sheet.addcell(l);
n=new jxl.write.number(column++, i+3, 5.678, priceformat);
sheet.addcell(n);

i++;
column=0;
l=new label(column++, i+3, "标题 "+i, detformat);
sheet.addcell(l);
d=new datetime(column++, i+3, new java.util.date(), dateformat);
sheet.addcell(d);
l=new label(column++, i+3, "sgd", detformat);
sheet.addcell(l);
n=new jxl.write.number(column++, i+3, 98832, priceformat);
sheet.addcell(n);

//设置列的宽度
column=0;
sheet.setcolumnview(column++, 20);
sheet.setcolumnview(column++, 20);
sheet.setcolumnview(column++, 10);
sheet.setcolumnview(column++, 20);

workbook.write();
workbook.close();