Create, Update or Convert Excel Workbooks, Worksheets and Objects and Accept or Reject Changes, Work with Fields, Stats & Watermarks in Microsoft Word Documents
We are pleased to announce the release of Aspose 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 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.
New Microsoft Word Features
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. Below is a list of enhancements per product.
Aspose.Cells Cloud
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.
Rename Excel Worksheets – This feature lets you rename existing worksheets. You can use the worksheet resource and send a POST request specifying new name of the worksheet.
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.
Delete Background Image from Excel Worksheets – This feature allows you to delete a background image or watermark. You can use the worksheet resource and the worksheets/worksheetName/background URI and send a DELETE request to delete a watermark.
Freeze Panes in Excel Worksheets – This feature allows you to freeze panes in worksheets. This enables you to always see specific rows or columns, you can even scroll up, down, left or right. You can use the worksheet resource and a worksheets/worksheetName/FreezePanes URI and send a PUT request to freeze panes.
Unfreeze Panes in Excel Worksheets – This feature allows you to unfreeze panes in worksheets. You can use the worksheet resource and a worksheets/worksheetName/FreezePanes URI and send a DELETE request to unfreeze panes.
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.
Group Rows in Excel Worksheets – This feature allows you to group selected rows in worksheets. You can use the rows resource and a /rows/group URI and send a POST request to group rows.
Ungroup Rows in Excel Worksheets – This feature allows you to ungroup selected rows in worksheets. You can use the rows resource and a /rows/ungroup URI and send a POST request to ungroup 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.
Update Hyperlinks in Excel Worksheets – This feature allows you to update existing hyperlinks in your worksheets. The hyperlinks resource can be used and a POST request can be sent to update a hyperlink.
Delete Hyperlinks from Excel Worksheets – This feature allows you to remove existing hyperlinks from your worksheets. The hyperlinks resource can be used and a DELETE request can be sent to remove 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.
Unmerge Cells in Excel Worksheets – This feature allows you to unmerge selected merged cells in worksheets. You can use the cells resource and a /rows/unmerge URI and send a POST request to unmerge cells.
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 Range Value in Excel Worksheets – This feature allows you to set value of range in your worksheets. Range is the area consists of multiple cells so you can set a certain value for number of cells. The cells resource can be used and a POST request can be sent to set range value.
Clear Cells or Range in Excel Worksheets – This feature allows you to clear data and formatting of certain cells or range in your worksheets. The cells resource and a /cells/clearcontents URI can be used and a POST request can be sent for this purpose.
Update Cell Style in Excel Worksheets – This feature allows you to change cells’ formatting in your worksheets. The cellStyle resource can be used and a POST request can be sent for this purpose.
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.
Get Cells’ Properties from Excel Worksheets – This feature allows you to get certain properties of cells including 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 use the cells resource and a /cells/FirstCell, /cells/EndCell, /cells/MinRow, /cells/MinDataRow, /cells/MinColumn, /cells/MinDataColumn, /cells/MaxRow, /cells/MaxDataRow, /cells/MaxDataRow, /cells/MaxColumn and /cells/MaxDataColumn URIs respectively and send GET requests to get respective properties.
In addition to the above features, several enhancements have been made to Aspose.Cells Cloud’s codebase to resolve several bugs and improve quality when exporting Excel workbooks or worksheets to other formats.
Aspose.Words Cloud
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.
Reject All Tracking Changes – This feature allows you to reject all tracking changes in a Word document. The acceptAll resource can be used and a POST request can be sent for this purpose.
Update All Fields in the Word Document – This feature allows you to update all fields in a document. The updateFields resource can be used and a POST request can be sent for this purpose.
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.
Set Names for Output Files – Many resources now support the filename parameter to allow you to set a name of your choice for output documents. These resources include replaceText, protection, headersFooters, watermark, insertPageNumbers, executeTemplate and executeMailMerge.
In addition to the above features, several bugs have been fixed and several enhancements have been made to Aspose.Words Cloud’s codebase to improve performance and quality of the output files.
