Filter data in a Worksheet and Calculate Formulas in a Workbook Using Aspose.Cells for Cloud 17.6

Aspose Cells for CloudIt gives us immense pleasure to announce the release of version 17.6 of Aspose.Cells for Cloud API. Aspose.Cells for Cloud is a platform independent REST API that allows developers to process their Excel files on Cloud. This new release comes up with a couple of new features and enhancements. Developers can filter data in a worksheet by using an AutoFilter API and calculate all formulas in a workbook using CalculateFormula API. Please check Release Notes for summarized information about all the changes in this release.

New Features and Enhancements

Filter Data by using an AutoFilter

By filtering information in a worksheet, you can find values quickly. You can filter on one or more columns of data. AutoFilter API allows you to filter data by Cell Value, Cell Color or by Icon. Experiment with filters on text and numeric data by trying the many built-in test conditions, such as Equals, Does Not Equal, Contains, Greater Than, and Less Than or create a custom filter that uses multiple criteria. Please check these help topics for more information.

Calculate all Formulas in a Workbook

CalculateFormula API allow you to calculate all formulas in a workbook. Formula calculation engine is embedded in Aspose.Cells. It can not only re-calculate the formula imported from the designer file but also supports to calculate the results of formulas added at runtime. Please check this help topic for more information.

Aspose.Cells for Cloud Resources

Following are the links to some useful resources you may need to accomplish your tasks.

Start a Free Trial Today

Start a free trial today – all you need is to sign up with the Aspose for Cloud service. Once you have signed up, you are ready to try the powerful file processing features offered by Aspose for Cloud.


To keep up with our news, you can follow us on Twitter or follow our Facebook page.

Leave a Reply