如何使用C＃在Excel中读取组合框的值

问题描述：

在我的应用程序中，我需要创建一个包含多个组合框的excel文件。如何使用C＃在Excel中读取组合框的值

现在我必须从excel中读取这些组合的值。我已经找到了一个链接从Excel Read From Excel

但在我的代码来读取我发现这个..

这里是我的代码

Microsoft.Office.Interop.Excel.Application oXL = new Microsoft.Office.Interop.Excel.Application(); 
Microsoft.Office.Interop.Excel._Workbook oWB; 
Microsoft.Office.Interop.Excel._Worksheet oSheet; 
Microsoft.Office.Interop.Excel.Range oRng; 

//Get a new workbook. 
oWB = (Microsoft.Office.Interop.Excel._Workbook)(oXL.Workbooks.Open("C:\\TopicUpload_2017October14.xls")); 
//3rd Sheet 
oSheet = (Microsoft.Office.Interop.Excel._Worksheet) oWB.Sheets.get_Item(1); 

Microsoft.Office.Interop.Excel.DropDowns allDropDowns = oSheet.DropDowns(Type.Missing); 
Microsoft.Office.Interop.Excel.DropDown oneDropdown = allDropDowns.Item("2");

现在我怎样才能得到这个下拉列表的选定文本..当我检查我得到

oneDropdown.ListCount = 5.0; // items count of second drop down, which is true

但无法获得选定的文本。

oneDropdown.Text

答

搜索后，我能够得到它。

#region Read value from excel combobox 
        Microsoft.Office.Interop.Excel.Application oXL = new Microsoft.Office.Interop.Excel.Application(); 
        Microsoft.Office.Interop.Excel._Workbook oWB; 
        Microsoft.Office.Interop.Excel._Worksheet oSheet; 
        Microsoft.Office.Interop.Excel.Range oRng; 

        //Get a new workbook. 
        oWB = (Microsoft.Office.Interop.Excel._Workbook)(oXL.Workbooks.Open("C:\\TopicUpload_2017October14.xls")); 
        //3rd Sheet 
        oSheet = (Microsoft.Office.Interop.Excel._Worksheet)oWB.Sheets.get_Item(1); 

        Microsoft.Office.Interop.Excel.DropDowns allDropDowns = oSheet.DropDowns(Type.Missing); 
        Microsoft.Office.Interop.Excel.DropDown oneDropdown = allDropDowns.Item("1"); // first combo 
        string selectedText = oneDropdown.get_List(oneDropdown.ListIndex); 
    #endregion

如何使用C＃在Excel中读取组合框的值

相关推荐