We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Accessing listboxes from worksheet and replacel with database values

Hi,

Thanks for quick response.

After getting the listbox from worksheet,

I want to fill worksheet listbox in cell with our database values, which will repeat in each row on same column with same value.

What
actually I want, I am attaching one excel sheet, please find it. Here
in k2 Cell I am getting Dropdown, same dropdown I am getting K3, K4, so
on.


How to get this result? Please give the solution.

Thanks,
Veeru1.





Hi,

We have already told you, you cannot set source range directly from database table/values.
You have to and should import data from database table using e.g
Cells.ImportDataTable() method to some worksheet cells, see the
document : http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/importing-data-to-worksheets.html how you can import data from different data sources. Then you may apply List data validation on your desired area in the sheet.

The template you provide here has list validation on K column cells (you mentioned), you can achieve similar results by adding / apply List data validation, see the document for your reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/data-filtering-and-validation.html


Thank you.