Test POI

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);
        }
 
    }

}