用JAVA将EXCEL文件解析存入ORACLE数据库
 用用JAVA实现将EXCEL文件解析存入ORACLE数据库 
 大家有好的办法吗?请高手指点一下,谢谢!
------解决方案--------------------poi读取excel文件,执行业务后存入oracle
------解决方案--------------------标记下 有空 解决这个 现在忙
------解决方案--------------------2楼正解
------解决方案--------------------用jxl也行
------解决方案--------------------用jxl的优势可能要比poi好一点,我建议是使用jxl
------解决方案--------------------jxl
------解决方案--------------------楼主可以试一下jxls 是一个支持excel模板填充的开源软件
------解决方案--------------------有一个将excel文件转换成文本的例子,参考
import jxl.*;
import java.io.*;
import java.util.*;
public class  ExcelToTxt  
{
	private String       filePath="";       ///文件路径
   private InputStream  inputStream;       ///输入流  
   private Workbook     workbook;          ///excel文件
   private Sheet        sheet;             ///sheet
   private Cell         cell;              ///元素
   private String       znkh;              ///智能卡号
   List    list   =    new ArrayList();
   private int         rowCount;           ///行总数
   private int         colCount=30;         ///列总数
   private int         colIndex;           ///列
   static public String vStr  = "";        ///信息
	public ExcelToTxt()
	{
   }
	public ExcelToTxt(File file) {       
        try{
            inputStream = new FileInputStream(file);
        }catch(Exception e){       	 
System.err.println("*****************ImportZnk manager is error!******"+e.getMessage());
        }
   }
   public void setInputStream(File file){
   	try{
           inputStream = new FileInputStream(file);
       }catch(Exception e){
      	 System.err.println("*************ImportZnk setInputStream is error!******"+e.getMessage());
       }
   }
   private void getworkBook(){
        try{
            workbook = Workbook.getWorkbook(inputStream);  
            inputStream.close();
        }catch(Exception e){
           e.printStackTrace();
        }
   }
   private void  getsheet(){
        if (workbook == null)
              getworkBook();
        sheet = workbook.getSheet(0);
   }
   public int getrowCount(){
        if (sheet == null)
             {getsheet();}
        rowCount = sheet.getRows();       
        return rowCount;
   }
   public int getcolCount() {
        return sheet.getColumns();
   }
/*
   public List getZnkh(int rowIndex){
       if (sheet == null)
          {getsheet();}
       for(int i=0;i<colCount;i++){
          cell    = sheet.getCell(i,rowIndex);
          znkh    =  cell.getContents();
          list.add(i,znkh);
       }         
     return list;  
  }
*/
   public String getCell(int rowIndex,int colIndex) {
   	cell    = sheet.getCell(colIndex,rowIndex);
   	return cell.getContents();
   }
   public void workbookClose(){
   	if(workbook != null){
   		workbook.close();
   	}
   }
   public static void main(String[] args) throws Exception
	{
		String outFilePath = "d:\\cxt\\outr.txt";  //输出文件
		File outFile = new File(outFilePath);
       FileWriter o = new FileWriter(outFilePath);
       String filePath="d:\\cxt\\memberr20060904.xls" ;