读写excel

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();
        }

    }