C#读写Excel文件（四）

1、从Excel读取数据存储到DataTable中

/// <summary>

        /// 从excel文件读取内容

        /// </summary>

        /// <param name="fileName">excel文件名</param>

        /// <returns>获取读取数据的表</returns>

        static public DataTable ImportFromExcel(string fileName)

        {

            MSExcel.Application excelApp = null;

            MSExcel.Workbooks wbks = null;

            MSExcel._Workbook wbk = null;

            try

            {

                excelApp = new MSExcel.Application();

                excelApp.Visible = false;//是打开不可见

                wbks = excelApp.Workbooks;

                wbk = wbks.Add(fileName);

 

                object Nothing = Missing.Value;

                MSExcel._Worksheet whs;

                whs = (MSExcel._Worksheet)wbk.Sheets[1];//获取第一张工作表

                whs.Activate();

 

                DataTable dt = new DataTable(whs.Name);

                //读取excel表格的列标题

                int col_coun