使用插件插件JExcelApi 导出Excel数据的

ski_mz

 
1.建立一个类
package mz;public class ClassroomDTO {private String stuName;private String stuPassword;public String getStuName() {return stuName;}public void setStuName(String stuName) {this.stuName = stuName;}public String getStuPassword() {return stuPassword;}public void setStuPassword(String stuPassword) {this.stuPassword = stuPassword;}} 
 
2.在建一个跟数据打交到的，这里我先用假数据。
package mz;import java.util.ArrayList;import java.util.List;public class ClassroomService {public List findAllClassroom(){List list = new ArrayList();ClassroomDTO to = new ClassroomDTO();to.setStuName("33333");to.setStuPassword("bbbbbbbbbbb");list.add(to);return list; }} 3.导出数据类
package mz;import java.io.File;import java.util.Iterator;import java.util.List;import jxl.Workbook;import jxl.write.Label;import jxl.write.WritableCellFormat;import jxl.write.WritableFont;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;public class ExportExcel {public void exportClassroom() throws Exception {try {String fileName = "c:\\aaa.xls";//WritableWorkbook wbook = Workbook.createWorkbook(new File(fileName));// WritableWorkbook wbook = Workbook.createWorkbook(os); //// 建立excel文件WritableSheet wsheet = wbook.createSheet("信息表", 0); // 工作表名称// 设置Excel字体WritableFont wfont = new WritableFont(WritableFont.ARIAL, 16,WritableFont.BOLD, false,jxl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.BLACK);WritableCellFormat titleFormat = new WritableCellFormat(wfont);String[] title = { "名称", "密码", };// 设置Excel表头for (int i = 0; i < title.length; i++) {Label excelTitle = new Label(i, 0, title, titleFormat);wsheet.addCell(excelTitle);}int c = 1; // 用于循环时Excel的行号ClassroomService cs = new ClassroomService();List list = cs.findAllClassroom(); // 这个是从数据库中取得要导出的数据Iterator it = list.iterator();while (it.hasNext()) {ClassroomDTO crdto = (ClassroomDTO) it.next();Label content1 = new Label(0, c, crdto.getStuName());Label content2 = new Label(1, c, crdto.getStuPassword());wsheet.addCell(content1);wsheet.addCell(content2);c++;}wbook.write(); // 写入文件wbook.close();} catch (Exception e) {throw new Exception("导出文件出错");}}public static void main(String[] args) throws Exception {ExportExcel tt = new ExportExcel();tt.exportClassroom();}} 
 
 
 
先说哈：及其简单的一个小列子.
JExcelApi v2.6.9
下载地址：http://www.andykhan.com/jexcelapi/download.html