public static void main(String[] args) {
try {
// 读文件
FileInputStream inputStream = new FileInputStream("C:\\1.xlsx");
XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
Sheet sheet = workbook.getSheetAt(0);
// 写入Excel文件
FileOutputStream outputStream = new FileOutputStream("C:\\2.xlsx");
XSSFWorkbook outputWorkbook = new XSSFWorkbook();
Sheet outputSheet = outputWorkbook.createSheet();
int rowNum = 0;
for (Row row : sheet) {
Row outputRow = outputSheet.createRow(rowNum++);
int colNum = 0;
for (Cell cell : row) {
Cell outputCell = outputRow.createCell(colNum++);
outputCell.setCellValue(cell.getStringCellValue());
}
}
// 写文件
outputWorkbook.write(outputStream);
outputStream.close();
workbook.close();
} catch (Exception e) {
e.printStackTrace();
}
}
读写excel
最新推荐文章于 2024-08-07 22:17:18 发布