java 数据导入_Java数据导入导出Excel

导出Excel

public boolean exportExcel(HttpServletResponse response,List list)

{

try

{

OutputStream os = response.getOutputStream();//取得输出流response.reset();//清空输出流response.setHeader("Content-disposition", "p_w_upload; filename=fine.xls");//设定输出文件头response.setContentType("application/msexcel");//定义输出类型WritableWorkbook wbook = Workbook.createWorkbook(os); //建立excel文件String tmptitle = "财务报表"; //标题WritableSheet wsheet = wbook.createSheet(tmptitle, 0); // sheet名称//设置excel标题WritableFont wfont = new WritableFont(WritableFont.ARIAL, 16,WritableFont.BOLD,

false,UnderlineStyle.NO_UNDERLINE,Colour.BLACK);

WritableCellFormat wcfFC = new WritableCellFormat(wfont);

wcfFC.setBackground(Colour.AQUA);

wsheet.addCell(new Label(1, 0, tmptitle, wcfFC));

wfont = new jxl.write.WritableFont(WritableFont.ARIAL, 14,WritableFont.BOLD,

false, UnderlineStyle.NO_UNDERLINE,Colour.BLACK);

wcfFC = new WritableCellFormat(wfont);

//开始生成主体内容wsheet.addCell(new Label(0, 2, "城市代码"));

wsheet.addCell(new Label(1, 2, "城市名"));

for(int i=0;i

{

wsheet.addCell(new Label(0, i+3, list.get(i).getCityid()));   //数据库的城市代码字段wsheet.addCell(new Label(1, i+3, list.get(i).getName()));  //数据库的城市名字段}

//主体内容生成结束wbook.write(); //写入文件wbook.close();

os.close(); //关闭流return true;

}

catch(Exception ex)

{

ex.printStackTrace();

return false;

}

}