How to add multiple listbox selection to cell in Excel

Question

How to add multiple selection lists to an Excel spreadsheet in each cell of one column. I need to be able to read selected values ​​in C #.

Looking for a managed code solution. CANNOT USE INTEROP

Anything that allows for multiple selection and readability using OLEDB, currently using a list.

We can use only ADO.NET and C #

A drop-down list should appear on each line, and it should be read from OLEDB.

Answer 1

You can use VSTO to create an Excel sheet, add a ListBox, set its SelectionMode to "MultiSimple" or "MultiExtended". You can write the code behind to create it as you wish - on all lines, receiving data from OLEDB, etc.