用到的是 poi 的包。在 apache 的网站上去下 poi-bin-3.2-FINAL-20081019.zip,目前最新的版
本。
直接上代码了:
acon:
import com.opensymphony.xwork2.AconContext;
import com.opensymphony.xwork2.AconSupport;
import com.ps.model.UserBizInfo;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.ul.List;
import java.ul.Map;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class ExcelDownloadAcon extends AconSupport {
public InputStream getInputStream()
{
Map session=AconContext.getContext().getSession();
List<UserBizInfo> list=(List<UserBizInfo>)session.get("ecxelUserBizInfolist");
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("sheet1");
int rowNum = 0; // 标题开始行
int colNum = 0; // 标题开始列
// HSSFRow excell 的头
HSSFRow row = sheet.createRow(rowNum++);
// HSSFCell excell 的格子单元
HSSFCell cell = row.createCell((short)colNum++);
cell.setCellValue("Id");
cell = row.createCell((short)colNum++);
cell.setCellValue("用户名");
cell = row.createCell((short)colNum++);
cell.setCellValue("类型");
评论0