jxl-jsp页面表格导出excel.docx

Springmvc框架下使用jxl方法把表格导出成excel简单方法 步骤： 1、导入jxl包 D:\dev\repository\net\sourceforge\jexcelapi\jxl\2.6.12\jxl-2.6.12.jar 添加依赖： dependency groupIdnet.sourceforge.jexcelapi/groupId artifactIdjxl/artifactId version2.6.12/version /dependency 2、新建类ExcelOutService import java.io.File; import java.io.IOException; import java.io.OutputStream; import java.text.SimpleDateFormat; import java.util.List; import jxl.write.Label; import jxl.write.WritableCellFormat; import jxl.write.WritableFont; import jxl.write.WritableImage; ? import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; ? import com.mvr.storeManagement.model.StockOut; ? import jxl.Workbook; import jxl.format.Alignment; import jxl.format.VerticalAlignment; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; ? public class ExcelOutService { public void downloadExcel(HttpServletResponse response, ListStockOut list,HttpServletRequest request) { ? SimpleDateFormat sdf =new SimpleDateFormat(yyyy/MM/dd); SimpleDateFormat sd =new SimpleDateFormat(yyyy-MM-dd); WritableWorkbook book = null; response.reset(); response.setCharacterEncoding(UTF-8); OutputStream os = null; ? try { response.setContentType(application/DOWLOAD); response.setCharacterEncoding(UTF-8); response.setHeader(Content-Disposition, attachment; filename=out.xls);// 设置生成的文件名字 os = response.getOutputStream(); book = Workbook.createWorkbook(os); } catch (Exception e) { e.printStackTrace(); } try { WritableSheet sheet = book.createSheet(出库单, 0); //wcff代表设置字体 加粗 字体大小 局中 WritableFont wfs = new WritableFont(WritableFont.TIMES,15,WritableFont.BOLD,false);//设置字体 WritableCellFormat wcff=new WritableCellFormat(wfs); wcff.setAlignment(Alignment.CENTRE);//居中对齐 ? //wcff1代表 设置字体大小 加粗 剧中 不加边框 WritableFont wfs2 = new WritableFont(WritableFont.TIMES,10,WritableFont.BOLD,false);//设置字体 WritableCellFormat wcff1=new WritableCellFormat(wfs2); wcff1.setVerticalAlignment(VerticalAlignment.