SSH
中用
apache
的
jxl.jar
导入导出
Excel
表格
2011-05-10 14:41 311 人阅读 评论(0) 收藏 举报
一.在 SSH 中导入生 Excel 表格的依赖包 Jxl.jar
二.在 service 层创建接口 IExcelService
package com.crms.service;
import java.io.InputStream;
import java.util.List;
/**
* struts2 导出 Excel
* @author Administrator
*
*/
public interface IExcelService {
public InputStream getExcelInputStream(List<Object[]> objList);
}
三.创建接口的实现类
package com.crms.service.impl;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts2.ServletActionContext;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.UnderlineStyle;
import jxl.format.VerticalAlignment;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
import com.crms.service.IExcelService;
评论30