Re: Reading an Excel file in C#

Try this:

using System.Data.OleDb;
using System.Data;

namespace ee
{
  public class ExcelDataReader
  {
    public readonly DataSet excelData ;

    public ExcelDataReader(string fileName)
    {
      excelData = new DataSet();
      Connect(fileName);
    }
    private void Connect(string fileName)
    {
      string sConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source={0};"+
            "Extended Properties=Excel 8.0;", fileName);

      OleDbConnection objConn = new OleDbConnection(sConnectionString);
      objConn.Open();

      try
      {
        OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM [VMM$]", objConn);
        OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
        objAdapter1.SelectCommand = objCmdSelect;
        objAdapter1.Fill(excelData, "XLData");
      }
      finally
      {
        objConn.Close();
      }
    }
  }
}

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com