Data validaion

Aspose.Cells Product Family
1

Is it possible to create any pull down values in excel sheet without macro code using aspose.cells.

2

Hi,

Thanks for your question.

I think, you want to extract values from drop down list. If yes, then it is possible.

3

Can you please send me any demo for creating a dropdownlist in excel sheet with values… we used chart concept using aspose and it is giving good result… Before buying your software i want to know about the data validation… So please send me any demo’s for pull down values as soon as possible…

4

Hi,

Please see this code. It will add a dropdown. I have attached the output xlsx file.

I have also added a sample C# project which you can run and get the output xlsx file.

C#


//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(“Employee:”);


//Set it bold.

Style style = cells[“B3”].GetStyle();

style.Font.IsBold = true;

cells[“B3”].SetStyle(style);


//Input some values that denote the input range

//for the combo box.

cells[“A2”].PutValue(“Emp001”);

cells[“A3”].PutValue(“Emp002”);

cells[“A4”].PutValue(“Emp003”);

cells[“A5”].PutValue(“Emp004”);

cells[“A6”].PutValue(“Emp005”);

cells[“A7”].PutValue(“Emp006”);


//Add a new combo box.

Aspose.Cells.Drawing.ComboBox comboBox = sheet.Shapes.AddComboBox(2, 0, 2, 0, 22, 100);


//Set the linked cell;

comboBox.LinkedCell = “A1”;


//Set the input range.

comboBox.InputRange = “A2:A7”;


//Set no. of list lines displayed in the combo

//box’s list portion.

comboBox.DropDownLines = 5;


//Set the combo box with 3-D shading.

comboBox.Shadow = true;


//AutoFit Columns

sheet.AutoFitColumns();


//Saves the file.

workbook.Save(@“F:\Shak-Data-RW\Downloads\DropDown.xlsx”, SaveFormat.Xlsx);

Screenshot:
5

Hi,

Please also refer to this document for a reference and a sample code: Data Filtering and Validation

6

Hi mshakeel.faiz,


Thanks for your help…

The link which you have sent is adding a dropdownlist control but i need a column which contains pull down values…Please reply me as soon as possible…



7

Hi,

Please attach a sample xls/xlsx file with your desired features (pull down values etc) so that we know your requirements. You can create it manually using Ms-Excel.

8

Hi,

My doubts got cleared.

Now i can able to create an excel file with pull down values using Aspose.cells after referring this link Data Filtering and Validation…

Thanks for your help…


9

Hi,

It’s great to know that your question is now sorted out.