Java读取excel文件写入txt

来源：互联网发布：jquery向数组添加元素编辑：程序博客网时间：2024/05/22 09:05
package com.zhaoxueer.program;import java.io.File;import java.io.FileNotFoundException;import java.io.FileWriter;import java.io.IOException;import java.io.PrintWriter;import java.util.ArrayList;import java.util.List;import jxl.Sheet;import jxl.Workbook;import jxl.read.biff.BiffException;public class ParseInTxt {private File result = null;private FileWriter writer;private PrintWriter pw;boolean bool;// path动态指定路径public void createTxT(String path) { // 创建新的txt数据文件bool = false;result = new File(path);try {result.createNewFile();// 在本地创建一个txt文件bool = true;} catch (IOException e) {bool = false;System.err.println(e);}if (bool) {try {writer = new FileWriter(path);} catch (IOException e) {System.err.println(e);}try {pw = new PrintWriter(path);} catch (FileNotFoundException e) {System.err.println(e);}}}public void aLine(List<String> in) { // 写入一个List集for (int i = 0; i < in.size(); i++) {pw.println(in.get(i));}}/* * public void aLint(String in){// 写入一行 pw.println(in); } */public void finish() { // 关闭输入流，将文字从缓存写入文件try {pw.flush();writer.close();} catch (IOException iox) {System.err.println(iox);}}public static List<String> readExcel(String pathname) {List<String> list = new ArrayList<String>();try {// 打开文件 6Workbook book = Workbook.getWorkbook(new File(pathname));// 取得第一个sheetSheet sheet = book.getSheet(0);// 取得行数int rows = sheet.getRows();for (int i = 1; i < rows; i++) {// getCell(列，行)String user = sheet.getCell(0, i).getContents();list.add(user);}// 关闭文件book.close();} catch (BiffException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}return list;}public static void main(String[] args) {ParseInTxt c = new ParseInTxt();c.createTxT("D:\\bbb.txt");// 需要生成的文件路径List<String> in = readExcel("D:\\aaa.xls");c.aLine(in);// list类型c.finish();}}
0 0