[攒分帖]C#读Excel文件


using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Data.SqlClient;
using System.Data.OleDb; 
using System.IO;namespace DButlity
{
    public class EmployExcel
    {
        private static string _filePath = "C:\\Users\\JIE\\Desktop\\新建文件夹\\订货单格式.xls";
        //private string _conString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
        //    "Data Source=" + _filePath + ";" +
        //    "Extended Properties=\"Excel 8.0;IMEX=1;\"";        public static DataSet CreateDataSource(string filePath)
        {
            try
            {
                string strConn;                strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                "Data Source=" + filePath + ";" +
                "Extended Properties=\"Excel 8.0;IMEX=1;\"";//连接                OleDbConnection conn = new OleDbConnection(strConn);                conn.Open();                System.Data.DataTable schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);                string tableName = schemaTable.Rows[0][2].ToString().Trim();//得到excel表名                OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [" + tableName + "]", strConn);//查找excel数据                DataSet myDataSet = new DataSet();//定义数据                myCommand.Fill(myDataSet);                conn.Close();                return myDataSet;                
            }
            catch
            {
                throw;
            }
        }
    }
}