Create, Update, Copy Excel Worksheets & Add Watermark to Word Docs in Cloud

What's New in this Release?

We are pleased to announce the release of Aspose for Cloud 1.1.6.3. With this new release, the create, read, manipulate and export features are greatly improved, and many new resources have been introduced. With Aspose.Cells for Cloud API, you can convert Microsoft Excel workbooks to other formats with additional settings, copy, rename and update Excel worksheets, set or delete background or watermark of a worksheet, freeze or unfreeze panes of a worksheet, hide, unhide, group, ungroup, auto-fit or copy rows in a worksheet. You can further add, update or delete hyperlinks in Excel worksheets, merge or unmerge cells, set value of cells or range, delete value of cells or range, set style of cells or range and delete formatting of cells or range in a worksheet and get cell properties including the first cell, last cell, minimum row, minimum data row, minimum column, minimum data column, maximum row, maximum data row, maximum column and maximum data column. You can also split Microsoft Word documents to DOC, DOCX, DOCM, DOT, DOTX, DOTM, PDF, XPS,TIFF, EPUB and several other formats, get document statistics, accept or reject all tracking changes, update fields and add or delete watermarks in a Word document. Many resources now support saving output documents with new names to your selected storage and several UI and API issues have also been fixed in this release. Following are some important enhancements made to different Aspose for Cloud APIs.

• Convert Microsoft Excel Workbooks with Additional Settings – This feature lets you set export options when converting Excel workbooks to other formats. You can use saveAs (Controller resource) and send a POST request (sending export options in the request body) to convert. Export options for all supported formats are listed on the above mentioned resource page. Sometimes your output size is larger than your input files. You can use this feature in such cases to control the size of output by reducing the quality.
• Copy Excel Worksheets – This feature allows you to copy existing worksheets. You can use the worksheet resource and send a POST request specifying the names of source and target worksheets.
• Update Excel Worksheets – This feature allows you to update worksheet properties including Type, Name, Index and many others. You can use the worksheet resource and send a POST request (sending properties in the request body) to update.
• Set Background Image in Excel Worksheets – This feature allows you to set a background image. You can also use this feature to set an evaluation watermark image for your worksheets. The Worksheet resource and a worksheets/worksheetName/background URI can be used and a PUT request can be sent (sending image in the request body) to set a watermark.
• Hide Rows in Excel Worksheets – This feature allows you to hide selected rows in worksheets. You can use the rows resource and a /rows/hide URI and send a POST request to hide rows.
• Unhide Rows in Excel Worksheets – This feature allows you to unhide selected rows in worksheets. You can use the rows resource and a /rows/unhide URI and send a POST request to hide rows.
•  AutoFit Rows – This feature allows you to automatically adjust height and width of cells in Excel workbooks or worksheets. This feature was added to resolve in rendering multiline cells. Without this feature, output documents show only the first line of the multiline cells but if you set the isAutoFit parameter of the workbook resource to true, you will see the correct output while converting Excel documents with multiline cells.
• Copy Rows in Excel Worksheets – This feature allows you to copy selected rows in worksheets. You can use the rows resource and a /rows/copy URI and send a POST request to copy rows
• Add Hyperlink in Excel Worksheets – This feature allows you to add hyperlinks in your worksheets. The hyperlinks resource can be used and a PUT request can be sent to add a hyperlink.
• Merge Cells in Excel Worksheets – This feature allows you to merge selected cells in worksheets. You can use the cells resource and a /cells/merge URI and send a POST request to merge.
• Set a Cell’s Value in Excel Worksheets – This feature allows you to set value of a cell in your worksheets. The cell resource can be used and a POST request can be sent to set value of a cell.
• Set a Cell’s Value in Excel Worksheets – This feature allows you to set value of a cell in your worksheets. The cell resource can be used and a POST request can be sent to set value of a cell.
• Clear Cells’ Formatting in Excel Worksheets – This feature allows you to clear formatting of certain cells or range in your worksheets. The cells resource and a /cells/clearformats URI can be used and a POST request can be sent for this purpose.
• Split Word Documents – This feature allows you to convert all or specific pages in a Microsoft Word document to another format. The split document feature was already supported but now supports many additional formats including DOC, DOCX, DOCM, DOT, DOTX, DOTM, PDF, XPS, TIFF, EPUB, HTML, MHTML, SVG and several other formats.
• Get Word Document Statistics – This feature allows you to get the paragraph count on a page, and word count in a document, page or paragraph. The statistics resource can be used and a GET request can be sent for this purpose.
• Accept All Tracking Changes – This feature allows you to accept all tracking changes in a Word document. The acceptAll resource can be used and a POST request can be sent for this purpose.
• Add Watermark to a Word Document – This feature allows you to add watermark text or image to a Word document. This feature was already supported but the old insertWatermarkText and insertWatermarkImage URIs have been updated to watermark/insertText and watermarkrtImage.
• Delete Watermark from a Word Document – This feature allows you to delete a watermark from a Word document. The watermark resource can be used and a DELETE request can be sent to delete a watermark.
• Update API Version to MVC 5 and Web API 2.0 – The Aspose for Cloud API Help section has been updated and you can now test GET, PUT, POST and DELETE requests.

