Test POI

来源：互联网发布：摄像慢镜头软件下载编辑：程序博客网时间：2024/06/15 23:25

package com.corp.custom;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Iterator;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

/**
* @author a464597
*
*/
public class TestPOI {

    /**
     * @param args
     * @throws IOException
     * @throws FileNotFoundException
     */
    public static void main(String[] args) throws FileNotFoundException, IOException {
// TODO Auto-generated method stub
// POIFSFileSystem fs= new POIFSFileSystem(new FileInputStream("c:/test.xls"));
//        HSSFWorkbook wb = new HSSFWorkbook(fs);
//        HSSFSheet sheet = wb.getSheetAt(0);
//        int i = 0;
//        for (Iterator rit = sheet.rowIterator(); rit.hasNext(); ) {
//  HSSFRow row = (HSSFRow)rit.next();
//  i++;
//         if(i == 1)
//             continue;
//  for (Iterator cit = row.cellIterator(); cit.hasNext(); ) {
//   HSSFCell cell = (HSSFCell)cit.next();
//   System.out.println(cell.toString());
//  }
// }

POIFSFileSystem fs= new POIFSFileSystem(new FileInputStream("c:/test.xls"));
        HSSFWorkbook wb = new HSSFWorkbook(fs);
        HSSFSheet sheet = wb.getSheetAt(0);
        int i = 0;
        for (Iterator rit = sheet.rowIterator(); rit.hasNext(); ) {
  HSSFRow row = (HSSFRow)rit.next();
  i++;
         if(i == 1)
             continue;

    String s = "<?xml version=/"1.0/" encoding=/"UTF-8/"?>" +
      "<fund><fundid>#@</fundid><name>#@</name><fundcategory>#@</fundcategory><fundtype>#@</fundtype>" +
      "<terms>#@</terms><symbolcode>#@</symbolcode><CreationDate>#@</CreationDate>" +
      "<lastupdatedDate>#@</lastupdatedDate><ExpirationDate>#@</ExpirationDate>" +
      "<description>#@</description></fund>";


         for(int j = 0;j < 10;j++){
             HSSFCell cell = row.getCell(j);
             s = s.replaceFirst("#@", cell == null? "" : cell.toString());

         }
         System.out.println(s);
        }

    }

}