81,094
社区成员
发帖
与我相关
我的任务
分享
package org.jiao.dao;
import java.io.*;
import jxl.*;
import jxl.write.*;
import jxl.format.*;
import java.util.*;
import java.awt.Color;
import java.util.List;
import java.util.ArrayList;
import java.util.Iterator;
public class ReadExcel {
public ReadExcel() {
}
public static void writeExcel(File f) throws Exception {
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(f);
jxl.write.WritableSheet ws = wwb.createSheet("goods", 0);
jxl.write.WritableFont wfc = new jxl.write.WritableFont(
WritableFont.createFont("宋体"), 12, WritableFont.NO_BOLD, false,
UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK);
jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(
wfc);
jxl.write.WritableCellFormat wcfFC1 = new jxl.write.WritableCellFormat(
wfc);
wcfFC.setBackground(jxl.format.Colour.LAVENDER);
wcfFC1.setBackground(jxl.format.Colour.WHITE);
jxl.write.Label labelC00 = new jxl.write.Label(0, 0, "第一列(goodscode)", wcfFC);//
jxl.write.Label labelC10 = new jxl.write.Label(1, 0, "第二列(name)", wcfFC);//
jxl.write.Label labelC11 = new jxl.write.Label(2, 0, "第三列(unit)", wcfFC);//
jxl.write.Label labelC12 = new jxl.write.Label(2, 0, "第三列(uprice)", wcfFC);//
ws.addCell(labelC00);
ws.addCell(labelC10);
ws.addCell(labelC11);
ws.addCell(labelC12);
/**
* 假如此方法是你查询的方法,
* 并且返回List,Good类是你的JavaBean类(封装数据) ,
* dao为你数据访问层的实例,调用查询方法
*/
List list=(ArrayList)dao.getGoods();
for(int i=0;i<list.size;i++)
{
Good good=(Good)list.get(i);
String goodscode=String.valueOf(good.getGoodscode()); //获得goodscode
String name=good.getName(); //获得name
String unit=good.getUnit();
String uprice=good.getUprice();
jxl.write.Label labelr1 = new Label(0, i + 1, goodscode);
jxl.write.Label labelr2 = new Label(1, i + 1, name);
jxl.write.Label labelr3 = new Label(2, i + 1, unit);
jxl.write.Label labelr4 = new Label(3, i + 1, uprice);
ws.addCell(labelr1);
ws.addCell(labelr2);
ws.addCell(labelr3);
ws.addCell(labelr4);
}
// 写入Exel工作表
wwb.write();
// 关闭Excel工作薄对象
wwb.close();
}
public static void main(String[] args) throws Exception {
String name = "T23班";
File f = new File("c:\\" + name + "--在读学员档案.xls");
f.createNewFile();
writeExcel(f);
}
}