java txt导入_用java将excel数据导入txt

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

}

}

}