读取excel写入txt文件

最新推荐文章于 2024-03-26 14:41:22 发布

叮叮丶

最新推荐文章于 2024-03-26 14:41:22 发布

阅读量894

点赞数 1

分类专栏： Java

本文链接：https://blog.csdn.net/dwhdome/article/details/94735505

版权

Java 专栏收录该内容

45 篇文章 3 订阅

订阅专栏

public static void main(String[] args) throws Exception {
        InputStream in = new FileInputStream("C:/Users/Desktop/参考资料/minganciku/敏感词库表统计.xlsx");
        Workbook wb0 = new XSSFWorkbook(in);
        Sheet sheet = wb0.getSheetAt(0);
        StringBuilder stringBuilder = new StringBuilder();
        int i = 0;
        try {
            for (Row row : sheet) {
                i += 1;
                if (null != row && row.getCell(3) != null) {
                    row.getCell(3).setCellType(Cell.CELL_TYPE_STRING);
                    stringBuilder.append(row.getCell(3).getStringCellValue());
                    stringBuilder.append("\r\n");//换行字符
                }
            }

        }catch (Exception e){
            e.printStackTrace();
        }
        FileWriter fwriter = null;
        try {
            // true表示不覆盖原来的内容，而是加到文件的后面。若要覆盖原来的内容，直接省略这个参数就好
            fwriter = new FileWriter("C:/Users/Desktop/参考资料/minganciku/mingan.txt", true);
            fwriter.write(stringBuilder.toString());
        } catch (IOException ex) {
            ex.printStackTrace();
        } finally {
            try {
                fwriter.flush();
                fwriter.close();
            } catch (IOException ex) {
                ex.printStackTrace();
            }
        }
    }