using NExcel;

//傳入文件流

Workbook wb = Workbook.getWorkbook(fileStream);

//創(chuàng)建工作組    

Sheet sheet = wb.Sheets[0];

//獲取工作組的個(gè)數(shù)

int rowsCount = sheet.Rows;

//遍歷工作組

for (int row = 2; row < rowsCount; row++)

{

         string sheet.getCell(0, row).Contents;

decimal TotalPrice = Convert.ToDecimal(sheet.getCell(1, row).Value);

     }

現(xiàn)在遍歷的方式用的很少了，主要都用OLEDB方式，把excel當(dāng)作是數(shù)據(jù)源，類似于數(shù)據(jù)庫(kù)操作：

private DataSet importExcelToDataSet(string FilePath)
{
   string strConn;

   //OLEDB初始化
   strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + FilePath + ";Extended Properties=Excel 8.0;";

   //建立OLEDB鏈接
   OleDbConnection conn = new OleDbConnection(strConn);

    //讀取對(duì)應(yīng)工作組的數(shù)據(jù)鏈接
   OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]",strConn);

   //數(shù)據(jù)付給結(jié)果集
   DataSet myDataSet = new DataSet();
   try
   {
    myCommand.Fill(myDataSet);
   }
   catch(Exception ex)
   {
    throw new InvalidFormatException(ex.Message);
   }
   return myDataSet;
}