In addition to the above features, several bugs have been fixed and several enhancements have been made to Aspose for Cloud APIs.

Overview: Aspose for Cloud

Aspose for Cloud is a cloud-based document generation, conversion and automation platform for developers that offer a unique suite of APIs to work with Word documents, Excel spreadsheets, PowerPoint presentations, PDFs, and email formats and protocols. It supports all features for file processing, document scanning, barcodes creation and recognition, and allows extracting text or images too. You can also work with SaaSpose APIs using REST SDKs that can be called from .NET, Java, PHP and Ruby etc.

Read more about Aspose for Cloud APIs Suite

Merge, Split Presentation, Update PDF Form Fields & Set Cell Formula Using Cloud APIs

What's New in this Release?

We are pleased to announce the release of Aspose for Cloud 1.1.6.2. With this new release, create, read, manipulate and export features are greatly improved. You can create Microsoft PowerPoint presentations from scratch, merge presentations, split presentations, export all or specific slides to HTML, set export options, add new slides, copy existing slides, change position of slides and work with different sections of your slides including comments, font settings, background, height, width and aspect ratio. You can also update form fields in your PDF files as well as set AutoFit rows option for Microsoft Excel workbooks or worksheets and set formula for a cell in the worksheet. Many other enhancements have been made to all Aspose for Cloud APIs and you can also save your output documents to storage or get in response body. Following is the categorized list of enhancements.

• Create PowerPoint presentations – This feature lets you create presentations from scratch. You just need to use presentation resource and send a PUT request to create empty presentation on Aspose for Cloud or third party storage. Newly created presentation can then be downloaded using the download file example.
• Merge multiple presentations – This feature allows you to take all or selected slides from multiple Microsoft PowerPoint presentations and then merge them into a new presentation in your required order. You can use mergePresentations resource and send a POST request (sending presentation paths in request body) to merge all slides and send a PUT request (sending presentation paths and indexes of selected slides in the request body) to merge selected slides in your specified order. This feature can also be used in combination with the create PowerPoint presentations feature to create new presentations from existing presentations.
• Split PowerPoint presentations – This feature allows you to split all or specific slides of a Microsoft PowerPoint presentation to individual images or HTML. All you need to do is use splitDocument resource and send a POST request. Response will contain a list links to split files which can be used to download split files using download file example. splitDocument resource supports format, from, to, height, width and destFolder optional parameters. Split files can be saved to Aspose or third party storage.
• Set export options – This feature allows you to set PDF or HTML options while converting a presentation to PDF or HTML respectively. You can set JpegQuality parameter to change the image quality and control the size of output PDF and set pdfPassword to password protect output PDF. You can also set SaveAsZip parameter to get output HTML as a ZIP. See the Export Options section of the presentation resource for a detailed list of export options.
• Add new slides – This feature lets you add a new empty slide to a PowerPoint presentation. You can use slides resource and send a POST request for this purpose.
• Copy existing slides – This feature lets you create a copy of existing slides to your specified location. The slides resource with POST request can be used for this purpose.
• Change position of slides – This feature lets you change the position of an existing slide using slides resource with POST request.
• Get comments of a Slide – This feature lets you read comments added to a slide. GET method of comments resource can be used for this purpose.
• Work with background – This feature allows you to read background information or remove background of a slide. You can use background resource and send GET or DELETE requests respectively to get or delete background.
• Auto fit rows – This feature allows you to automatically adjust height and width of cells in Excel workbooks or worksheets. This feature was added to resolve in rendering multiline cells. Without this feature, output documents show only first line of the multiline cells but if you set isAutoFit parameter of workbook resource to true, you will see correct output while converting Excel documents with multiline cells.
• Set formula for a cell – This feature lets you set formula for a cell. You can use any formula supported by Microsoft Excel. Formula parameter has been supported for cell resource to pass a formula for a cell.
• Update form fields – This feature allows you to update form fields in a PDF. You can change location, size, type and values of a form field. PUT method of field resource can be used for this purpose.

In addition to the above features, several bugs have been fixed and several enhancements have been made to Aspose for Cloud APIs.

Overview: Aspose for Cloud

Aspose for Cloud is a cloud-based document generation, conversion and automation platform for developers that offer a unique suite of APIs to work with Word documents, Excel spreadsheets, PowerPoint presentations, PDFs, and email formats and protocols. It supports all features for file processing, document scanning, barcodes creation and recognition, and allows extracting text or images too. You can also work with SaaSpose APIs using REST SDKs that can be called from .NET, Java, PHP and Ruby etc.

• Homepage of Aspose for Cloud APIs Suite