コード例 #1
0
        private void FileOpen()
        {
            OpenFileDialog dlg = new OpenFileDialog();

            dlg.Filter = "Excel文件|*.xls;*.xlsx|所有文件|*.*";

            if (dlg.ShowDialog() == DialogResult.OK)
            {
                this.tbFileName.Text = dlg.FileName;
                dlg.Dispose();
                dc.DBName               = tbFileName.Text;
                dsExcelFile             = new ExcelDBSource(dc);
                cbbSheets.DataSource    = dsExcelFile.GetTableNames();
                cbbSheets.SelectedIndex = 0;
            }
        }