[C#] 使用 OleDbConnBuilder 物件讀取 Execl

2009-08-23

摘要:C# 使用 OleDbConnBuilder 物件讀取 Execl

讀取 Execl 方式有很多，這邊利用 OleDbConnBuilder 物件來實做。

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.OleDb;

namespace ReadExecl_OleDbConnBuilder

    public partial class Form1 : Form

        public Form1()

            InitializeComponent();//test

        private void btnConnect_Click(object sender, EventArgs e)

try

                // 利用 OleDbConnectionStringBuilder 物件來構建連接字串。

                OleDbConnectionStringBuilder connectStringBuilder = new OleDbConnectionStringBuilder();

                connectStringBuilder.DataSource = @".\訂單資料.xls";

                connectStringBuilder.Provider = "Microsoft.Jet.OLEDB.4.0";

                connectStringBuilder.Add("Extended Properties", "Excel 8.0");

                using (OleDbConnection cn = new OleDbConnection(connectStringBuilder.ConnectionString))

                    DataSet ds = new DataSet();

                    OleDbCommand cmdLiming = new OleDbCommand("SELECT * FROM [$Sheet1]", cn);

                    cn.Open();

                    using (OleDbDataReader drLiming = cmdLiming.ExecuteReader())

                        ds.Load(drLiming, LoadOption.OverwriteChanges, new string[] { "發票" });

                        DataGridView1.DataSource = ds.Tables[0];

            catch (Exception ex)

                MessageBox.Show(ex.Message, "請注意", MessageBoxButtons.OK, MessageBoxIcon.Stop);

三小俠小弟獻醜，歡迎指教