Excel内容读入到datagridview中

Excel内容读入到datagridview中
2007年05月26日 星期六 下午 08:05

public const string EXCELCONNECTION = "Provider=Microsoft.Jet.OLEDB.4.0;"
             + " Extended Properties='Excel 8.0;"
             + " HDR=YES';";

         public const string EXCEL_FILTER = "Microsoft Office Excel 工作簿 (﹡.xls)|*.xls";

         #endregion

 

         /// <summary>
         /// 将Excel文件的数据导出到DataTable
         /// </summary>
         /// <param name="strExcelFileName">Excel 文件名</param>
         /// <param name="dt">out参数,返回DataTable</param>
         /// <param name="strError">out参数,返回出错信息</param>
         /// <returns>
         ///     -1 出错
         ///      0   成功
         /// </returns>
         /// 注:本函数目前只导出Sheet1$表的数据
         public static int Excel2DataTable(string strExcelFileName,
             out DataTable dt,
             out string strError)
         {
             strError = "";
             int nRet = 0;
             dt = null;

             if (String.IsNullOrEmpty(strExcelFileName) == true)
             {
                 strError = "strExcelFile参数不能为空";
                 return -1;
             }

             if (File.Exists(strExcelFileName) == false)
             {
                 strError = "文件'" + strExcelFileName + "'不存在";
                 return -1;
             }

             // 执行导出数据
             string strConnection = ExcelADOUtil.EXCELCONNECTION
                     + "Data Source=" + strExcelFileName + ";";
             OleDbConnection connection = new OleDbConnection(strConnection);
             connection.Open();
             try
             {
                 //-----------------------------------
                 string strCommand = "SELECT * FROM [Sheet1$]";

                 OleDbDataAdapter adapter = new OleDbDataAdapter(strCommand, connection);
                 dt = new DataTable();
                 int nCount = adapter.Fill(dt);

                 //-------------------------------------
             }
             catch (Exception ex)
             {
                 strError = ex.Message;
                 return -1;
             }
             finally
             {
                 connection.Close();
             }

             return 0;
         }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值