用Java Excel API将excel转为csv文档

如何使用Java Excel API来实现将excel档案自动转换为csv档案格式,首先你需要有JExcel Library，若没有JExcel Library可以到http://sourceforge.net/projects/jexcelapi/files/网站上下载.

代码范例：

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.util.Locale;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.WorkbookSettings;

public class CSVConverter {

  /**
   * @param args
   */
  public static void main(String[] args) {
    try {
      OutputStream os = new FileOutputStream(new File("C:\\input.csv"));     
      OutputStreamWriter osw = new OutputStreamWriter(os, "UTF8");
      BufferedWriter bw = new BufferedWriter(osw);

      // 载入Excel文件     
      WorkbookSettings ws = new WorkbookSettings();
      ws.setLocale(new Locale("en", "EN"));
      Workbook wk = Workbook.getWorkbook(new File("C:\\input.xls"), ws);

      // 从工作簿(workbook)取得每页(sheets)
      for (int sheet = 0; sheet < wk.getNumberOfSheets(); sheet++) {
        Sheet s = wk.getSheet(sheet);

        bw.write(s.getName());
        bw.newLine();

        Cell[] row = null;

        // 从每页(sheet)取得每个区块(Cell)
        for (int i = 0; i < s.getRows(); i++) {
          row = s.getRow(i);

          if (row.length > 0) {
            bw.write(row[0].getContents());
            for (int j = 1; j < row.length; j++) {
              bw.write(',');
              bw.write(row[j].getContents());
            }
          }
          bw.newLine();
        }
      }
      bw.flush();
      bw.close();
   
    } catch (Exception e) {
      System.err.println(e.toString());
      e.printStackTrace();     
    }
  }

}

这个代码效果还是很好的，大家有可以探讨。