We’re pleased to announce monthly release Aspose.Cells Cloud 19.10. It is already published and available on the aspose.cloud production server. It includes new exciting features including delete data validation from Excel worksheets and support to add HTML string in a cell along with the issue fixes reported in the previous versions of Aspose.Cells Cloud. We’ve also updated the SDKs of all the supporting platforms for new release. You can download the latest SDKs of Aspose.Cells Cloud from the download section now, and start exploring the new features. Please spare some time and check the release notes of this version for a complete list of enhancements and improvements.
In the following sections, I’ll give you a quick walk through of the data validation feature in Microsoft Excel using Aspose.Cells Cloud API.
Data Validation in Microsoft Excel
Aspose.Cells Cloud is an easy to use spreadsheet creation, manipulation and conversion REST API that provides all the features that Microsoft Excel provides without depending on Microsoft Excel. When setting up a workbook for your users, cell validation is one of the features that you can use data validation to restrict the type of data or the values that users enter into a cell, to make sure all data entries are accurate and consistent.
Here, I will explain how to do Data Validation in Excel using Aspose.Cells Cloud: add data validation, update data validation rule and remove all data validations from a worksheet. I am using cURL in the sample code, but you can use the SDK of your favorite programming language in your specific project. Currently, it supports SDKs for .NET, Java, PHP, Python, Ruby, Node.js, Android, Swift and Perl.
Add a data validation to a cell
Add a validation at index(A1) in a worksheet Sheet1.
Add/Update data validation rule
Add a custom data validation rule, YES or NO. Aspose.Cells Cloud API supports all types of data validation rules.
Data validation rule settings
Data validation rule test
Delete all data validations
Delete all data validations from the worksheet.
Feel free to drop us a comment below, or share your thoughts about the new version of Aspose.Cells Cloud API on our support forum.
If you are new to Aspose.Cells Cloud and have not already had a chance to try it, simply start a free trial today. All you need is to sign up with the aspose.cloud. Once you have signed up, you are ready to try the powerful file processing features offered by aspose.cloud. Following are some useful resources of Aspose.Cells Cloud you may need to accomplish your tasks.