How to add dropdown in excel sheet programmatically????

Question

Hi to All,

I am using the ExcelPackage dll to creating the excel from the .net application.

I want to add drop down list in one of column of Excel sheet. How to add it????

Also I want to do some formatting changes to the cell values.

Please reply .........

Regards, Girish

Answer 1

Try spreadsheetgear ....

Answer 2

You can try SmartXLS for .Net.

To create dropdown:

 WorkBook workBook = new WorkBook();
  FormControlShape comBoxShape1 = workBook.addFormControl(3.0, 3.0, 4.1, 4.1, FormControlShape.CombBox);
  comBoxShape1.CellRange = "A1:A3";
  comBoxShape1.CellLink = "B4";