工具类
package com.microstone.customer.util;
import com.microstone.customer.domain.dto.ImportCustomerDTO;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.web.multipart.MultipartFile;
import javax.servlet.http.HttpServletRequest;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
public class ExcelUtil {
public static HSSFWorkbook getHSSFWorkbook(String sheetName, String[] title, String[][] values, HSSFWorkbook wb) {
if (wb == null) {
wb = new HSSFWorkbook();
}
HSSFSheet sheet = wb.createSheet(sheetName);
sheet.setColumnWidth((short) 0, (short) 2600);
HSSFRow row = sheet.createRow(0);
HSSFCellStyle style = wb.createCellStyle();
style.setAlignment(HorizontalAlignment.forInt(2));
HSSFCell cell = null;
for (int i = 0; i < title.length; i++) {
cell = row.createCell(i);
cell.setCellValue(title[i]);
cell.setCellStyle(style);
}
if(values != null){
for (int i = 0; i < values.length; i++) {
row = sheet.createRow(i + 1);
for (int j = 0; j < values[i].length; j++) {
row.createCell(j).setCellValue(values[i][j]);
}
}
}
return wb;
}
public static HSSFWorkbook getHSSFWorkbookSheet(String sheetName,int sheetNum, String[] title, String[][] values, HSSFWorkbook wb) {
if (wb == null) {
wb = new HSSFWorkbook();
}
HSSFCellStyle headStyle = createCellStyle(wb, (short) 18);
HSSFSheet sheet = wb.createSh