public static void Run()
{
// ExStart:1
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create directory if it is not already present.
bool IsExists = System.IO.Directory.Exists(dataDir);
if (!IsExists)
System.IO.Directory.CreateDirectory(dataDir);
// Create a new Workbook.
Workbook workbook = new Workbook();
// Get the first worksheet.
Worksheet sheet = workbook.Worksheets[0];
// Get the worksheet cells collection.
Cells cells = sheet.Cells;
// Input a value.
cells["B3"].PutValue("Choose Dept:");
// Set it bold.
cells["B3"].GetStyle().Font.IsBold = true;
// Input some values that denote the input range
// For the list box.
cells["A2"].PutValue("Sales");
cells["A3"].PutValue("Finance");
cells["A4"].PutValue("MIS");
cells["A5"].PutValue("R&D");
cells["A6"].PutValue("Marketing");
cells["A7"].PutValue("HRA");
// Add a new list box.
Aspose.Cells.Drawing.ListBox listBox = sheet.Shapes.AddListBox(2, 0, 3, 0, 122, 100);
// Set the placement type.
listBox.Placement = PlacementType.FreeFloating;
// Set the linked cell.
listBox.LinkedCell = "A1";
// Set the input range.
listBox.InputRange = "A2:A7";
// Set the selection tyle.
listBox.SelectionType = SelectionType.Single;
// Set the list box with 3-D shading.
listBox.Shadow = true;
// Saves the file.
workbook.Save(dataDir + "book1.out.xls");
// ExEnd:1
}
}