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