C#读Excel写入数据库.doc

#region 读取Excel
        /// <summary>
        /// 将 Excel 文件转成 DataTable 后,再把 DataTable中的数据写入表Products
        /// </summary>
        /// <param name="serverMapPathExcelAndFileName"></param>
        /// <param name="excelFileRid"></param>
        /// <returns></returns>
        public static int WriteExcelToDataBase(string excelFileName)
        {
            int rowsCount = 0;
            OleDbConnection objConn = new ("Provider=;Data Source=" + excelFileName+ ";" + "Extended Properties=Excel ;");
            ();
            try
            {
                DataTable schemaTable = (, null);
                string sheetName = ;
                for (int j = 0; j < ; j++)
                {
                    sheetName = [j][2].ToString().Trim();//获取 Excel 的表名,默认值是sheet1
                    DataTable excelDataTable = DbHelp
(excelFileName, sheetName, true);
                    if ( > 1)
                    {
                        SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(connectionString, );
                            = "Products";//数据库中的表名