java 写excel备份.docx

本程序实现从txt文件读取数据然后按照一定格式写入到excel文件中程序运行需要导入包一、 在eclipse中右键点击工程在下拉菜单中选择 bulid Path ranhou xuanze Add Exernal二、 将添加进来三、 在E:writetxt目录下存在如图所示四、 生成的excel文件将被保存到import java.io.BufferedReader;import java.io.File;import java.io.FileInputStream;import java.io.FileReader;import java.io.IOException;import java.io.InputStreamReader;import java.util.ArrayList;import java.util.Vector;import jxl.Workbook;import jxl.write.Label;import jxl.write.WritableCellFormat;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;public class FileList private static ArrayList filelist = new ArrayList();public static void main(String args) FileList fileList = new FileList();fileList.refreshFileList(E:/out/); / 文件路径public Vector split(String s, char separator) / 按照separator/ 分割s后存放到subVector vec = new Vector();/ Stringsub=new String100;int i, len = 0, n = s.length();String str = ;for (i = 0; i n; i+) / System.out.println(s.charAt(i);if (s.charAt(i) != separator)str += s.charAt(i);else vec.add(str);/ System.out.println(vec.elementAt(j+);/ veclen+=str;str = ;if (i = n - 1)vec.add(str);/ sublen+=str;return vec;public void readTxtFile(String txt_Path, String excel_Path) try String encoding = GBK;File file = new File(txt_Path);if (file.isFile() & file.exists() / 判断文件是否存在try/ 打开文件WritableWorkbook book = Workbook.createWorkbook(new File(excel_Path);/ 生成名为“第一页的工作表，参数0表示这是第一页WritableSheet sheet = book.createSheet(第一页, 0); WritableCellFormat wrappedText = new WritableCellFormat(WritableWorkbook.ARIAL_10_PT); wrappedText.setWrap(true);/ 可换行的label样式for(int set_i=1;set_i10;set_i+)sheet.setRowView(set_i, 1000);sheet.setColumnView(set_i,15);/sheet.set/sheet.setDefaultRowHeightInPoints(100);/设置默认高 / 在Label对象的构造子中指名单元格位置是第一列第一行(0,0)/ 以及单元格内容为testLabel label = new Label10;for (int i = 1; i = 6; i+) labeli = new Label(0, i, 第 + i + 大节);sheet.addCell(labeli);for (int i = 1; i = 7; i+) if (i = 7) labeli = new Label(i, 0, 星期日);sheet.addCell(labeli); else labeli = new Label(i, 0, 星期 + i);sheet.addCell(labeli);InputStreamReader read = new InputStreamReader(new FileInputStream(file), encoding);/ 考虑到编码格式BufferedReader bufferedReader = new BufferedReader(read);String lineTxt = null;int cow = 1, col = 1;while (lineTxt = bufferedReader.readLine() != null) String Txt=;for(int num=1;numsplit(lineTxt, ).size();num+)Txt+=split(lineTxt, ).elementAt(num);Label line = new Label(cow, col,Txt,wrappedText );sheet.addCell(line);col = col + 1;if (col % 7 = 0) col = 1;cow = cow + 1;read.close();book.write();book.close();catch(Exception e)System.out.println(e);/* * 生成一个保存数字的单元格 必须使用Number的完整包路径，否则有语法歧义 单元格位置是第二列，第一行，值为789.123 */ jxl.write.Number number = new jxl.write.Number(1, 0,/ 789.123);/ sheet.addCell(number);/ 写入数据并关闭文件 else System.out.println(找不到指定的文件); catch (Exception e) System.out.println(读取文件内容出错);e.printStackTrace();public void refreshFileList(String strPath) / 读取目录下所有txt文件String write_excel = ClassCourseTable,ClassroomCourseTable, CourseTable, TeacherCourseTable ;/ System.out.println(write_excel.length);for (int i = 0; i write_excel.length; i+) String Path = strPath + txt/ + write_exceli;/ txt文件所在目录String Path_excel = strPath + excel/ + write_exceli;/ excel文件所在目录/ System.out.println(Path);File dir = new File(Path);File files = dir.listFiles();if (files = null)/ 若为空则返回return;for (int k = 0; k files.length; k+) / 循环读取文件if (split(filesk.getName(), .).elementAt(1).equals(txt)/ 判断是否是txt文件String txt_Path = Path + / + filesk.getName();/ 获取文件名String excel_Path = Path_ex