读取 EXCEL的工作表名，读取选中后工作表的列名

本文地址：http://www.cnblogs.com/vnii/archive/2011/09/02/2163381.html 

读取Excel中所有工作表名

            //是否已有字段头
            string strHead = "YES";
            if(chkHead.Checked==false)
            {
                strHead = "NO";
            }
            string excelFilepath = openFileExcel.FileName;
            string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFilepath + ";Extended Properties=\"Excel 12.0;HDR=" + strHead + ";\"";
            if ((System.IO.Path.GetExtension(excelFilepath)).ToLower() == ".xls")
            {
                strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excelFilepath + ";Extended Properties=\"Excel 8.0;HDR=" + strHead + ";IMEX=1\"";
            }

            using (OleDbConnection conn = new OleDbConnection(strCon))
            {
                conn.Open();

                //返回在目录中定义的表
                System.Data.DataTable schemeTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);

                for (int i = 0; i < schemeTable.Rows.Count; i++)
                {
                    //工作表名 schemeTable.Rows[i][2].ToString().Trim()
                    cmbSheets.Items.Add(schemeTable.Rows[i][2].ToString().Trim());
                }
                if (cmbSheets.Items.Count > 0)
                {
                    cmbSheets.Enabled = true;
                    //cmbSheets.SelectedIndex = 0;
                }
                else
                {
                    cmbSheets.Enabled = false;
                }
            }

　　

　　

读取工作表中的字段列名

            //是否已有字段头
            string strHead = "YES";
            if (!bHead)
            {
                strHead = "NO";
            }
            string strSheetName = "";
            if(comboBoxSheets.SelectedIndex!=-1)
            {
                strSheetName = comboBoxSheets.SelectedItem.ToString();
            }
            else
            {
                MessageBox.Show("选择工作表");
                return;
            }

            string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strExcelFilepath + ";Extended Properties=\"Excel 12.0;HDR=" + strHead + ";\"";
            if ((System.IO.Path.GetExtension(strExcelFilepath)).ToLower() == ".xls")
            {
                strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strExcelFilepath + ";Extended Properties=\"Excel 8.0;HDR=" + strHead + ";IMEX=1\"";
            }

            using (OleDbConnection conn = new OleDbConnection(strCon))
            {
                //读取选择的工作表
                OleDbDataAdapter oleDbDataAdapter =
                    new OleDbDataAdapter("Select * from [" + strSheetName + "]", conn);
                DataSet dataSet = new DataSet();
                oleDbDataAdapter.Fill(dataSet, "mytb");
                dataGridView.DataSource = dataSet.Tables["mytb"];

                //工作表内容的列名，注意Excel连接串中的HDR属性
                for (int i = 0; i < dataSet.Tables["mytb"].Columns.Count; i++)
                {
                    comboBoxColumns.Items.Add(dataSet.Tables["mytb"].Columns[i].ColumnName);
                }
                comboBoxColumns.Enabled = true;
            }

　　

参考网页：http://www.cnblogs.com/MR_ke/archive/2010/03/02/1676210.html

　　　　　 http://www.cnblogs.com/litianfei/archive/2008/03/21/1116906.html

　　　　　 http://hi.baidu.com/sunsung111/blog/item/685c5ae606831525b838206a.html