Add Cells Data Based on Named Range and Enforce Validations on Cells using Aspose.Cells Cloud 18.3
[![][1] for a full set of changes to the APIs.
New Features and Enhancements 1. API that returns Cells Data based on Named Range
GET /cells/{name}/worksheets/{sheetName}/ranges/value returns cells data based on Named Range. Please check [API Reference guide][2] for parameters details. The following Postman example explain how to call the API:
[https://documenter.getpostman.com/view/2744137/asposecells/RVnSH2XN][3]
firstRow and firstColumn parameters are zero-indexed.
**2. Insert an image into an Excel document using Image URL that gets downloaded each time the user opens the document
Copy Range with Paste Options using Aspose.Cells Cloud 17.9
[![Aspose Cells for Cloud][1]. Aspose.Cells Cloud is a platform independent REST API that allows developers to process their Excel files on Cloud. This release comes up with some new feature and enhancements. Please check [Aspose.Cells Cloud 17.11 Release Notes][2] for more infrmation.
Convert Excel File to HTML in Cloud When Excel file is converted to HTML, it does not generate just a single file. Instead, the conversion generates many related files like multiple HTML files, CSS files, JavaScript files etc.
Apply Conditional Formatting to Excel Files using Aspose.Cells Cloud 17.8
![conditional formatting][1]. 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 new feature. Developers can add and manipulate Conditional Formatting using conditionalformattings API. Please check [Release Notes][2] for summarized information about all the changes in this release.
New Features and Enhancements Apply Conditional Formatting Conditional formatting allows you to apply formats to a cell or range of cells and have that formatting change depending on the value of the cell or the value of a formula.
Filter data in a Worksheet and Calculate Formulas in a Workbook Using Aspose.Cells Cloud 17.6
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.
Delete Comments in a Worksheet and Apply Microsoft Excel 2007 Themes and Colors using Aspose.Cells Cloud 17.5
It gives us immense pleasure to announce the release of version 17.5 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. Developers can delete all comments in an Excel worksheet and apply Microsoft Excel 2007 themes and color. We also made enhancements to Import Data API, Copy Worksheet API, Task API and Convert API.
AutoFit Cells in the Worksheet and Set Excel Page Breaks after a number of Rows and Columns on Cloud
[![autofit rows autofit columns][1]. Aspose.Cells Cloud is a platform independent REST API that allows developers to process their Excel files on Cloud. The new version of the API allows developers to implement their various new scenarios to manipulate the Excel files. They may import an Excel file, autofit rows and columns of any worksheet, and then save to any supported file format. All the supported file formats and features of the API are listed here: [Aspose.
Create Pivot Table to Summarize Data, Apply Pivot Filters, Convert List Objects or Table to Range and Recalculate Pivot Table Data on Cloud
This article explains the details on how we can programmatically create pivot tables in Excel workbooks. It also explains the details on how we can apply filters in Pivot tables.
Show or Hide Pivot Items of Pivot Fields in the Pivot Table and Resize List Object or Table inside the Worksheet using the Aspose.Cells APIs on Cloud
API to manipulate Excel worksheet.
Aspose.Cells Cloud is a platform independent document manipulation API is a true REST API that can be used with any language: .NET, Java, Perl, PHP, Ruby, Rails, Python, Node.js and many more. You can use it with any platform — web, desktop, mobile and cloud.
With Aspose.Cells Cloud, you can work with all aspects of spreadsheets e.g. worksheets, rows, columns, cells, text, data, images, links, comments, formulas, charts and save them to PDF, HTML, XPS and many other formats.
Import Data Asynchronously with Import Data Task, Working with List Object or Table inside Worksheet and Support of List Object and Workbook Settings Operations into Task Processing
Aspose.Cells Cloud’s platform independent document manipulation API is a true REST API that can be used with any language: .NET, Java, Perl, PHP, Ruby, Rails, Python, Node.js and many more. You can use it with any platform — web, desktop, mobile and cloud.
With Aspose.Cells Cloud, you can work with all aspects of spreadsheets e.g. worksheets, rows, columns, cells, text, data, images, links, comments, formulas, charts and save them to PDF, HTML, XPS and many other formats.
Working with Shapes, Import CSV Data and Get Named Ranges supported in Aspose.Cells Cloud 1.4.0
Aspose.Cells Cloud’s platform independent document manipulation API is a true REST API that can be used with any language: .NET, Java, Perl, PHP, Ruby, Rails, Python, Node.js and many more. You can use it with any platform — web, desktop, mobile, and cloud.
With Aspose.Cells Cloud, you can work with all aspects of spreadsheets e.g. worksheets, rows, columns, cells, text, data, images, links, comments, formulas, charts and save them to PDF, HTML, XPS and many other formats.