java 导出并下载excel

来源：互联网发布：php from unixtime 编辑：程序博客网时间：2024/05/20 06:10

使用框架:jxl 官网：http://www.andykhan.com/jexcelapi/download.html

action代码:

//if("export".equals(option)){ByteArrayOutputStream os = new ByteArrayOutputStream();String [] headers=new String[]{"地区ID","地区编码","地区名称","简名","拼音","备注"};try {WritableWorkbook workbook = Workbook.createWorkbook(os);WritableSheet sheet = workbook.createSheet("Sheet1", 0);//组件列名for(int i=0;i<headers.length;i++){Label label = new Label(i, 0, headers[i]);sheet.addCell(label);}//组件数据for(int i=0;i<areas.size();i++){Label labelAreaId = new Label(0, i+1, areas.get(i).getAreaId());sheet.addCell(labelAreaId);Label labelAreaCode = new Label(1, i+1, areas.get(i).getAreaCode());sheet.addCell(labelAreaCode);Label labelAreaName = new Label(2, i+1, areas.get(i).getAreaName());sheet.addCell(labelAreaName);Label labelAreaSimpleName = new Label(3, i+1, areas.get(i).getAreaSimpleName());sheet.addCell(labelAreaSimpleName);Label labelAreaPinyin = new Label(4, i+1, areas.get(i).getAreaPinyin());sheet.addCell(labelAreaPinyin);Label labelAreaComment = new Label(5, i+1, areas.get(i).getAreaComment());sheet.addCell(labelAreaComment);}workbook.write();workbook.close();exportExcelFileName=new String((DateUtil.dateToStr(new Date(), "yyyyMMddHHmmss")+"_地区.xls").getBytes(), "ISO8859-1");inputStream = new ByteArrayInputStream(os.toByteArray());}catch(Exception e){e.printStackTrace();throw new ErpRuntimeException("system_export_error_message");}return option;}

struts.xml配置

<result name="export" type="stream">    <param name="contentType">application/vnd.ms-excel</param>    <param name="inputName">inputStream</param>    <param name="contentDisposition">attachment;filename="${exportExcelFileName}"</param>    <param name="bufferSize">1024</param> </result>

0 0