用java将excel数据导入txt

最新推荐文章于 2021-03-13 21:30:01 发布

转载最新推荐文章于 2021-03-13 21:30:01 发布 · 332 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/u/3744350/blog/1604269

文章标签：

#java #开发工具 #python

2019独角兽企业重金招聘Python工程师标准>>>

package com.alibaba.test;

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class WriteTxt {

   public static void main(String[] args) {
       // TODO Auto-generated method stub
       String filepath = "e:\\demo.xls";

       try {
           Workbook workbook = Workbook.getWorkbook(new File(filepath));
           Sheet sheet = workbook.getSheet(0);
           File fileSuccess = new File("success.txt");
           File fileError = new File("error.txt");
           FileWriter fwSuccess = new FileWriter(fileSuccess);
           BufferedWriter bwSuccess = new BufferedWriter(fwSuccess);

           FileWriter fwError = new FileWriter(fileError);
           BufferedWriter bwError = new BufferedWriter(fwError);
           // j为行数，getCell("列号","行号")
           int j = sheet.getRows();
           int y = sheet.getColumns();
           Cell c = null;
           for (int i = 0; i < j; i++) {
               String s = "";
               for (int x = 0; x < y; x++) {
                   c = sheet.getCell(x, i);
                   s += c.getContents() + " ";
               }

               if (s.indexOf("&") != -1 || s.indexOf("@") != -1) {
                   bwSuccess.write(s);
                   bwSuccess.write(" ");
                   bwSuccess.flush();
                   // 读取一行后换行
                   bwSuccess.newLine();
                   // 刷新
                   bwSuccess.flush();
               } else {
                   bwError.write(s);
                   bwError.write(" ");
                   bwError.flush();
                   bwError.newLine();
                   bwError.flush();
               }
           }
           System.out.println("写入结束");
       } catch (BiffException e) {
           e.printStackTrace();
       } catch (IOException e) {
           e.printStackTrace();
       }
   }
}