java excel 操作_JAVA-Excel文件操作

importjava.io.File;importjava.io.FileInputStream;importjava.io.FileOutputStream;importjava.io.IOException;importjava.text.SimpleDateFormat;importjava.util.HashMap;importjava.util.Map;importjavax.swing.JOptionPane;importorg.apache.poi.EncryptedDocumentException;importorg.apache.poi.openxml4j.exceptions.InvalidFormatException;importorg.apache.poi.ss.usermodel.Row;importorg.apache.poi.ss.usermodel.Sheet;importorg.apache.poi.ss.usermodel.Workbook;importorg.apache.poi.ss.usermodel.WorkbookFactory;importorg.apache.poi.xssf.usermodel.XSSFWorkbook;public classExcelLog {public ExcelLog(intindex) {

createNewBook();

}//新建工作表

private voidcreateNewBook() {try{

String path= "D:\\test.xlsx";

File f= newFile(path);

File dir=f.getParentFile();if (!dir.exists()) {//如果文件路径不存在，则创建路径

dir.mkdirs();

}if (!f.exists()) {//如果文件不存在，则新建文件

Workbook wb = new XSSFWorkbook(); //.xlsx

Sheet sheet = wb.createSheet("Test Log"); //新建Sheet

Row row = sheet.createRow(0); //写一行数据

String[] header = {"COL1", "COL2", "COL3", "COL4", "COL5"};for (int i = 0; i < header.length; i++) {

row.createCell(i).setCellValue(header[i]);

}//写入文件

try (FileOutputStream fileOut = newFileOutputStream(path)) {

wb.write(fileOut);

wb.close();

}

}

}catch(IOException ex) {

JOptionPane.showMessageDialog(null, "无法写入Excel文件:" +ex.getMessage());

System.exit(-1);

}

}//Sheet表的行数

private intgetRowCount() {try (FileInputStream fileInput = newFileInputStream(path)) {

Workbook wb=WorkbookFactory.create(fileInput);

Sheet sheet= wb.getSheetAt(0);returnsheet.getPhysicalNumberOfRows();

}catch (IOException | InvalidFormatException |EncryptedDocumentException ex) {

JOptionPane.showMessageDialog(null, "无法读取Excel文件：" +ex.getMessage());

System.exit(-1);return 0;

}

}//写一行数据

private voidwriteLine(String[] items) {try{

Workbook wb= WorkbookFactory.create(newFileInputStream(path));

Sheet sheet= wb.getSheetAt(0);int rowIndex = this.getRowCount();

Row row=sheet.createRow(rowIndex);for (int i = 0; i < items.length; i++) {

row.createCell(i).setCellValue(items[i]);

}//写入文件

try(FileOutputStream fileOut = newFileOutputStream(path);){

wb.write(fileOut);

}

wb.close();

}catch (IOException | InvalidFormatException |EncryptedDocumentException ex) {

ex.printStackTrace();

JOptionPane.showMessageDialog(null, "无法写入Excel文件：" +ex.getMessage());

System.exit(-1);

}

}

}