Delete Hyperlinks in Spreadsheets and Replace Text in PDF

[![Aspose Cloud APIs][1] Excel worksheets, [set][2] or [delete background][3] or watermark of a worksheet, freeze or [unfreeze panes][4] of a worksheet, [hide][5], [unhide][6], group, ungroup, auto-fit or copy rows in a worksheet. You can further add, update or [delete hyperlinks][7] in Excel worksheets, [merge][8] or [unmerge cells][9], set [value of cells][10] or [range][11], [delete value of cells or range][12], 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][13], [minimum row][14], [minimum data row][15], minimum column, minimum data column, maximum row, maximum data row, maximum column and maximum data column.

New Microsoft Word FeaturesYou 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][16] or [delete watermarks][17] 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][18] – 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][19] – 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][20] – 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][21] – 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][22] – This feature allows you to hide selected rows in worksheets. You can use the [rows][23] resource and a /rows/hide URI and send a POST request to hide rows.
[Unhide Rows in Excel Worksheets][24] – This feature allows you to unhide selected rows in worksheets. You can use the [rows][25] 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][26] 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][27] 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][28] 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][29] 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][30] 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][31] resource can be used and a POST request can be sent to update a hyperlink.
[Delete Hyperlinks from Excel Worksheets][32] – This feature allows you to remove existing hyperlinks from your worksheets. The [hyperlinks][33] resource can be used and a DELETE request can be sent to remove a hyperlink.
[Merge Cells in Excel Worksheets][34] – This feature allows you to merge selected cells in worksheets. You can use the [cells][35] resource and a /cells/merge URI and send a POST request to merge.
[Unmerge Cells in Excel Worksheets][36] – This feature allows you to unmerge selected merged cells in worksheets. You can use the [cells][37] resource and a /rows/unmerge URI and send a POST request to unmerge cells.
[Set a Cell’s Value in Excel Worksheets][38] – This feature allows you to set value of a cell in your worksheets. The [cell][39] resource can be used and a POST request can be sent to set value of a cell.
[Set Range Value in Excel Worksheets][40] – 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][41] resource can be used and a POST request can be sent to set range value.
[Clear Cells or Range in Excel Worksheets][42] – This feature allows you to clear data and formatting of certain cells or range in your worksheets. The [cells][43] 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][44] 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][45] 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][46], [minimum row][47], [minimum data row][48], minimum column, minimum data column, maximum row, maximum data row, maximum column and maximum data column. You can use the [cells][49] 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][50] – 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][51] 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][52] 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][53] 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][54] resource can be used and a POST request can be sent for this purpose.
[Add Watermark to a Word Document][55] – 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][56] and [watermark/insertImage][57].
Delete Watermark from a Word Document – This feature allows you to delete a watermark from a Word document. The [watermark][58] 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][59], protection, headersFooters, [watermark][60], insertPageNumbers, executeTemplate and [executeMailMerge][61].

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.

Aspose Cloud Platform

[Update API Version to MVC 5 and Web API 2.0][62] – The Aspose Cloud API Help section has been updated and you can now test GET, PUT, POST and DELETE requests.

Some platform related issues have also been fixed in this release.

Aspose Cloud User InterfaceThe following issues have been fixed in the Aspose Cloud UI:

My Files tab not working.
UI does not allowing users to work with new folders.
UI does not open existing folders.

Aspose.Cells Cloud#

Aspose.Words Cloud#

Aspose Cloud Platform#

Aspose Cloud User InterfaceThe following issues have been fixed in the Aspose Cloud UI:#

Aspose.Cells Cloud

Aspose.Words Cloud

Aspose Cloud Platform

Aspose Cloud User InterfaceThe following issues have been fixed in the Aspose Cloud UI: