Is it possible that excel cell has combox after export to file

Hi Team,


For aspose.cell component, after I export sheet to file, is it possible that the cell has combox feature?
I only found GridDesktop.Worksheet can show combox under edit mode (sheet.Controls.AddComboBox) or below hyperlink which is not my requirement, because it also is edit mode:
Data Validation|Documentation

Demo code:
Aspose.Cells.Workbook wb = new Workbook();
wb.Worksheets.Clear();
wb.Worksheets.Add(“Test”);
Worksheet ws = wb.Worksheets[0];

for (int i = 0; i <= 10; i++)
{
Cell cell = ws.Cells[0, i];
cell.PutValue("Title " + i);
}
for (int i = 1; i <= 5; i++)
{
for (int k = 0; k <= 10; k++)
{
Cell cell = ws.Cells[i, k];
cell.PutValue(“R” + i + “_C” + k);
}
}
wb.Save(“c:\1.xls”);

How can I set “Title 0” column has combox, e.g. user can select “AA”, “BB”,"CC’ for “Title 0” column after open 1.xls with microsoft office excel?

Thanks your help!!

Hi,


Thanks for providing us some details.

Well, you may choose any one option accordingly for your requirements, Aspose.Cells component supports both of them as following:
1) Add ComboBox control to your Excel sheet, see the document for your reference here:
http://www.aspose.com/docs/display/cellsnet/Working+with+Controls
(please see the description text and example code under sub-heading “Adding Combo Box Control to a Worksheet” in the document for your reference)


2) You may add List validation to your Excel sheet for your desired range of cells for your column(s) accordingly, see the document for your reference:
http://www.aspose.com/docs/display/cellsnet/Data+Filtering+and+Validation#DataFilteringandValidation-list
(please see the description/ text and example code under sub-topic “Programming Samples: List Data Validation” in the document)

If you still have any confusion or issue, kindly post a sample file with your desired control (ComboBox) in the worksheet, you may create the sample file in Ms Excel manually, we will check it soon.

Thank you.