当前页面: 开发资料首页 → J2EE 专题 → POI操作Excel

POI操作Excel

摘要: POI操作Excel

我现在的工作是先读取excel模板，再从数据库里取出数据填充，模版已经做好，不需要修改
POI怎么把模版的信息读进来？急！

---

public void createEXCEL(String[]title,String sql,String path){

int i=0;
int j=0;

ResultSet rs=null;

try {
//建立与数据库的连接
conn.MyConnectSQLSERVER("dzl","traffic");
rs=conn.execQuery(sql);

//构建Workbook对象, 只读Workbook对象
//：创建可写入的Excel工作薄
WritableWorkbook wwb = Workbook.createWorkbook(new FileOutputStream(path));
WritableSheet ws = wwb.createSheet("sheet1", 0);

for( i=0;i WritableFont wf = new WritableFont(WritableFont.TIMES, 12, WritableFont.BOLD, false);
WritableCellFormat wcfF = new WritableCellFormat(wf);
Label labelCF = new Label(i, 0, title[i],wcfF);
ws.addCell(labelCF);
}

i=1;
while (rs.next()) {
for(j=1;j<=title.length;j++)
{
Label labelC = new Label(j-1,i, rs.getString(j));
ws.addCell(labelC);
}
i++;
}
//写入Exel工作表
wwb.write();
//关闭Excel工作薄对象
wwb.close();
rs.close();
conn.MyDisConnect();
}
catch (Exception e) {
System.out.println(e.toString());
}
}

---