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!!