Aspose.Cells.Examples.CSharp.DrawingObjects.Controls.AddingListBoxControl.Run C# (CSharp) Method

        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

        }
    }