java读取excel文件

记录下Java读取excel文件：

public class Test {
    public static void main(String[] args) throws IOException {
        File file = new File("test.xlsx");

        FileWriter outRawSql = new FileWriter("/raw.sql");
        FileWriter outNewSql = new FileWriter("/new.sql");

        Workbook workbook = new XSSFWorkbook(new FileInputStream(file));
        Sheet sheet = workbook.getSheet("导出结果");  //sheet名称
        Iterator<Row> itr = sheet.rowIterator();
        while (itr.hasNext()) {
            Row row = itr.next();
            if (row.getRowNum() == 0) {
                System.out.println(row);
                continue;
            }

            Long id = Long.valueOf(row.getCell(0).getStringCellValue());
            String name = row.getCell(2).getStringCellValue();
      
            String newSql = generateSql(appId, fileId, fileName, addTransformerStep(content), modifyExtend(extend));
            outNewSql.write(newSql + ";\n");
        }

        outNewSql.close();
        outRawSql.close();
    }