It gives us immense pleasure to announce the release of version 17.6 of Aspose.Cells Cloud API. Aspose.Cells 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 AutoFilterBy 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 WorkbookCalculateFormula 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.

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