导出excel

<%@page import="java.util.*"%>
<jsp:directive.page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"/>
<jsp:directive.page import="org.apache.poi.hssf.usermodel.HSSFSheet"/>
<jsp:directive.page import="org.apache.poi.hssf.usermodel.HSSFRow"/>
<jsp:directive.page import="org.apache.poi.hssf.usermodel.HSSFCell"/>
<jsp:directive.page import="org.apache.poi.hssf.usermodel.HSSFCellStyle"/>
<jsp:directive.page import="org.apache.poi.hssf.util.HSSFColor"/>
<jsp:directive.page import="org.apache.poi.hssf.usermodel.HSSFFont"/>

<%
try
{
List list = (List)request.getAttribute("list");
if(list == null) list = new ArrayList();

         response.reset();
response.setContentType("application/vnd.ms-excel;charset=GBK");
   response.setCharacterEncoding("GBK");
response.setHeader("Content-Disposition","attachment;filename=\"Export.xls\"");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("HWM_HJ");
HSSFCellStyle style = wb.createCellStyle();
HSSFFont  ft = wb.createFont();
ft.setColor(HSSFColor.RED.index);
style.setFont(ft);
HSSFRow headerRow = sheet.createRow(0);
HSSFCell headerCell0 =  headerRow.createCell((short)0);
headerCell0.setCellValue("Item");
HSSFCell headerCell1 =  headerRow.createCell((short)1);
headerCell1.setCellValue("PartNo");
HSSFCell headerCell2 =  headerRow.createCell((short)2);
headerCell2.setCellValue("HWM date");
HSSFCell headerCell3 =  headerRow.createCell((short)3);
headerCell3.setCellValue("HWM");
HSSFCell headerCell4 =  headerRow.createCell((short)4);
headerCell4.setCellValue("Shipped Qty");
HSSFCell headerCell5 =  headerRow.createCell((short)5);
headerCell5.setCellValue("Gross use");
HSSFCell headerCell6 =  headerRow.createCell((short)6);
headerCell6.setCellValue("Liability");
if(list!=null && list.size()>0){
          for(int i=0;i<list.size();i++){
          HWMHJ obj = (HWMHJ)list.get(i);
            
              HSSFRow lineRow = sheet.createRow(i+1);
              HSSFCell lineCell0 = lineRow.createCell((short)0);
              lineCell0.setCellValue(obj.getItem());
              HSSFCell lineCell1 = lineRow.createCell((short)1);
              lineCell1.setCellValue(obj.getPartNo());
              HSSFCell lineCell2 = lineRow.createCell((short)2);
              lineCell2.setCellValue(obj.getHwmName());
              HSSFCell lineCell3 = lineRow.createCell((short)3);
              lineCell3.setCellValue(obj.getHwmQty());
              HSSFCell lineCell4 = lineRow.createCell((short)4);
  lineCell4.setCellValue(obj.getShippedQty());
              HSSFCell lineCell5 = lineRow.createCell((short)5);
              lineCell5.setCellValue(obj.getGrossUse());
              HSSFCell lineCell9 = lineRow.createCell((short)6);
              lineCell9.setCellValue(obj.getLiability());
           }
        }
        wb.write(response.getOutputStream());
response.getOutputStream().flush();
response.getOutputStream().close();
   
   }catch(Exception e)
{
e.printStackTrace();
throw new HSException("Export xls error!" + e.getMessage());
}
%>