Add Cells Data Based on Named Range and Enforce Validations on Cells using Aspose.Cells Cloud 18.3

Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

We are pleased to announce the new monthly release of Aspose.Cells Cloud 18.3. This release introduced an API that return Cells Data based on Named Range and an API to delete names. Please go through the Aspose.Cells Cloud 18.3 Release Notes 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 for parameters details. The following Postman example explain how to call the API:
https://documenter.getpostman.com/view/2744137/asposecells/RVnSH2XN
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

PUT /cells/{name}/worksheets/{sheetName}/pictures API lets you add a picture to the worksheet. The SourceFullName parameter of the API lets you add an image into an Excel document using Image URL that gets downloaded each time the user opens the document.

3. Enforce Validations on Cells

We have fixed the bug, now Validations APIs are correctly enforcing the validations on Cells.

Aspose Cloud Resources

You may visit the following API resources for getting started and working with the API.

  • Product Documentation – Detailed API documentation with code examples and details about API functional areas
  • API Reference Guide – Quickly browse through all Aspose.Cells Cloud APIs and test them in the browser