Excel导出

ExcelTool.java

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class ExcelTool {
public static InputStream getInputStream(List<String[]> list,String sheetHeaders[]){
  HSSFWorkbook wb = new HSSFWorkbook();
  HSSFSheet sheet = wb.createSheet("sheet1");
  HSSFRow row = sheet.createRow(0);
  HSSFCell cell = null;
  for(int i=0;i<sheetHeaders.length;i++){
   cell = row.createCell((short) i);
   cell.setEncoding(HSSFCell.ENCODING_UTF_16);
   cell.setCellValue(sheetHeaders[i]);
  }
 
  for(int i=0;i<list.size();i++){
   String [] rows = list.get(i);
   row = sheet.createRow(i+1);
   for(int j=0;j<rows.length;j++){
    cell = row.createCell((short) j);
    cell.setEncoding(HSSFCell.ENCODING_UTF_16);
    cell.setCellValue(rows[j]);
   }
  }
 
  File file = new File("d://chen.xls");
  try {
   OutputStream out = new FileOutputStream(file);
   wb.write(out);
   out.close();
  } catch (FileNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IOException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 
 
  InputStream in = null;
  try {
   in = new FileInputStream(file);
  } catch (FileNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return in;
}
}




ExcelAction.java


import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

import com.opensymphony.xwork2.ActionSupport;

public class ExcelAction extends ActionSupport{
/**
  *
  */
private static final long serialVersionUID = 1L;

public InputStream getInputStream(){
  String headers[] = {"姓名","性别","年龄"};
  List<String[]> list = new ArrayList<String[]>();
  String rows[] = {"张三","男","24"};
  list.add(rows);
  return ExcelTool.getInputStream(list, headers);
}

public String execute(){
  System.out.println("in execute ...");
  return SUCCESS;
}
}


excle.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>
<package name="excel" extends="struts-default">
  <action name="excelAction" class="com.common.tool.ExcelAction">
   <result type="stream">
    <param name="ContentType">application/vnd.ms-excel</param>
    <param name="inputName">inputStream</param>
    <param name="contentDisposition">filename="user.xls"</param>
   </result>
  </action>
</package>
</struts>