ExcelBean.java文件用于生成Excel
java 代码
- package com.zhupan.util;
-
- import java.io.OutputStream;
- import java.util.List;
-
- import jxl.Workbook;
- import jxl.format.Colour;
- import jxl.format.UnderlineStyle;
- import jxl.write.Label;
- import jxl.write.WritableCellFormat;
- import jxl.write.WritableFont;
- import jxl.write.WritableSheet;
- import jxl.write.WritableWorkbook;
-
- import com.ctgusec.model.Course_info;
- import com.ctgusec.model.Student_info;
-
- public class ExcelBean {
-
- public String expordExcel(OutputStream os, List courseList, List studentList)
- throws Exception {
-
- WritableWorkbook wbook = Workbook.createWorkbook(os);
- String tmptitle = "课程“"
- + ((Course_info) courseList.get(0)).getCource_name()
- + "”的选课学生列表";
- WritableSheet wsheet = wbook.createSheet("第一页", 0);
-
- WritableFont wfont = new WritableFont(WritableFont.ARIAL, 16,
- WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,
- Colour.BLACK);
- WritableCellFormat wcfFC = new WritableCellFormat(wfont);
- wsheet.addCell(new Label(1, 0, tmptitle, wcfFC));
- wfont = new jxl.write.WritableFont(WritableFont.ARIAL, 14,
- WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,
- Colour.BLACK);
- wcfFC = new WritableCellFormat(wfont);
-
- wsheet.addCell(new Label(0, 2, "课程名称"));
- wsheet.addCell(new Label(1, 2, "学 号"));
- wsheet.addCell(new Label(2, 2, "姓 名"));
- wsheet.addCell(new Label(3, 2, "性 别"));
- wsheet.addCell(new Label(4, 2, "学 院"));
- wsheet.addCell(new Label(5, 2, "班 级"));
- wsheet.addCell(new Label(6, 2, "专 业"));
- wsheet.addCell(new Label(7, 2, "备 注"));
- for (int i = 3; i < studentList.size() + 3; i++) {
- wsheet.addCell(new Label(0, i, ((Course_info) courseList.get(0))
- .getCource_name()));
- wsheet.addCell(new Label(1, i, ((Student_info) studentList.get(0))
- .getStudentID()));
- wsheet.addCell(new Label(2, i, ((Student_info) studentList.get(0))
- .getName()));
- wsheet.addCell(new Label(3, i, ((Student_info) studentList.get(0))
- .getSex()));
- wsheet.addCell(new Label(4, i, ((Student_info) studentList.get(0))
- .getUnit()));
- wsheet.addCell(new Label(5, i, ((Student_info) studentList.get(0))
- .getClass_()));
- wsheet.addCell(new Label(6, i, ((Student_info) studentList.get(0))
- .getSpecialty()));
- wsheet.addCell(new Label(7, i, ((Student_info) studentList.get(0))
- .getRemark()));
- }
-
- wbook.write();
- wbook.close();
- os.close();
- return "success";
- }
- }
控制器:
java 代码
- package com.ctgusec.spring;
-
- import java.io.OutputStream;
- import java.util.List;
-
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
-
- import org.springframework.web.servlet.ModelAndView;
- import org.springframework.web.servlet.mvc.AbstractController;
-
- import com.ctgusec.service.ICourse_infoManage;
- import com.zhupan.util.ExcelBean;
-
- public class EExcelDownController extends AbstractController {
-
- private ICourse_infoManage courseManage;
-
- public void setCourseManage(ICourse_infoManage courseManage) {
- this.courseManage = courseManage;
- }
-
- @Override
- protected ModelAndView handleRequestInternal(HttpServletRequest request,
- HttpServletResponse response) throws Exception {
- Integer course_id = new Integer(request.getParameter("course_id"));
- List courseList = this.courseManage.getCourseById(course_id);
- List studentList = this.courseManage.getStudentByCourseId(course_id);
- try {
- OutputStream os = response.getOutputStream();
- response.reset();
- response.setHeader("Content-disposition",
- "attachment; filename=student.xls");
- response.setContentType("application/msexcel");
- ExcelBean excelBean = new ExcelBean();
- excelBean.expordExcel(os, courseList, studentList);
- } catch (Exception e) {
- System.out.println(e);
- }
- return null;
- }
- }
分享到:
相关推荐
java利用jxl生成excel文件,代码直接导入就可以跑(修改自己的生成的ecxel地址)
jxl模版生成excel,采用类似EL表达式的方式生成模版
使用jxl生成excel的通用方法,参数List<?>数据,LinkedHashMap,String>实体类属性名和中文列名的键值对
poi jxl 生成EXCEL 报表 POI 用的JAR poi-3.6-20091214.jar jxl 用到的jar jxl-2.6.jar
自己封装的方法,调用 XlHelper.getXl(List<?> voList , Object head , OutputStream ops)方法,直接返回需要的excel,而不需要再去写jxl的方法。第一个参数voList 是excel里的内容,第二个参数head是excel表头。第...
利用jxl操作excel文件,提取exce文件数据生成txt文件。
java中使用jxl打印excel报表,java中使用jxl打印excel报表,java中使用jxl打印excel报表
jxl是对excel强有力的操纵工具,它具有丰富的API可以满足对excel的各种开发需要。
用jxl生成EXCEL表格,一个非常简单易懂的写法。
JXL生成excel报表,是一种专门用来制作excle的报表工具插件,用来处理导入到处操作
通过给出URL,用JXL进行下载 可以直接存到指定的目录
例子如下: Object是一个对象实体类,如Studnet.java. List 是一个对象集合,后面的是输出路径. WriteExcel rw=new WriteExcel(); rw.writeExcel(new Object(), List, "f:/a.xls","库存表");
jxl实现excel上传下载全部功能, 详细代码和java文件
学习使用JXL读写EXCEL文件, 学习使用JXL读写EXCEL文件。
jxl导出excel加水印 WritableWorkbook、WritableSheet、WritableCellFormat
NULL 博文链接:https://chaoyi.iteye.com/blog/2174163
JXL操作EXCEL 数据库导出EXCEL相关文件一些详细资料
资源包含:(1)一个txt转为excel Demo(2)将解析出的数据写入excel表格里所需要架包jxl。
jxl导出excel 完整例子工程jxl导出excel 完整例子工程jxl导出excel 完整例子工程 jxl导出excel 完整例子工程jxl导出excel 完整例子工程jxl导出excel 完整例子工程
jxl操作excel实例,jxl jar包下载 jxl操作excel实例,jxl jar包下载 jxl操作excel实例,jxl jar包下载