导入Excel工作表时，如何获得Excel单元格下拉值？ [英] How can I get excel cell dropdown value while importing excel sheet?

问题描述

我使用字符串构建器类创建了一个excel表。我必须在excel表上显示下拉列表。我很成功，但是当我在使用c＃代码导入时使用这个excel表时，下拉值单元格未被识别，其显示像vlaue empty.How我可以在导入excel表时获得下拉值。请帮帮我。

I have created an excel sheet using string builder class. i have to display dropdownlist on excel sheet. i am successful, However when i am using this excel sheet while import using c# code that dropdown value cell not identified and its shows like vlaue empty.How can I get dropdown value while importing excel sheet. please help me on this..

推荐答案

If conn.State = ConnectionState.Open Then
            conn.Close()
        End If
        objExcel = CreateObject("Excel.Application")
        objworkBook = objExcel.Workbooks.Open(txtFileloc.Text)
        cmbSheetname.Items.Clear()

        'Worksheet Display
        For Each totalworkSheets In objworkBook.Worksheets
            cmbSheetname.Items.Add(totalworkSheets.Name)
        Next totalworkSheets

        'Selected  Index Functions
        If cmbSheetname.Items.Count > 0 Then
            cmbSheetname.SelectedIndex = 0
        Else
            MsgBox("No Sheets Found", MsgBoxStyle.Critical, "Error !")
        End If

尝试此代码

Try this Code

这篇关于导入Excel工作表时，如何获得Excel单元格下拉值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！