scala : poi XLSX2CSV

来源：互联网发布：淘宝修改密码网址编辑：程序博客网时间：2024/05/31 19:25

下载 poi-bin-3.10-FINAL-20140208.zip ，解压后

copy *.jar \scala\lib\

copy \poi-3.10-FINAL\ooxml-lib\*.jar \scala\lib\

示例代码: xlsx2csv.scala

//package test;import java.io.Fileimport java.io.PrintStreamimport org.apache.poi.openxml4j.opc._import org.apache.poi.xssf.eventusermodel.XLSX2CSVif (args.length < 1) {    System.err.println("Use:");    System.err.println("  XLSX2CSV <xlsx file> [min columns]");    System.exit(4)}val file1 = args(0)val xlsxFile = new File(file1);if (!xlsxFile.exists()) {    System.err.println("Not found or not a file: " + xlsxFile.getPath());    System.exit(4)}val file2 = file1.replace(".xlsx",".csv")val csvFile = new File(file2);if ( csvFile.exists()) {    System.err.println(file2+": csvFile is exists. " );    System.exit(4)}var minColumns = -1;if (args.length >= 2)    minColumns = Integer.parseInt(args(1));// System.out redirectval out = new PrintStream(file2);System.setOut(out);// The package open is instantaneous, as it should be.val p = OPCPackage.open(xlsxFile.getPath(), PackageAccess.READ);val xlsx2csv = new XLSX2CSV(p, out, minColumns);xlsx2csv.process();out.close();

运行 scala xlsx2csv.scala test.xlsx

0 0