Copy Range with Paste Options using Aspose.Cells for Cloud 17.9

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

Aspose Cells for CloudWe are pleased to announce the release of Aspose.Cells for Cloud 17.9. Aspose.Cells for 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 Release Notes for summarized information about all the changes in this release.

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. In this release, we zip all of these related files together and send back to user a single zip file which he can download and unzip at his end. Please see the following article for more help.

Copy Range in a Worksheet with Paste Options

You can copy range in a worksheet with different paste options. Please see the following URI and JSON that can be used for this purpose.

http://api.aspose.cloud/v1.1/cells/sampleRangeCopyTo.xlsx/worksheets/Sheet1/ranges
{
  "Operate": "copyto",
 
  "Source": {
    "ColumnCount": 5,
    "ColumnWidth": 8.43,
    "FirstColumn": 1,
    "FirstRow": 0,
    "RowCount": 7,
    "RowHeight": 15,
  },
  "Target": {
    "ColumnCount": 5,
    "ColumnWidth": 8.43,
    "FirstColumn": 10,
    "FirstRow": 20,
    "RowCount": 7,
    "RowHeight": 15,
  }
,
  "PasteOptions": {
    "OnlyVisibleCells": true,
    "PasteType": "All",
    "SkipBlanks": true,
    "Transpose": false
  }
}

Change Heights of Rows and Widths of Columns inside the Range

You can change the heights of rows and widths of the columns inside the range with the following URIs.

~/{file-name}/worksheets/{sheetname}/ranges/rowHeight
~/{file-name}/worksheets/{sheetname}/ranges/columnWidth

Import CSV Data into Worksheet with Custom Parser

You can import CSV data into worksheet with custom parser. Custom Parser defines which column is to be formatted with custom format. Please see the following JSON that contains the CustomParsers object inside it.

{  
   "SeparatorString":",",
   "ConvertNumericData":true,
   "FirstRow":1,
   "FirstColumn":2,
   "SourceFile":"TestImportDataCSV.csv",
   "CustomParsers":[  
      {  
         "ColumnIndex":6,
         "ParseMethod":"ToString",
         "CustomStyle":"0%"
      }
   ],
   "DestinationWorksheet":"Sheet1",
   "IsInsert":true,
   "ImportDataType":"CSVData",
   "Source":null
}

Aspose.Cells for Cloud Resources

Following are the links to some useful resources you may need to accomplish your tasks.

Start a Free Trial Today

Start a free trial today – all you need is to sign up with the Aspose for Cloud service. Once you have signed up, you are ready to try the powerful file processing features offered by Aspose for Cloud.


To keep up with our news, you can follow us on Twitter or follow our Facebook page.

Leave a Reply