品牌型网站的作用,图书销售网站网页设计模板,做网投网站,网站维护 html最近有个场景#xff0c;在ftp服务器上#xff0c;读取csv文件并入库#xff0c;但是客户提供的一部分文件却是xls文件#xff0c;就得搞个将excel转为csv文件的方法#xff0c;话不多说直接开干。
方法 public static void convertExcelToCSV(String excelFilePath, Str…最近有个场景在ftp服务器上读取csv文件并入库但是客户提供的一部分文件却是xls文件就得搞个将excel转为csv文件的方法话不多说直接开干。
方法 public static void convertExcelToCSV(String excelFilePath, String csvFilePath) throws IOException {FileInputStream inputStream new FileInputStream(excelFilePath);Workbook workbook getWorkbook(inputStream, excelFilePath);inputStream.close();FileWriter writer new FileWriter(csvFilePath);for (int sheetIndex 0; sheetIndex workbook.getNumberOfSheets(); sheetIndex) {Sheet sheet workbook.getSheetAt(sheetIndex);IteratorRow rowIterator sheet.iterator();while (rowIterator.hasNext()) {Row row rowIterator.next();IteratorCell cellIterator row.cellIterator();StringBuilder stringBuilder new StringBuilder();while (cellIterator.hasNext()) {Cell cell cellIterator.next();stringBuilder.append(getCellValue(cell));if (cellIterator.hasNext()) {stringBuilder.append(,);}}writer.write(stringBuilder.toString() \n);}if (sheetIndex workbook.getNumberOfSheets() - 1) {writer.write(\n); // 在不同工作表之间添加一个空行}}writer.flush();writer.close();workbook.close();}private static Workbook getWorkbook(FileInputStream inputStream, String excelFilePath) throws IOException {Workbook workbook null;if (excelFilePath.endsWith(xlsx)) {workbook new XSSFWorkbook(inputStream);} else if (excelFilePath.endsWith(xls)) {workbook new HSSFWorkbook(inputStream);} else {throw new IllegalArgumentException(The specified file is not an Excel file);}return workbook;}private static String getCellValue(Cell cell) {//DataFormatter formatter new DataFormatter();String formatPattern yyyy-MM-dd HH:mm:ss; // 自定义日期时间格式//FormulaEvaluator evaluator cell.getSheet().getWorkbook().getCreationHelper().createFormulaEvaluator();switch (cell.getCellType()) {case STRING:return cell.getRichStringCellValue().getString();case NUMERIC:if (DateUtil.isCellDateFormatted(cell)) {Date date cell.getDateCellValue();DateFormat dateFormat new SimpleDateFormat(formatPattern);return dateFormat.format(date);} else {return Double.toString(cell.getNumericCellValue());}case BOOLEAN:return Boolean.toString(cell.getBooleanCellValue());case FORMULA:return cell.getCellFormula();default:return ;}}
测试 public static void main(String[] args) {String excelFilePath D:\\我是excel文件.xlsx;String csvFilePath D:\\我是csv文件.csv;try {convertExcelToCSV(excelFilePath, csvFilePath);System.out.println(Excel file converted to CSV successfully!);} catch (IOException e) {e.printStackTrace();}}以上为整合保留时间格式需求的全部代码亲测非常好用
