Help Regarding Dropdown in Excel sheet

Aspose.Cells Product Family
1

Hi,

I am using Aspose.Cells for generating Spreadsheets. I found that we can add Combo Box into the Spreadsheet. I did that and it works fine. Now What I am going to do is. We generate spreadsheet and select values from dropdown and save sheet changes. Then we upload that spreadsheet into our system. We read spreadsheet using Aspose.Cells component. Here I can read all other cells values but could not be able to read the Selected Value in the Dropdown.

Please help me with this problem

Regards,
JAMIL

2

Hi,

Thanks for considering Aspose.

Currently it is not supported. We will support it soon for your need.

Thank you.

3

Hi JAMIL,

Please try this fix.See following codes:

ComboBox comboBox = (ComboBox)wb.Worksheets[0].Shapes[0];
Console.WriteLine(comboBox.SelectedIndex);
Console.WriteLine(comboBox.SelectedValue);

And you can use ComboBox.SelectedCell to get Cell object. It wil help you to get any type of value.