【www.gdgbn.com--excel】

一款c#读取excel数据存入dataset
*/
///

    /// 读取数据源
    ///

    ///
    ///
    ///
    public dataset execleds(string filenameurl, string table)
    {
        dataset ds = new dataset();

        try
        {
            string strconn = "provider=microsoft.jet.oledb.4.0;" + "data source=" + filenameurl + ";extended properties="excel 8.0; hdr=yes; imex=1"";
            oledbconnection conn = new oledbconnection(strconn);
            conn.open();

            microsoft.office.interop.excel.application objexcelfile = new microsoft.office.interop.excel.application();
            microsoft.office.interop.excel._workbook objworkbook;
            microsoft.office.interop.excel._worksheet objimportsheet;
            objexcelfile.displayalerts = false;
            objworkbook = objexcelfile.workbooks.open(filenameurl, 0, system.reflection.missing.value, system.reflection.missing.value, system.reflection.missing.value, system.reflection.missing.value, system.reflection.missing.value, system.reflection.missing.value, system.reflection.missing.value, system.reflection.missing.value, system.reflection.missing.value, system.reflection.missing.value, system.reflection.missing.value, system.reflection.missing.value, system.reflection.missing.value);
            objimportsheet = (microsoft.office.interop.excel._worksheet)objworkbook.sheets[1];
            string tablename = objimportsheet.name.tostring();

            oledbdataadapter odda = new oledbdataadapter("select * from [" + tablename + "$]", conn);
            odda.fill(ds, table);
            conn.close();
            objworkbook.close(false, type.missing, type.missing);
            objexcelfile.quit();
            objworkbook = null;
            objimportsheet = null;
            objexcelfile.workbooks.close();
            killprocess("excel");

            gc.collect();

        }
        catch (exception ex)
        {
            response.write(ex.tostring());
        }
        return ds;

    }

本文来源：http://www.gdgbn.com/bangongshuma/27947/