~chenjiahe/hx_common.git

			@@ -15,6 +15,8 @@
			import org.apache.poi.xssf.usermodel.XSSFWorkbook;
			import org.springframework.web.multipart.MultipartFile;

			import javax.imageio.ImageIO;
			import java.awt.image.BufferedImage;
			import java.io.*;
			import java.text.DateFormat;
			import java.text.SimpleDateFormat;
			@@ -498,6 +500,97 @@
			* @return
			* @throws Exception
			*/
			public static List<List<String>> getExcelDataCompatible(File file,boolean header) throws Exception {
			try {

			String fileName = file.getName();
			if (!fileName.matches("^.+\\.(?i)(xls)$") && !fileName.matches("^.+\\.(?i)(xlsx)$")) {
			throw new TipsException("上传文件格式不正确");
			}

			// 结果集
			List<List<String>> list = new ArrayList<>();
			Workbook book = create(new BufferedInputStream(new FileInputStream(file)));

			// 遍历该表格中所有的工作表，i表示工作表的数量 getNumberOfSheets表示工作表的总数
			for(int s=0;s<book.getNumberOfSheets();s++) {
			Sheet hssfsheet = book.getSheetAt(s);
			int col = 0;
			// 遍历该行所有的行,j表示行数 getPhysicalNumberOfRows行的总数去除标题
			for (int j = 0; j < hssfsheet.getPhysicalNumberOfRows(); j++) {
			Row hssfrow = hssfsheet.getRow(j);
			if(hssfrow!=null){
			if(j == 0) {
			col = hssfrow.getPhysicalNumberOfCells();
			if(!header) {
			//不包括表头
			continue;
			}
			}
			// 单行数据
			List<String> arrayString = new ArrayList<>();
			for (int i = 0; i < col; i++) {
			Cell cell = hssfrow.getCell(i);
			if (cell == null) {
			arrayString.add("");
			} else if (cell.getCellType() == 0) {
			// arrayString[i] = new Double(cell.getNumericCellValue()).toString();
			if (HSSFCell.CELL_TYPE_NUMERIC == cell.getCellType()) {
			short format = cell.getCellStyle().getDataFormat();
			if(format == 14 \|\| format == 31 \|\| format == 57 \|\| format == 58){
			//日期（中文时间格式的）
			Date d = cell.getDateCellValue();
			DateFormat formater = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
			// DateFormat formater = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			arrayString.add(formater.format(d));
			//arrayString[i] = formater.format(d);
			}else if (HSSFDateUtil.isCellDateFormatted(cell)) {
			Date d = cell.getDateCellValue();
			//DateFormat formater = new SimpleDateFormat("yyyy年MM月dd日 HH时mm分ss秒");
			DateFormat formater = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
			arrayString.add(formater.format(d));
			//arrayString[i] = formater.format(d);
			} else {
			if(HSSFCell.CELL_TYPE_STRING == cell.getCellType()){
			arrayString.add(cell.getStringCellValue());
			//arrayString[i] =cell.getStringCellValue();
			}else if(HSSFCell.CELL_TYPE_FORMULA==cell.getCellType()){
			arrayString.add(cell.getCellFormula());
			//arrayString[i] =cell.getCellFormula();
			}else if(HSSFCell.CELL_TYPE_NUMERIC== cell.getCellType()){
			HSSFDataFormatter dataFormatter = new HSSFDataFormatter();
			arrayString.add(dataFormatter.formatCellValue(cell));
			//arrayString[i] =dataFormatter.formatCellValue(cell);
			}
			}
			}
			} else if(cell.getCellType() == Cell.CELL_TYPE_BLANK){
			arrayString.add("");
			//arrayString[i] = "";
			} else { // 如果EXCEL表格中的数据类型为字符串型
			arrayString.add(cell.getStringCellValue().trim());
			//arrayString[i] = cell.getStringCellValue().trim();
			}
			}
			list.add(arrayString);
			}
			}
			}
			return list;
			} catch (Exception e) {
			e.printStackTrace();
			}
			return null;
			}




			/**读取excel文件，兼容2003和2007
			* 通过流读取Excel文件
			* @return
			* @throws Exception
			*/
			public static List<List<String>> getExcelDataCompatible(MultipartFile file,boolean header) throws Exception {
			try {

			@@ -614,4 +707,99 @@
			return "";
			}

			/**
			* p判断是否excel文件
			* @param file
			* @return
			*/
			public static boolean isExcel(MultipartFile file){
			String fileName = file.getOriginalFilename();
			if (!fileName.matches("^.+\\.(?i)(xls)$") && !fileName.matches("^.+\\.(?i)(xlsx)$")) {
			return false;
			}
			return true;
			}





			public static File createExcelByImg(String[] headList, String[] fieldList, List<Map<String, Object>> dataList, Integer height, Integer width) throws Exception {
			File file = File.createTempFile("temp", ".xls");
			FileOutputStream fileOut = null;
			BufferedImage bufferImg = null;

			try {
			ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();
			if (height == null) {
			height = 450;
			}

			if (width == null) {
			width = 1000;
			}

			HSSFWorkbook workbook = new HSSFWorkbook();
			HSSFCellStyle boderStyle = workbook.createCellStyle();
			boderStyle.setVerticalAlignment((short)1);
			boderStyle.setAlignment((short)2);
			HSSFSheet sheet = workbook.createSheet();
			HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
			HSSFRow row = sheet.createRow(0);

			HSSFCell anchor;
			for(int i = 0; i < headList.length; ++i) {
			row.setHeight(height.shortValue());
			sheet.setColumnWidth(i, width);
			anchor = row.createCell(i);
			anchor.setCellType(1);
			anchor.setCellValue(headList[i]);
			anchor.setCellStyle(boderStyle);
			}

			HSSFRow row_value = null;
			anchor = null;
			HSSFCell cell = null;
			if (dataList != null) {
			for(int n = 0; n < dataList.size(); ++n) {
			row_value = sheet.createRow(n + 1);
			row_value.setHeight(height.shortValue());
			Map<String, Object> dataMap = (Map)dataList.get(n);

			for(int i = 0; i < fieldList.length; ++i) {
			sheet.setColumnWidth(i, width);
			cell = row_value.createCell(i);
			cell.setCellType(1);
			Object value = dataMap.get(fieldList[i]);
			if (value != null && "class java.io.File".equals(value.getClass().toString())) {
			File file2 = (File)value;
			if (file2 == null) {
			cell.setCellValue("");
			} else {
			bufferImg = ImageIO.read(file2);
			ImageIO.write(bufferImg, "jpg", byteArrayOut);
			HSSFClientAnchor anchor1 = new HSSFClientAnchor(0, 0, 1023, 255, (short)i, n + 1, (short)i, n + 1);
			anchor1.setAnchorType(0);
			patriarch.createPicture(anchor1, workbook.addPicture(byteArrayOut.toByteArray(), 5));
			}
			} else {
			cell.setCellValue(objToString(dataMap.get(fieldList[i])));
			cell.setCellStyle(boderStyle);
			}
			}
			}
			}

			FileOutputStream fOut = new FileOutputStream(file);
			workbook.write(fOut);
			fOut.flush();
			fOut.close();
			} catch (Exception var25) {
			var25.printStackTrace();
			} finally {
			file.deleteOnExit();
			}

			return file;
			}
			}