java_execel.txt

java操作 excel文件并生成文本文件的源码

package mis;

import javax.swing.*;
import jxl.*;
import jxl.write.*;
import java.io.*;
import java.io.FileInputStream;
import java.io.File;
import java.util.*;

import com.borland.dx.sql.dataset.*;

/*Excel文件转换*/
public class ExcelToText {
   //String file_text = "c:\\cs3.txt";
   String file_text = "cs3.txt";
  String file_excel="";
  FileWriter writer = null;
  String RowStr = "";
  String CellStr="";
  Cell CurrentCell=null;
  public ExcelToText(String file_name) {
       file_excel=file_name;
  }

  public void CreateTextFile() throws Exception {
    writer = new FileWriter(file_text, false);//生成文本文件写句柄
    InputStream is=null;
    try{
       is= new FileInputStream(file_excel); //excel文件流
    }catch(Exception ex){
        System.out.println(ex);
    }

    jxl.Workbook myworkbook = Workbook.getWorkbook(is);
    Sheet mysheet = myworkbook.getSheet(0);
    int mysheetColumn = mysheet.getColumns(); //总列数
    int mysheetRows = mysheet.getRows(); //总行数
    System.out.println("总列数:"+mysheetColumn);
    System.out.println("总行数:"+mysheetRows);

    Cell[] cell_column = mysheet.getColumn(0); //第一列的所有值，返回单元格对象数组
    Cell[] cell_row = mysheet.getRow(0); //第一行的所有值，返回单元格对象数组
    for (int row = 0; row < mysheetRows; row++) {
       RowStr="";
       for (int column = 0; column < mysheetColumn; column++) {
          CurrentCell = mysheet.getCell(column, row);
          CellStr=CurrentCell.getContents();

          if(column==1){
             if(CellStr.length()==1){
               CellStr="000"+CellStr;
             }else
             if(CellStr.length()==2){
               CellStr="00"+CellStr;
             }else
             if(CellStr.length()==3){
               CellStr="0"+CellStr;
             }
          }

          CellStr=CellStr+"|";
          RowStr=RowStr+CellStr;
       }
       System.out.println("行数据:"+RowStr);
       writer.write(RowStr+"\n");
    }
    /*
        Cell c2 = mysheet.getCell(2, 0); //第三列，第一行
        String stringc2 = c2.getContents();
        System.out.println(stringc2);
     */
    writer.close();
    myworkbook.close();
  }
  public String GetFile() {
    return file_text;
  }
  public static void main(String args[]){
     ExcelToText et=new ExcelToText("cs3.xls");
     try{
       et.CreateTextFile();
       System.out.println("成功生成文本文件！");
     }
     catch(Exception e)
     {
     System.out.println("创建文本文件失败！");
     }
  }//end of main

}