Java导入导出Excel
来源：互联网 发布：淘宝领的红包在哪里 编辑：程序博客网 时间：2024/05/17 23:26
Java导出Excel
1、先上模板类,里面都是Excel的各种属性,注释的很详细,为Excel共通类作铺垫
package com.framework.base.common.excel;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.math.BigDecimal;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;import org.apache.commons.lang.StringUtils;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
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.hssf.util.Region;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;import com.eos.data.xpath.XPathLocator;
import com.eos.foundation.data.DataObjectUtil;
import com.eos.foundation.database.DatabaseExt;
import com.eos.foundation.database.DatabaseUtil;
import com.eos.foundation.eoscommon.BusinessDictUtil;
import com.primeton.data.sdo.impl.PropertyImpl;
import com.primeton.data.sdo.impl.TypeReference;
import com.primeton.data.sdo.impl.types.BooleanType;
import com.primeton.data.sdo.impl.types.DateTimeType;
import com.primeton.data.sdo.impl.types.DateType;
import com.primeton.data.sdo.impl.types.DecimalType;
import com.primeton.data.sdo.impl.types.FloatType;
import com.primeton.data.sdo.impl.types.IntType;
import com.primeton.data.sdo.impl.types.IntegerType;
import com.primeton.data.sdo.impl.types.LongType;import commonj.sdo.DataObject;
import commonj.sdo.Type;
/**
* Excel模板实现类
* 实现通过自定义Excel数据模版,将结果集填充到模版相应位置，自动创
* 建输出到指定的文件，允许Excel模版设置公式，调用方法如下：
* ExcelTemplate template=new ExcelTemplate(templateFilePath,outputFilePath)
* //template.setIncludeFormula(true);设置包含公式
* template.generate(ResultSet);//resultset为ArrayList对象,数据行以
* //template.generate(titleMap,dataList)//显示主表、明细表信息
* @author Me
*/
public class ExcelTemplate {
/**
* 模板文件名
*/
private String templateFile;
private int startRow = -1;/** * 输出文件名 */private String outputFile;/** * Excel模板定义的输出字段名数组 */private String[] fieldNames;private int tempStartRowNum = -1;/** * 默认字体大小 */private int fontSize = 10;/** * 默认字体 */private String fontName = "宋体";/** * 是否设置信息标题栏边框,默认情况不设置边框 */private boolean titleCellBold = false;/** * 是否设置空白栏边框，默认情况不设置边框 */private boolean blankCellBold = false;/** * 是否自动分工作薄 */private boolean autoSheet = false;/** * 是否自动分页 */private boolean autoPagination = false;/** * 分页行数 */private int maxrow = -1;/** * 是否有公式 */private boolean hasFormula = false;/** * 关键字 * &-表示模版信息内容字段 * #-表示模版明细内容字段 * formula-表示模版函数关键字 * ~-表示Cell当前行，当包含":"时，表示当前行减1 */private final String TITLE_FLAG = "&";private final String CONTENT_FLAG = "#";private final String FORMULA_FLAG = "formula";private final String UNLIMIT_FLAG = "~";private final String FIELD_AUTO_ID = "_id";/** * 公式计算操作符号 */private final String[] OP_FLAG = new String[] { "+", "-", "*", "/", "%", ":" };/** * 默认构造函数 * */public ExcelTemplate() {}/** * 构造器 * @param templateFile 模版文件 * @param outputFile 输出文件 */public ExcelTemplate(String templateFile, String outputFile) { this.templateFile = templateFile; this.outputFile = outputFile;}/** * 设置模版文件是否包含Excel公式 * @param hasFormula */public void setIncludeFormula(boolean hasFormula) { this.hasFormula = hasFormula;}/** * 设置标题栏是否需要边框 * @param b */public void setTitleCellBold(boolean titleCellBold) { this.titleCellBold = titleCellBold;}/** * 设置空白行是否需要显示边框 * @param blankCellBold */public void setBlankCellBold(boolean blankCellBold) { this.blankCellBold = blankCellBold;}/** * 设置是否分工作薄 * @param b */public void setAutoSheet(boolean autoSheet) { this.autoSheet = autoSheet; this.autoPagination = (autoSheet ? false : autoPagination);}/** * 是否自动分页 * @param autoPagination */public void setAutoPagination(boolean autoPagination) { this.autoPagination = autoPagination; this.autoSheet = (autoPagination ? false : autoSheet);}/** * 设置分页最大行 * @param maxrow */public void setMaxRow(int maxrow) { this.maxrow = maxrow;}/** * 设置字体大小，默认10号字体 * @param size */public void setFontSize(int size) { this.fontSize = size;}public void setFontName(String fontName) { this.fontName = fontName;}/** * 计算公式,默认范围从0行到工作薄结尾 * @param wb * @param sheet */private void calcFormula(HSSFWorkbook wb, HSSFSheet sheet) { this.calcFormula(wb, sheet, 0, sheet.getPhysicalNumberOfRows());}/** * 计算公式函数,范围从开始行(start_row)到结束行(end_row) * @param wb HSSFWorkbook * @param sheet HSSFSHeet * @param start_rang * @param end_rang */private void calcFormula(HSSFWorkbook wb, HSSFSheet sheet, int start_rang, int end_rang) { //int rows = sheet.getPhysicalNumberOfRows(); HSSFCellStyle borderStyle = this.getBorderStyle(wb); HSSFCellStyle noneStyle = this.getNoneStyle(wb); for (int r = start_rang; r < end_rang; r++) { HSSFRow row = sheet.getRow(r); if (row != null) { int cells = row.getPhysicalNumberOfCells(); for (short c = 0; c < cells; c++) { HSSFCell cell = row.getCell(c); if (cell != null) { if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) { String value = cell.getRichStringCellValue().getString(); if (value != null) { value = value.trim().toLowerCase(); if (value.startsWith(FORMULA_FLAG)) { int index = value.indexOf("="); String formula = value.substring(index + 1); //判断函数是否包含以#开头,如果是以#开头表示必须显示边框， String flag = formula.substring(0, 1); boolean showBold = false; if (flag.equals(CONTENT_FLAG)) { formula = formula.substring(1); showBold = true; } //如果包含':'符号则统计公式不包含当前行,否则会引发公式循环引用错误. if (formula.indexOf(":") != -1) { formula = formula.replaceAll(UNLIMIT_FLAG, r + "").toUpperCase(); } else { formula = formula.replaceAll(UNLIMIT_FLAG, (r + 1) + "").toUpperCase(); } //判断公式对应的Cell内容是否为blank, //如果公式对应的CELL内容为空，则设置为"" int rightIndex = formula.indexOf(")"); int leftIndex = formula.indexOf("("); String content = formula.substring(leftIndex + 1, rightIndex); int opIndex = this.getOpIndex(content); String startPos = content.substring(0, opIndex); String endPos = content.substring(opIndex + 1); int start_col = this.getColumnIndex(startPos.charAt(0)); int start_row = Integer.parseInt(startPos.substring(1)); int end_col = this.getColumnIndex(endPos.charAt(0)); int end_row = Integer.parseInt(endPos.substring(1)); HSSFCell startC = sheet.getRow(start_row - 1).getCell((short) start_col); HSSFCell endC = sheet.getRow(end_row - 1).getCell((short) end_col); //判断公式开始Cell与结束cell内容是否无效 //当为均为无效的cell值，并且当前公式不包含":"，则设置公式框内容为""， //包含":" 则设置为计算公式 if (invalidCellValue(startC) && invalidCellValue(endC)) { if (formula.indexOf(":") == -1) { cell.setCellValue(new HSSFRichTextString("")); } else { cell = row.createCell((short) c); cell.setCellType(HSSFCell.CELL_TYPE_FORMULA); cell.setCellFormula(formula); } } else { //重建Cell cell = row.createCell((short) c); cell.setCellType(HSSFCell.CELL_TYPE_FORMULA); cell.setCellFormula(formula); } if (showBold) { cell.setCellStyle(borderStyle); } else { cell.setCellStyle(noneStyle); } } } } } } } }}/** * 设置公式文本框为空白栏，当统计开始行减1==startRowNum时 * @param cell * @param startRowNum */private void setFormulaBlankCell(HSSFCell cell, int startRowNum) { if (cell != null) { if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) { String value = cell.getRichStringCellValue().getString(); if (value != null) { value = value.trim().toLowerCase(); if (value.startsWith(FORMULA_FLAG)) { int index = value.indexOf("="); String formula = value.substring(index + 1); String flag = formula.substring(0, 1); if (flag.equals(CONTENT_FLAG)) formula = formula.substring(1); if (formula.indexOf(":") != -1) { int rightIndex = formula.indexOf(")"); int leftIndex = formula.indexOf("("); String content = formula.substring(leftIndex + 1, rightIndex).toUpperCase(); int opIndex = this.getOpIndex(content); String startPos = content.substring(0, opIndex); String colValue = startPos.substring(1, opIndex); if (Integer.parseInt(colValue) - 1 == startRowNum) cell.setCellType(HSSFCell.CELL_TYPE_BLANK); } } } } }}/** * 生成填充模版标题数据 * * @param titleMap * @param wb * @param sheet * @throws Exception */private void generateTitleDatas(DataObject exportInfo, HSSFWorkbook wb, HSSFSheet sheet) throws Exception { int rows = sheet.getPhysicalNumberOfRows(); HSSFCellStyle borderStyle = this.getBorderStyle(wb); HSSFCellStyle noneStyle = this.getNoneStyle(wb); for (int r = 0; r < rows; r++) { HSSFRow row = sheet.getRow(r); if (row != null) { int cells = row.getPhysicalNumberOfCells(); for (short c = 0; c < cells; c++) { HSSFCell cell = row.getCell(c); if (cell != null) { if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) { String value = cell.getRichStringCellValue().getString(); if (value != null) { value = value.trim(); if (value.startsWith(TITLE_FLAG)) { value = value.substring(1); //获取对应的值，支持XPATH取值 Object obj = XPathLocator.newInstance().getValue(exportInfo, value); String content = obj + ""; //String content=exportInfo.getString(value); if (content == null) content = ""; //重建Cell，填充标题值 cell = row.createCell((short) c); cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setCellValue(new HSSFRichTextString(content)); if (!titleCellBold) { cell.setCellStyle(noneStyle); } else { cell.setCellStyle(borderStyle); } } } } } } } }}/** * 将指定的对象数组resulset输出到指定的Excel位置 * @param resultset List<DataObject>对象数组 * @param wb HSSFWorkbook * @param sheet HSSFSheet */private void generateContentDatas(List<DataObject> resultset, HSSFWorkbook wb, HSSFSheet sheet) { HSSFCellStyle borderStyle = this.getBorderStyle(wb); HSSFCellStyle noneStyle = this.getNoneStyle(wb); //默认行号 int autoRowId = 1; for (Iterator it = resultset.iterator(); it.hasNext(); autoRowId++) { DataObject content = (DataObject) it.next(); HSSFRow sourceRow = sheet.getRow(startRow); HSSFRow row = sheet.createRow(startRow++); for (int i = 0; i < sourceRow.getPhysicalNumberOfCells(); i++) { //输出自动生成的行号 if (fieldNames[i] != null && fieldNames[i].equals(FIELD_AUTO_ID)) { HSSFCell cell = row.createCell((short) i); cell.setCellStyle(borderStyle); cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setCellValue(autoRowId); continue; } if (fieldNames[i] != null) { String fieldname = fieldNames[i]; String fieldtype = ""; String fieldproperty = ""; HSSFCell cell = row.createCell((short) i); cell.setCellStyle(borderStyle); if (content != null) { //字段名支持xpath取值 if (fieldname.contains("#")) { String[] colcofigs = fieldname.split("#"); fieldname = colcofigs[0]; fieldtype = colcofigs[1]; fieldproperty = colcofigs[2]; } Object value = XPathLocator.newInstance().getValue(content, fieldname); //Object value=content.get(fieldNames[i]); if (value != null) { if (value instanceof Double || value instanceof BigDecimal) { cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); cell.setCellValue(Double.parseDouble(value.toString())); } else { cell.setCellType(HSSFCell.CELL_TYPE_STRING); if (fieldNames[i].contains("#")) {//说明需要转码 if ("DICT".equals(fieldtype)) { DataObject[] results = BusinessDictUtil.getDictInfoByTypeAndSort(fieldproperty, "sortno", false); value = parseCodeForMulti(results, value.toString(), false); } if ("DATE".equals(fieldtype)) { SimpleDateFormat sdf = new SimpleDateFormat(fieldproperty); value = sdf.format((Timestamp) value); } } cell.setCellValue(new HSSFRichTextString(value.toString())); } } else { cell.setCellType(HSSFCell.CELL_TYPE_BLANK); } } else { cell.setCellType(HSSFCell.CELL_TYPE_BLANK); if (!blankCellBold) { cell.setCellStyle(noneStyle); } else { cell.setCellStyle(borderStyle); } } } else { HSSFCell sourceCell = sourceRow.getCell((short) i); if (sourceCell != null && sourceCell.getCellType() == HSSFCell.CELL_TYPE_STRING && sourceCell.getRichStringCellValue().getString() != null && sourceCell.getRichStringCellValue().getString().toLowerCase().startsWith(FORMULA_FLAG)) { HSSFCell cell = row.createCell((short) i); cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setCellValue(sourceCell.getRichStringCellValue()); } } } if (it.hasNext()) { //向下平推一行 //sheet.shiftRows(startRow-1,sheet.getLastRowNum(),1); shiftDown(sheet, startRow - 1, sheet.getLastRowNum(), 1); } }}/** * 将结果集填充到Excel模版,resultset必须是以Map封装行 * @param * @param resultset 数据内容 * @throws Exception */public void generate(List<DataObject> resultset, String headerConfig) throws Exception { this.generate(resultset, null, headerConfig);}/** * 将结果集填充到Excel模版,resultset必须是以Map封装行 * @param resultset 结果集 * @param headerConfig TODO * @param titleMap 标题信息 * @throws Exception */public void generate(List<DataObject> resultset, DataObject exportInfo, String headerConfig) throws Exception { POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(templateFile)); HSSFWorkbook wb = new HSSFWorkbook(fs); HSSFSheet sheet = wb.getSheetAt(0); initialize(sheet); if (startRow == -1) return; if (this.autoPagination) { this.generatePagination(wb, sheet, resultset, exportInfo); } else if (this.autoSheet) { generatePaginationSheet(wb, sheet, resultset, exportInfo); } else { //先填充标题 if (exportInfo != null) this.generateTitleDatas(exportInfo, wb, sheet); //生成数据内容 this.generateContentDatas(resultset, wb, sheet); if (hasFormula) { this.calcFormula(wb, sheet); } } FileOutputStream fileOut = new FileOutputStream(outputFile); wb.write(fileOut); fileOut.close();}private void initialize(HSSFSheet sheet) { boolean setStart = false; int rows = sheet.getPhysicalNumberOfRows(); for (int r = 0; r < rows; r++) { HSSFRow row = sheet.getRow(r); if (row != null) { int cells = row.getPhysicalNumberOfCells(); for (short c = 0; c < cells; c++) { HSSFCell cell = row.getCell(c); if (cell != null) { String value = null; if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) { value = "" + cell.getNumericCellValue(); } else if (cell.getCellType() == HSSFCell.CELL_TYPE_BOOLEAN) { value = "" + cell.getBooleanCellValue(); } else { value = cell.getRichStringCellValue().getString(); } if (value != null && !"".equals(value)) { value = value.trim(); if (value.startsWith(CONTENT_FLAG)) { if (!setStart) { this.startRow = r; this.fieldNames = new String[cells]; setStart = true; } this.fieldNames[c] = value.substring(1);//��ʼ�������ֶ� } } } } } }}/** * EXCEL分页 * 必须在EXCEL模版的最后一行插入EXCEL分页符! * @param wb HSSFWorkbook * @param sourceSheet HSSFSheet * @param resultset 填充数据集 * @param titleMap 信息栏内容 * @throws Exception */private void generatePagination(HSSFWorkbook wb, HSSFSheet sourceSheet, List<DataObject> resultset, DataObject exportInfo) throws Exception { int startPosition = startRow; tempStartRowNum = startRow; int count = resultset.size() / maxrow; int num = resultset.size() % maxrow; int rows = sourceSheet.getPhysicalNumberOfRows(); System.out.println("rows=" + rows); if (num > 0) { count = count + 1; num = maxrow - num; //不足指定的maxrow，添加空行 for (int i = 0; i < num; i++) { resultset.add(null); } } //删除最后一行的分页符 try { sourceSheet.removeRowBreak(rows - 1); } catch (NullPointerException npe) { throw new Exception("指定的EXCEL模版文件[" + this.templateFile + "] 未插入分页符"); } //超过1页则插入分页符 for (int i = 1; i < count; i++) { //设置分页符 sourceSheet.setRowBreak(i * rows - 1); this.copyRows(sourceSheet, sourceSheet, 0, rows, i * rows + 1); } if (exportInfo != null) this.generateTitleDatas(exportInfo, wb, sourceSheet); int current_page = 0; while (current_page < count) { List<DataObject> newList = resultset.subList(current_page * maxrow, maxrow * (current_page + 1)); this.generateContentDatas(newList, wb, sourceSheet); current_page++; //计算下一行的数据填充起始位置 startRow = current_page * rows + maxrow + startPosition; } if (hasFormula) this.calcFormula(wb, sourceSheet);}/** * 生成分页的工作薄模版 * @param wb HSSFWorkbook * @param sourceSheet HSSFSheet * @param resultset 填充数据集 * @param titleMap 信息(标题)栏内容 */private void generatePaginationSheet(HSSFWorkbook wb, HSSFSheet sourceSheet, List<DataObject> resultset, DataObject exportInfo) throws Exception { int startPosition = startRow; int count = resultset.size() / maxrow; int num = resultset.size() % maxrow; if (num > 0) { count = count + 1; num = maxrow - num; //不足指定的maxrow，添加空行 for (int i = 0; i < num; i++) { resultset.add(null); } } for (int i = 1; i < count; i++) { HSSFSheet newsheet = wb.createSheet("Page " + i); this.copyRows(sourceSheet, newsheet, 0, sourceSheet.getLastRowNum(), 0); } if (count > 1) { for (int i = 0; i < wb.getNumberOfSheets(); i++) { startRow = startPosition; List<DataObject> newList = resultset.subList(i * maxrow, maxrow * (i + 1)); HSSFSheet sheet = wb.getSheetAt(i); //先填充标题 if (exportInfo != null) this.generateTitleDatas(exportInfo, wb, sheet); this.generateContentDatas(newList, wb, sheet); if (hasFormula) this.calcFormula(wb, sheet); } } else { HSSFSheet sheet = wb.getSheetAt(0); if (exportInfo != null) this.generateTitleDatas(exportInfo, wb, sheet); this.generateContentDatas(resultset, wb, sheet); if (hasFormula) this.calcFormula(wb, sheet); }}private HSSFCellStyle getBorderStyle(HSSFWorkbook wb) { HSSFCellStyle style = wb.createCellStyle(); HSSFFont font = wb.createFont(); font.setFontHeightInPoints((short) fontSize); font.setFontName(fontName); style.setFont(font); style.setBorderBottom(HSSFCellStyle.BORDER_THIN); style.setBorderLeft(HSSFCellStyle.BORDER_THIN); style.setBorderRight(HSSFCellStyle.BORDER_THIN); style.setBorderTop(HSSFCellStyle.BORDER_THIN); return style;}private HSSFCellStyle getNoneStyle(HSSFWorkbook wb) { HSSFCellStyle style = wb.createCellStyle(); HSSFFont font = wb.createFont(); font.setFontHeightInPoints((short) fontSize); font.setFontName(fontName); style.setFont(font); style.setBorderBottom(HSSFCellStyle.BORDER_NONE); style.setBorderLeft(HSSFCellStyle.BORDER_NONE); style.setBorderRight(HSSFCellStyle.BORDER_NONE); style.setBorderTop(HSSFCellStyle.BORDER_NONE); return style;}/** * 向下平推表格，并复制格式与内容 * @param thisrow：当前行号 * @param lastrow：最后行号 * @param shiftcount：平推量 */private void shiftDown(HSSFSheet sheet, int thisrow, int lastrow, int shiftcount) { sheet.shiftRows(thisrow, lastrow, shiftcount); for (int z = 0; z < shiftcount; z++) { HSSFRow row = sheet.getRow(thisrow); HSSFRow oldrow = sheet.getRow(thisrow + shiftcount); //将各行的行高复制 oldrow.setHeight(row.getHeight()); //将各个单元格的格式复制 for (short i = 0; i <= oldrow.getPhysicalNumberOfCells(); i++) { HSSFCell cell = row.createCell(i); HSSFCell oldcell = oldrow.getCell(i); if (oldcell != null) { switch (oldcell.getCellType()) { case HSSFCell.CELL_TYPE_STRING: cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setCellValue(oldcell.getRichStringCellValue()); break; case HSSFCell.CELL_TYPE_NUMERIC: cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC); cell.setCellValue(oldcell.getNumericCellValue()); break; default: cell.setCellType(HSSFCell.CELL_TYPE_STRING); cell.setCellValue(oldcell.getRichStringCellValue()); } cell.setCellStyle(oldcell.getCellStyle()); } } //将有列跨越的复制 Vector regs = findRegion(sheet, oldrow); if (regs.size() != 0) { for (int i = 0; i < regs.size(); i++) { Region reg = (Region) regs.get(i); reg.setRowFrom(row.getRowNum()); reg.setRowTo(row.getRowNum()); sheet.addMergedRegion(reg); } } thisrow++; }}/*** 查找所有的合并单元格* @param oldrow* @return*/private Vector findRegion(HSSFSheet sheet, HSSFRow oldrow) { Vector<Region> regs = new Vector<Region>(); int num = sheet.getNumMergedRegions(); int curRowid = oldrow.getRowNum(); for (int i = 0; i < num; i++) { Region reg = sheet.getMergedRegionAt(i); if (reg.getRowFrom() == reg.getRowTo() && reg.getRowFrom() == curRowid) { regs.add(reg); } } return regs;}/** * 复制EXCEL行到指定的工作薄上 * ××如果是分页显示，需要增加一个判断：当复制行包含公式forumla=sum(G7:G~)字样时候，必须修改其实行G7为相应的新行。 * @param sourceSheet 原工作薄 * @param targetSheet 目标工作薄 * @param pStartRow 复制起始行 * @param pEndRow 复制终止行 * @param pPosition 插入位置 */private void copyRows(HSSFSheet sourceSheet, HSSFSheet targetSheet, int pStartRow, int pEndRow, int pPosition) { HSSFRow sourceRow = null; HSSFRow targetRow = null; HSSFCell sourceCell = null; HSSFCell targetCell = null; Region region = null; int cType; int i; short j; int targetRowFrom; int targetRowTo; if ((pStartRow == -1) || (pEndRow == -1)) { return; } // 拷贝合并的单元格 for (i = 0; i < sourceSheet.getNumMergedRegions(); i++) { region = sourceSheet.getMergedRegionAt(i); if ((region.getRowFrom() >= pStartRow) && (region.getRowTo() <= pEndRow)) { targetRowFrom = region.getRowFrom() - pStartRow + pPosition; targetRowTo = region.getRowTo() - pStartRow + pPosition; region.setRowFrom(targetRowFrom); region.setRowTo(targetRowTo); targetSheet.addMergedRegion(region); } } // 设置列宽 for (i = pStartRow; i <= pEndRow; i++) { sourceRow = sourceSheet.getRow(i); if (sourceRow != null) { for (j = sourceRow.getFirstCellNum(); j < sourceRow.getLastCellNum(); j++) { targetSheet.setColumnWidth(j, sourceSheet.getColumnWidth(j)); } break; } } // 拷贝行并填充数据 for (; i <= pEndRow; i++) { sourceRow = sourceSheet.getRow(i); if (sourceRow == null) { continue; } targetRow = targetSheet.createRow(i - pStartRow + pPosition); targetRow.setHeight(sourceRow.getHeight()); for (j = sourceRow.getFirstCellNum(); j < sourceRow.getLastCellNum(); j++) { sourceCell = sourceRow.getCell(j); if (sourceCell == null) { continue; } targetCell = targetRow.createCell(j); targetCell.setCellStyle(sourceCell.getCellStyle()); cType = sourceCell.getCellType(); targetCell.setCellType(cType); switch (cType) { case HSSFCell.CELL_TYPE_BOOLEAN: targetCell.setCellValue(sourceCell.getBooleanCellValue()); break; case HSSFCell.CELL_TYPE_ERROR: targetCell.setCellErrorValue(sourceCell.getErrorCellValue()); break; case HSSFCell.CELL_TYPE_FORMULA: targetCell.setCellFormula(parseFormula(sourceCell.getCellFormula())); break; case HSSFCell.CELL_TYPE_NUMERIC: targetCell.setCellValue(sourceCell.getNumericCellValue()); break; case HSSFCell.CELL_TYPE_STRING: targetCell.setCellValue(sourceCell.getRichStringCellValue()); break; } if (this.autoPagination) { this.setFormulaBlankCell(sourceCell, tempStartRowNum); } } }}private String parseFormula(String pPOIFormula) { final String cstReplaceString = "ATTR(semiVolatile)"; //$NON-NLS-1$ StringBuffer result = null; int index; result = new StringBuffer(); index = pPOIFormula.indexOf(cstReplaceString); if (index >= 0) { result.append(pPOIFormula.substring(0, index)); result.append(pPOIFormula.substring(index + cstReplaceString.length())); } else { result.append(pPOIFormula); } return result.toString();}/*** 将列的索引换算成ABCD字母，这个方法要在插入公式时用到* @param colIndex 列索引。* @return ABCD字母。*//*private String getColLetter(int colIndex){ String ch = ""; if (colIndex < 26) ch = "" + (char)((colIndex) + 65); else ch = "" + (char)((colIndex) / 26 + 65 - 1) + (char)((colIndex) % 26 + 65); return ch;}*/private int getColumnIndex(char c) { int i = c; return i - 65;}private int getOpIndex(String s) { for (int i = 0; i < OP_FLAG.length; i++) { int index = s.indexOf(OP_FLAG[i]); if (index != -1) { return index; } } return -1;}/** * 判断是否无效Cell * @param cell * @return */private boolean invalidCellValue(HSSFCell cell) { if (cell.getCellType() == HSSFCell.CELL_TYPE_BLANK) { return true; } else if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) { if (cell.getRichStringCellValue().getString() == null || cell.getRichStringCellValue().getString().equals("")) { return true; } } else if (cell.getCellType() == HSSFCell.CELL_TYPE_ERROR) { return true; } return false;}public DataObject[] parseExcel2DataObject(String targetFile, String entityName, String headerConfig) throws Exception { FileInputStream fis = new FileInputStream(targetFile); List<DataObject> dataObjectList = new ArrayList<DataObject>(); try { POIFSFileSystem fs = new POIFSFileSystem(fis); HSSFWorkbook wb = new HSSFWorkbook(fs); for (int sheetCount = 0; sheetCount < wb.getNumberOfSheets(); sheetCount++) {//支持多sheet页 HSSFSheet sheet = wb.getSheetAt(sheetCount); int rows = sheet.getPhysicalNumberOfRows(); this.fieldNames = headerConfig.split(";"); //第一行为#字段名 //根据第二行标题进行判断，模板是否正确 HSSFRow sourceRowTitle = sheet.getRow(1); //判断标题最后一栏是否有值 if("".equals(sourceRowTitle.getCell((short) (this.fieldNames.length - 1)))|| null == sourceRowTitle.getCell((short) (this.fieldNames.length - 1))){ //如果没有值，证明模板错误，抛出异常 throw new Exception(); } //判断标题下一栏是否有值 if(!"".equals(sourceRowTitle.getCell((short) (this.fieldNames.length))) && null != sourceRowTitle.getCell((short) (this.fieldNames.length))){ //如果有值，证明模板错误，抛出异常 throw new Exception(); } //第二行为字段标题，因此内容读取从startRow+2 for (int rowCount = 2; rowCount < rows; rowCount++) { HSSFRow sourceRow = sheet.getRow(rowCount); DataObject importEntity = DataObjectUtil.createDataObject(entityName); //判断某一行是否允许插入，当该行的所有列cell均为BLANK时不插入数据库 //以下构造导入的实体对象，并根据Excel单元格的内容填充实体属性值 for (int cellCount = 0; cellCount < fieldNames.length; cellCount++) { String propertyName = fieldNames[cellCount]; boolean isNeedParseCode = false; String dataBaseColName = propertyName; String dataBaseColType = ""; String dataBaseColProperty = ""; if (propertyName.contains("#")) { isNeedParseCode = true; String[] propertyNameArray = propertyName.split("#"); dataBaseColName = propertyNameArray[0]; dataBaseColType = propertyNameArray[1]; dataBaseColProperty = propertyNameArray[2]; } HSSFCell cell = sourceRow.getCell((short) cellCount); if (cell.getCellType() == HSSFCell.CELL_TYPE_BLANK) continue; String value = null; if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) { if (HSSFDateUtil.isCellDateFormatted(cell)) { SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); if (isNeedParseCode && "DATE".equals(dataBaseColType)) { dateFormat = new SimpleDateFormat(dataBaseColProperty); } value = dateFormat.format((cell.getDateCellValue())); } else { value = String.valueOf((long) cell.getNumericCellValue()); } } else if (cell.getCellType() == HSSFCell.CELL_TYPE_BOOLEAN) { value = cell.getBooleanCellValue() + ""; } else { value = cell.getRichStringCellValue().getString(); } TypeReference typeReference = (TypeReference) importEntity.getType().getProperty(dataBaseColName).getType();//判断实体类型 Type propertyType = typeReference.getActualType(); if (propertyType instanceof IntType || propertyType instanceof IntegerType) { //防止可能出现的Excel表格读取自动加.号 if (value.indexOf(".") != -1) value = value.substring(0, value.indexOf(".")); importEntity.set(fieldNames[cellCount], ChangeUtil.toInteger(value)); } else if (propertyType instanceof BooleanType) { importEntity.set(fieldNames[cellCount], ChangeUtil.toBoolean(Boolean.valueOf(value))); } else if (propertyType instanceof FloatType) { importEntity.set(fieldNames[cellCount], ChangeUtil.toFloat(value)); } else if (propertyType instanceof LongType) { if (value.indexOf(".") != -1) value = value.substring(0, value.indexOf(".")); importEntity.set(fieldNames[cellCount], ChangeUtil.toLong(value)); } else if (propertyType instanceof DecimalType) { importEntity.set(fieldNames[cellCount], ChangeUtil.toBigDecimal(value)); } else if (propertyType instanceof DateType) { if (isNeedParseCode && "DATE".equals(dataBaseColType)) { importEntity.set(dataBaseColName, ChangeUtil.changeToDBDate(value, dataBaseColProperty)); } } else if (propertyType instanceof DateTimeType) { importEntity.set(fieldNames[cellCount], ChangeUtil.toTimestamp(value)); } else { if (isNeedParseCode && "DICT".equals(dataBaseColType)) { DataObject[] results = BusinessDictUtil.getDictInfoByTypeAndSort(dataBaseColProperty, "sortno", false); value = parseCodeForMulti(results, value, true); importEntity.set(dataBaseColName, value); } else { importEntity.set(fieldNames[cellCount], value); } } } dataObjectList.add(importEntity); } } return dataObjectList.toArray(new DataObject[dataObjectList.size()]); } catch (Exception e) { throw e; } finally { fis.close(); }}/** * 将目标Excel文件的内容导入到数据表 * @param targetFile Excel文件路径 * @param entityName SDO数据实体全名 * @param headerConfig TODO * @return 返回1 导入成功 * * @throws Exception */public int importData(String targetFile, String entityName, int submitCount, String headerConfig) throws Exception { FileInputStream fis = new FileInputStream(targetFile); try { POIFSFileSystem fs = new POIFSFileSystem(fis); HSSFWorkbook wb = new HSSFWorkbook(fs); for (int sheetCount = 0; sheetCount < wb.getNumberOfSheets(); sheetCount++) {//支持多sheet页 HSSFSheet sheet = wb.getSheetAt(sheetCount); int rows = sheet.getPhysicalNumberOfRows(); if (submitCount == -1) {//如果为-1，表示一起导入 submitCount = rows; } this.fieldNames = headerConfig.split(";"); List<DataObject> dataObjectList = new ArrayList<DataObject>(); //第一行为#字段名 //第二行为字段标题，因此内容读取从startRow+2 for (int rowCount = 1; rowCount < rows; rowCount++) { HSSFRow sourceRow = sheet.getRow(rowCount); DataObject importEntity = DataObjectUtil.createDataObject(entityName); //判断某一行是否允许插入，当该行的所有列cell均为BLANK时不插入数据库 boolean allowInsert = false; //以下构造导入的实体对象，并根据Excel单元格的内容填充实体属性值 for (int cellCount = 0; cellCount < fieldNames.length; cellCount++) { String propertyName = fieldNames[cellCount]; boolean isNeedParseCode = false; String dataBaseColName = propertyName; String dataBaseColType = ""; String dataBaseColProperty = ""; if (propertyName.contains("#")) { isNeedParseCode = true; String[] propertyNameArray = propertyName.split("#"); dataBaseColName = propertyNameArray[0]; dataBaseColType = propertyNameArray[1]; dataBaseColProperty = propertyNameArray[2]; } HSSFCell cell = sourceRow.getCell((short) cellCount); if (cell.getCellType() == HSSFCell.CELL_TYPE_BLANK) continue; allowInsert = true; String value = null; if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) { if (HSSFDateUtil.isCellDateFormatted(cell)) { SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); if (isNeedParseCode && "DATE".equals(dataBaseColType)) { dateFormat = new SimpleDateFormat(dataBaseColProperty); } value = dateFormat.format((cell.getDateCellValue())); } else { value = String.valueOf((long) cell.getNumericCellValue()); } } else if (cell.getCellType() == HSSFCell.CELL_TYPE_BOOLEAN) { value = cell.getBooleanCellValue() + ""; } else { value = cell.getRichStringCellValue().getString(); } TypeReference typeReference = (TypeReference) importEntity.getType().getProperty(dataBaseColName).getType();//判断实体类型 Type propertyType = typeReference.getActualType(); if (propertyType instanceof IntType || propertyType instanceof IntegerType) { //防止可能出现的Excel表格读取自动加.号 if (value.indexOf(".") != -1) value = value.substring(0, value.indexOf(".")); importEntity.set(fieldNames[cellCount], ChangeUtil.toInteger(value)); } else if (propertyType instanceof BooleanType) { importEntity.set(fieldNames[cellCount], ChangeUtil.toBoolean(Boolean.valueOf(value))); } else if (propertyType instanceof FloatType) { importEntity.set(fieldNames[cellCount], ChangeUtil.toFloat(value)); } else if (propertyType instanceof LongType) { if (value.indexOf(".") != -1) value = value.substring(0, value.indexOf(".")); importEntity.set(fieldNames[cellCount], ChangeUtil.toLong(value)); } else if (propertyType instanceof DecimalType) { importEntity.set(fieldNames[cellCount], ChangeUtil.toBigDecimal(value)); } else if (propertyType instanceof DateType) { if (isNeedParseCode && "DATE".equals(dataBaseColType)) { importEntity.set(dataBaseColName, ChangeUtil.changeToDBDate(value, dataBaseColProperty)); } } else if (propertyType instanceof DateTimeType) { importEntity.set(fieldNames[cellCount], ChangeUtil.toTimestamp(value)); } else { if (isNeedParseCode && "DICT".equals(dataBaseColType)) { DataObject[] results = BusinessDictUtil.getDictInfoByTypeAndSort(dataBaseColProperty, "sortno", false); value = parseCode(results, value, true); importEntity.set(dataBaseColName, value); } else { importEntity.set(fieldNames[cellCount], value); } } } DatabaseExt.getPrimaryKey(importEntity); if (dataObjectList.size() < submitCount) { if (allowInsert) dataObjectList.add(importEntity); } else { if (dataObjectList.size() > 0) { DatabaseUtil.insertEntityBatch("default", dataObjectList.toArray(new DataObject[dataObjectList.size()])); dataObjectList.clear(); } } if (rowCount == rows - 1) { if (dataObjectList.size() > 0) DatabaseUtil.insertEntityBatch("default", dataObjectList.toArray(new DataObject[dataObjectList.size()])); } } } } catch (Exception e) { throw e; } finally { fis.close(); } return 1;}private String parseCode(DataObject[] results, String value, boolean reverse) { for (int i = 0; i < results.length; i++) { DataObject dataObject = results[i]; if (reverse) { if (value.equals((String) dataObject.get("dictName"))) { return (String) dataObject.get("dictID"); } } else { if (value.equals((String) dataObject.get("dictID"))) { return (String) dataObject.get("dictName"); } } } return null;}//多条数据的时候数据字典转码private String parseCodeForMulti(DataObject[] results, String value, boolean reverse) { String[] values = value.split(","); if(values.length>1){ for (int k = 0; k < values.length; k++) { values[k] = parseCode(results, values[k], reverse); } String valuesStr = StringUtils.join(values, ","); return valuesStr; }else{ return parseCode(results, value, reverse); }}/** * 如果模板文件是否存在 * @param filename 模板文件名 * @return 文件存在返回true,否则false * @throws IOException */protected boolean isExistTemplate(String templateFile) throws IOException { File file = new File(templateFile); return file.exists();}/** * 预初始化模板文件<BR> * 当用户指定的模板文件不存在时，将自动生成指定的模板文件，并第一行设置为要导出的字段列 * @param templateFile 模板文件名 * @param dataObject 数据实体对象 * @throws Exception */public void prepareInitializeTemplate(String templateFile, DataObject dataObject) throws Exception { HSSFWorkbook wb = new HSSFWorkbook(); FileOutputStream fileOut = new FileOutputStream(templateFile); HSSFSheet sheet = wb.createSheet("new sheet"); //设置模板的第一行为输出字段定义列 HSSFRow row = sheet.createRow((short) 0); Object[] properties = dataObject.getType().getDeclaredProperties().toArray(); for (int i = 0; i < properties.length; i++) { PropertyImpl property = (PropertyImpl) properties[i]; HSSFCell cell = row.createCell((short) i); HSSFRichTextString text = new HSSFRichTextString("#" + property.getName()); cell.setCellValue(text); } wb.write(fileOut); fileOut.close();}}
2、此类是Excel工具类,注释都很详细,直接把需要导出的数据集合传入
package com.framework.base.common.excel;
import java.io.File;
import java.text.SimpleDateFormat;
import java.util.Arrays;
import java.util.Date;
import java.util.UUID;
import com.eos.foundation.common.io.FileUtil;
import com.eos.foundation.eoscommon.ConfigurationUtil;
import com.eos.runtime.core.ApplicationContext;
import com.eos.system.annotation.Bizlet;
import com.eos.system.annotation.BizletParam;
import com.eos.system.annotation.ParamType;
import commonj.sdo.DataObject;
/**
*
* Created on 2017年2月15日
*
Description: [Excel文件操作工具类]
* @author:Me
* @version 1.0
*/
@Bizlet(“Excel工具操作类”)
public class ExcelUtil {
private ExcelUtil() {
//工具类不允许实例化
}
/** * 将Excel数据导入到数据库指定的表，默认每500条数据执行一次批处理导入 * * @param excelFile Excel文件路径 * @param entityFullName 导入的实体全名，例如：com.sol.policeApply.solRelaUserDataset.SolRelaUser * @param headerConfig excel头的对应关系配置，例如appNo;staffName;cardType#DICT#ID_TYPE;cardNo;birthDate#DATE#yyyy/MM/dd,其中DICT DATE为关键字，不可修改 * @return * @throws Exception */@Bizlet(value = "将Excel数据导入到数据库指定的表", params = { @BizletParam(index = 0, paramAlias = "excelFile", type = ParamType.CONSTANT), @BizletParam(index = 1, paramAlias = "entityFullName", type = ParamType.CONSTANT), @BizletParam(index = 2, paramAlias = "headerConfig", type = ParamType.CONSTANT) })public static int importExcel(String excelFile, String entityFullName, String headerConfig) throws Exception { ExcelTemplate template = new ExcelTemplate(); return template.importData(excelFile, entityFullName, 500, headerConfig);}/** * 将Excel数据转换为DataObject[] * * @param excelFile Excel文件路径 * @param entityFullName 导入的实体全名，例如：com.sol.policeApply.solRelaUserDataset.SolRelaUser * @param headerConfig excel头的对应关系配置，例如appNo;staffName;cardType#DICT#ID_TYPE;cardNo;birthDate#DATE#yyyy/MM/dd,其中DICT DATE为关键字，不可修改 * @return * @throws Exception */@Bizlet(value = "将Excel数据导入到数据库指定的表", params = { @BizletParam(index = 0, paramAlias = "excelFile", type = ParamType.CONSTANT), @BizletParam(index = 1, paramAlias = "entityFullName", type = ParamType.CONSTANT), @BizletParam(index = 2, paramAlias = "headerConfig", type = ParamType.CONSTANT) })public static DataObject[] parseExcel2DataObject(String excelFile, String entityFullName, String headerConfig) throws Exception { ExcelTemplate template = new ExcelTemplate(); return template.parseExcel2DataObject(excelFile, entityFullName, headerConfig);}/** * 将指定的对象数组exportObjects导出到指定模板的Excel文件 * * @param exportObjects 待导出的对象数组 * @param exportInfo 模板文件的其他附加信息(非结果集内容) * @param templateFilename 模板文件名(不带扩展名),对应到在user-config.xml配置路径下的模板文件 * @return 返回生成的Excel文件下载路径 * @throws Exception */@Bizlet(value = "将指定的对象数组导出到指定模板的Excel文件", params = { @BizletParam(index = 0, paramAlias = "exportObjects", type = ParamType.VARIABLE), @BizletParam(index = 1, paramAlias = "exportInfo", type = ParamType.VARIABLE), @BizletParam(index = 2, paramAlias = "templateFilename", type = ParamType.CONSTANT), @BizletParam(index = 3, paramAlias = "headerConfig", type = ParamType.CONSTANT) })public static String exportExcel(DataObject[] exportObjects, DataObject exportInfo, String templateFilename, String headerConfig) throws Exception { return exportExcel(exportObjects, exportInfo, templateFilename, false, false, headerConfig);}/** * 分页将对象数组导出到指定的模板Excel文件,注意：此时模板文件必需包含Excel表格的分页符 * @param exportObjects 待导出的对象数组 * @param exportInfo 模板文件的其他附加信息(非结果集内容) * @param templateFilename 模板文件名(不带扩展名),对应到在user-config.xml配置路径下的模板文件 * @return 返回生成的Excel文件下载路径 * @throws Exception */@Bizlet(value = "分页将对象数组导出到指定的模板Excel文件", params = { @BizletParam(index = 0, paramAlias = "exportObjects", type = ParamType.VARIABLE), @BizletParam(index = 1, paramAlias = "exportInfo", type = ParamType.VARIABLE), @BizletParam(index = 2, paramAlias = "templateFilename", type = ParamType.CONSTANT), @BizletParam(index = 3, paramAlias = "headerConfig", type = ParamType.CONSTANT) })public static String exportExcelWithPagnation(DataObject[] exportObjects, DataObject exportInfo, String templateFilename, String headerConfig) throws Exception { return exportExcel(exportObjects, exportInfo, templateFilename, true, false, headerConfig);}/** * 分工作表将对象数组导出到指定的模板Excel文件，默认情况下输出工作表最大行:20000 * @param exportObjects 待导出的对象数组 * @param exportInfo 模板文件的其他附加信息(非结果集内容) * @param templateFilename 模板文件名(不带扩展名),对应到在user-config.xml配置路径下的模板文件 * @return 返回生成的Excel文件下载路径 * @throws Exception */@Bizlet(value = "分工作表将对象数组导出到指定的模板Excel文件", params = { @BizletParam(index = 0, paramAlias = "exportObjects", type = ParamType.VARIABLE), @BizletParam(index = 1, paramAlias = "exportInfo", type = ParamType.VARIABLE), @BizletParam(index = 2, paramAlias = "templateFilename", type = ParamType.CONSTANT), @BizletParam(index = 3, paramAlias = "headerConfig", type = ParamType.CONSTANT) })public static String exportExcelWithSheet(DataObject[] exportObjects, DataObject exportInfo, String templateFilename, String headerConfig) throws Exception { return exportExcel(exportObjects, exportInfo, templateFilename, false, true, headerConfig);}/** * 导出Excel文件,根据指定路径下的模板生成输出的Excel文件 * * @param exportObjects 待导出的对象数组 * @param exportInfo 模板文件的其他附加信息(非结果集内容) * @param templateFilename 模板文件名(不带扩展名),对应到在user-config.xml配置路径下的模板文件 * @param autoPagination 是否分页 * @param autoSheet 是否分工作表 * @return 返回生成的Excel文件下载路径 * @throws Exception */private static String exportExcel(DataObject[] exportObjects, DataObject exportInfo, String templateFilename, boolean autoPagination, boolean autoSheet, String headerConfig) throws Exception { String filename = templateFilename; if (filename.indexOf(".xls") == -1) { filename += ".xls"; } //临时路径是服务器当前war下面的excel-config目录 String templateDir = ApplicationContext.getInstance().getWarRealPath() + ConfigurationUtil.getUserConfigSingleValue("sysbaseconfig", "excel", "excel_template_path"); String excelExportMaxnum = ConfigurationUtil.getUserConfigSingleValue("sysbaseconfig", "excel", "excel_export_maxnum"); if (!templateDir.endsWith(File.separator)) { templateDir += File.separator; } String tempDir = templateDir + "temp"+File.separator;//临时目录tempDir File file = new File(tempDir); if (!file.exists()) { //创建临时目录 FileUtil.mkDir(tempDir); //file.createNewFile(); } String templateFile = templateDir + filename;//模板目录 String outputFile = tempDir + generateOutputExcelFile(filename);//加工随机目录，防止覆盖 ExcelTemplate template = new ExcelTemplate(templateFile, outputFile); template.setAutoPagination(autoPagination); template.setAutoSheet(autoSheet); int excelExportMaxnumInt = 0; try { excelExportMaxnumInt = Integer.parseInt(excelExportMaxnum); } catch (Exception e) { e.printStackTrace(); } template.setMaxRow(excelExportMaxnumInt); template.generate(Arrays.asList(exportObjects), exportInfo, headerConfig); return outputFile;}/** * 生成EXCEL输出文件，默认带时间戳 * @param templateFilename 文件名 * @return */private static String generateOutputExcelFile(String templateFilename) { String filename = templateFilename; if (templateFilename.endsWith(".xls")) { filename = templateFilename.substring(0, templateFilename.length() - 4); } SimpleDateFormat format = new SimpleDateFormat("yyyyMMddHHmmss"); String datetimeString = format.format(new Date()); filename = filename + "_" + datetimeString + ".xls"; return filename;}}
下图放在web-inf下,保证得让程序找得到模板
把图中Excel模板做好,就是标题对应,下面的字母是对应数据的id,多条#的字段是代码项,也就是字典表
欢迎大家讨论,编辑器,user-config.xml的段落不让显示,我在评论区写上
阅读全文
0 0
- JAVA 导入导出Excel
- java excel导入导出
- java excel导入导出
- java导入/导出excel
- java导入导出excel
- java 导入导出excel
- java excel导入导出
- Java Excel 导入导出
- Java Excel 导入导出
- java导入/导出Excel
- Java导入、导出Excel
- JAVA excel 导入导出
- java导入导出excel
- java导入、导出excel
- 导入导出Excel-JAVA
- Java导入、导出Excel
- excel导入导出--Java
- Java导入导出Excel
- spring简介
- Qt UDP 广播简单示例
- 自定义--进度条
- 英语师徒会感想
- Linux下安装MySQL5.6
- Java导入导出Excel
- Where与Having的区别
- Controllable Abstractive Summarization
- 新手村 简单字符串 你的飞碟在这儿
- EventBus:Activity给Fragment传值
- Python向excel中写入数据
- 数学基础之概率与统计
- Java泛型与C++的区别
- 简单的网页制作
