excel导出文件
// 创建一个新的excel文件，并将数据导入进去public static void writeExcel(ResultSet rs, String fileName,HttpServletResponse response) throws SQLException, IOException,RowsExceededException, WriteException {ResultSetMetaData rsmd = rs.getMetaData();// 获得导出数据的列数int columnCount = rsmd.getColumnCount();Vector columnNames = new Vector();for (int i = 1; i <= columnCount; i++) {// 获得指定列表的名字columnNames.add(rsmd.getColumnName(i));}Vector dataOfRows = new Vector();dataOfRows.add(columnNames);while (rs.next()) {Vector columnValues = new Vector();for (int i = 1; i <= columnCount; i++) {try {String columnValue = rs.getString(i);if (columnValue == null) {columnValue = "";}columnValues.add(columnValue);} catch (Exception e) {// 时间为空时会出异常columnValues.add("");}}dataOfRows.add(columnValues);}response.setContentType("application/x-msdownload");String time = (new Timestamp(System.currentTimeMillis())).toString().substring(2, 10).replaceAll("-", "");// 定义打印出来后的报表名String dispposition = "=?UTF-8?Q?attachment; filename="+ Utilities.toUtf8String(fileName + time)+ ".xls";response.setHeader("Content-Disposition", dispposition);OutputStream os = response.getOutputStream();jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);jxl.write.WritableSheet ws = wwb.createSheet(fileName, 0);for (int i = 0; i < dataOfRows.size(); i++) {for (int j = 0; j < columnCount; j++) {Label label = new Label(j, i, ((Vector) dataOfRows.get(i)).get(j).toString());ws.addCell(label);}}// 关闭Excel工作薄对象wwb.write();wwb.close();os.close();} 原先只写过导入 这次看了下同事写的导出很通用就放了上来 jxl包不用我介绍了吧 算了还是传1个上来大家也不用在别处找了
页:
[1]