问将.xls转换为.csv java

EN

 import java.io.*;

import java.util.Iterator;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;


class convert {

     static void convertToXls(File inputFile, File outputFile)
    {
      // For storing data into CSV files
       StringBuffer cellDData = new StringBuffer();
       String cellDDataString=null;
      try
        {
          FileOutputStream fos = new FileOutputStream(outputFile);

          // Get the workbook instance for XLS file
           HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(inputFile));
           // Get first sheet from the workbook
           HSSFSheet sheet = workbook.getSheetAt(0);
           Cell cell;
           Row row;

          // Iterate through each rows from first sheet
           Iterator<Row> rowIterator = sheet.iterator();
            while (rowIterator.hasNext())
            {
             row = rowIterator.next();

            // For each row, iterate through each columns
              System.out.println("row"+row);

               Iterator<Cell> cellIterator = row.cellIterator();
               while (cellIterator.hasNext())
               {
                  cell = cellIterator.next();
                  System.out.println("cell" +cell);
                  switch (cell.getCellType())
                 {

                        case Cell.CELL_TYPE_BOOLEAN:
                        cellDData.append(cell.getBooleanCellValue() + ",");
                        break;

                       case Cell.CELL_TYPE_NUMERIC:
                       cellDData.append(cell.getNumericCellValue() + ",");
                       break;

                   case Cell.CELL_TYPE_STRING:
                   cellDData.append(cell.getStringCellValue() + ",");
                   System.out.println(cell.getStringCellValue());
                   break;

                  case Cell.CELL_TYPE_BLANK:
                  cellDData.append("" + ",");
                   break;

                 default:
                cellDData.append(cell + ",");

                }
           }
       cellDData.append("\n");
        }
        //cellDData.append("\n");


//String out=cellDData.toString();
//System.out.println("res"+out);

//String o = out.substring(0, out.lastIndexOf(","));
//System.out.println("final"+o);
fos.write(cellDData.toString().getBytes());
//fos.write(cellDDataString.getBytes());
fos.close();

}
  catch (FileNotFoundException e)
  {
    System.err.println("Exception" + e.getMessage());
   } 
   catch (IOException e)
   {
        System.err.println("Exception" + e.getMessage());
   }
}



    public static void main(String[] args)
    {



    File inputFile = new File("Book1.xls");

    File outputFile = new File("output1.csv");

    convertToXls(inputFile, outputFile);

    }
    }