錯誤：包：excel_input.javapackage input_excel;import java.io.File;import java.io.FileOutputStream;import java.util.List;import org.apache.commons.io.FileUtils;import org.apache.commons.lang3.StringUtils;import org.apache.poi.hssf.usermodel.DVConstraint;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFCellStyle;import org.apache.poi.hssf.usermodel.HSSFDataFormat;import org.apache.poi.hssf.usermodel.HSSFDataValidation;import org.apache.poi.hssf.usermodel.HSSFFont;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.util.CellRangeAddress;import org.apache.poi.ss.util.CellRangeAddressList;import org.jdom.Attribute;import org.jdom.Document;import org.jdom.Element;import org.jdom.input.SAXBuilder;public class excel { /** * 創(chuàng)建模板文件 */ public static void main(String[] args) { //獲取解析xml文件路徑 String path = System.getProperty("user.dir") + "/bin/student.xml"; File file = new File(path); SAXBuilder builder = new SAXBuilder(); try { //解析xml文件 Document parse = builder.build(file); //創(chuàng)建Excel HSSFWorkbook wb = new HSSFWorkbook(); //創(chuàng)建sheet HSSFSheet sheet = wb.createSheet("Sheet0"); //獲取xml文件跟節(jié)點 Element root = parse.getRootElement(); //獲取模板名稱 String templateName = root.getAttribute("name").getValue(); int rownum = 0; int column = 0; //設(shè)置列寬 Element colgroup = root.getChild("colgroup"); setColumnWidth(sheet,colgroup); //設(shè)置標(biāo)題 Element title = root.getChild("title"); List<Element> trs = title.getChildren("tr"); for (int i = 0; i < trs.size(); i++) { Element tr = trs.get(i); List<Element> tds = tr.getChildren("td"); HSSFRow row = sheet.createRow(rownum); HSSFCellStyle cellStyle = wb.createCellStyle(); cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); for(column = 0;column <tds.size();column ++){ Element td = tds.get(column); HSSFCell cell = row.createCell(column); Attribute rowSpan = td.getAttribute("rowspan"); Attribute colSpan = td.getAttribute("colspan"); Attribute value = td.getAttribute("value"); if(value !=null){ String val = value.getValue(); cell.setCellValue(val); int rspan = rowSpan.getIntValue() - 1; int cspan = colSpan.getIntValue() -1; //設(shè)置字體 HSSFFont font = wb.createFont(); font.setFontName("仿宋_GB2312"); font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);//字體加粗// font.setFontHeight((short)12); font.setFontHeightInPoints((short)12); cellStyle.setFont(font); cell.setCellStyle(cellStyle); //合并單元格居中 sheet.addMergedRegion(new CellRangeAddress(rspan, rspan, 0, cspan)); } } rownum ++; } //設(shè)置表頭 Element thead = root.getChild("thead"); trs = thead.getChildren("tr"); for (int i = 0; i < trs.size(); i++) { Element tr = trs.get(i); HSSFRow row = sheet.createRow(rownum); List<Element> ths = tr.getChildren("th"); for(column = 0;column < ths.size();column++){ Element th = ths.get(column); Attribute valueAttr = th.getAttribute("value"); HSSFCell cell = row.createCell(column); if(valueAttr != null){ String value =valueAttr.getValue(); cell.setCellValue(value); } } rownum++; } //設(shè)置數(shù)據(jù)區(qū)域樣式 Element tbody = root.getChild("tbody"); Element tr = tbody.getChild("tr"); int repeat = tr.getAttribute("repeat").getIntValue(); List<Element> tds = tr.getChildren("td"); for (int i = 0; i < repeat; i++) { HSSFRow row = sheet.createRow(rownum); for(column =0 ;column < tds.size();column++){ Element td = tds.get(column); HSSFCell cell = row.createCell(column); setType(wb,cell,td); } rownum++; } //生成Excel導(dǎo)入模板 File tempFile = new File("/Users/jasonho/" + templateName + ".xls"); tempFile.delete(); tempFile.createNewFile(); FileOutputStream stream = FileUtils.openOutputStream(tempFile); wb.write(stream); stream.close(); } catch (Exception e) { e.printStackTrace(); } } /** * 測試單元格樣式*/ private static void setType(HSSFWorkbook wb, HSSFCell cell, Element td) { Attribute typeAttr = td.getAttribute("type"); String type = typeAttr.getValue(); HSSFDataFormat format = wb.createDataFormat(); HSSFCellStyle cellStyle = wb.createCellStyle(); if("NUMERIC".equalsIgnoreCase(type)){ cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); Attribute formatAttr = td.getAttribute("format"); String formatValue = formatAttr.getValue(); formatValue = StringUtils.isNotBlank(formatValue)? formatValue : "#,##0.00"; cellStyle.setDataFormat(format.getFormat(formatValue)); }else if("STRING".equalsIgnoreCase(type)){ cell.setCellValue(""); cell.setCellType(HSSFCell.CELL_TYPE_STRING); cellStyle.setDataFormat(format.getFormat("@")); }else if("DATE".equalsIgnoreCase(type)){ cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); cellStyle.setDataFormat(format.getFormat("yyyy-m-d")); }else if("ENUM".equalsIgnoreCase(type)){ CellRangeAddressList regions =? new CellRangeAddressList(cell.getRowIndex(), cell.getRowIndex(),? cell.getColumnIndex(), cell.getColumnIndex()); Attribute enumAttr = td.getAttribute("format"); String enumValue = enumAttr.getValue(); //加載下拉列表內(nèi)容 DVConstraint constraint =? DVConstraint.createExplicitListConstraint(enumValue.split(",")); //數(shù)據(jù)有效性對象 HSSFDataValidation dataValidation = new HSSFDataValidation(regions, constraint); wb.getSheetAt(0).addValidationData(dataValidation); } cell.setCellStyle(cellStyle); } /** * 設(shè)置列寬 */ private static void setColumnWidth(HSSFSheet sheet, Element colgroup) { List<Element> cols = colgroup.getChildren("col"); for (int i = 0; i < cols.size(); i++) { Element col = cols.get(i); Attribute width = col.getAttribute("width"); String unit = width.getValue().replaceAll("[0-9,\\.]", ""); String value = width.getValue().replaceAll(unit, ""); int v=0; if(StringUtils.isBlank(unit) || "px".endsWith(unit)){ v = Math.round(Float.parseFloat(value) * 37f); }else if ("em".endsWith(unit)){ v = Math.round(Float.parseFloat(value) * 267.5f); } sheet.setColumnWidth(i, v); } }}————————————————————————————————————————————student.xml<?xml version="1.0" encoding="UTF-8"?><excel id="student" code="student" name="學(xué)生信息導(dǎo)入">? ? <colgroup>? ? ? ? <col index="A" width='17em'></col>? ? ? ? <col index="B" width='17em'></col>? ? ? ? <col index="C" width='17em'></col>? ? ? ? <col index="D" width='17em'></col>? ? ? ? <col index="E" width='17em'></col>? ? ? ? <col index="F" width='17em'></col> ? ? ? ?? ? </colgroup>? ? <title>? ? ? ? <tr height="16px">? ? ? ? ? ? <td rowspan="1" colspan="6" value="學(xué)生信息導(dǎo)入" />? ? ? ? </tr>? ? </title>? ? <thead>? ? ? ? <tr height="16px">? ? ? ? <th value="編號" />? ? ? ? ? ? <th value="姓名" />? ? ? ? ? ? <th value="年齡" />? ? ? ? ? ? <th value="性別" />? ? ? ? ? ? <th value="出生日期" />? ? ? ? ? ? <th value=" 愛好" /> ? ? ? ? ? ?? ? ? ? </tr>? ? </thead>? ? <tbody>? ? ? ? <tr height="16px" firstrow="2" firstcol="0" repeat="5">? ? ? ? ? ? <td type="string" isnullable="false" maxlength="30" /><!--用戶編號 -->? ? ? ? ? ? <td type="string" isnullable="false" maxlength="50" /><!--姓名 -->? ? ? ? ? ? <td type="numeric" format="##0" isnullable="false" /><!--年齡 -->? ? ? ? ? ? <td type="enum" format="男,女" isnullable="true" /><!--性別 -->? ? ? ? ? ? <td type="date" isnullable="false" maxlength="30" /><!--出生日期 -->? ? ? ? ? ? <td type="enum" format="足球,籃球,乒乓球" isnullable="true" /><!--愛好 -->? ? ? ? </tr>? ? </tbody></excel>