Add a Worksheet to a Spreadsheet

Adding a worksheet to the spreadsheet, specifying the type and location of the worksheet.

Worksheet Type Description
VB Visual Basic module
Worksheet Worksheet
Chart Chart sheet
BIFF4Macro BIFF4 Macro sheet
InternationalMacro International Macro sheet
Other International Macro sheet
Dialog Dialog worksheet

Add Worksheet to Spreadsheet API

PUT http://api.aspose.cloud/v4.0/cells/spreadsheet/add/worksheet

Request Parameters:

Parameter Name Type Path/Query String/HTTPBody Description
Spreadsheet File FormData Upload spreadsheet file.
sheetType String Query Specifies the name of the new worksheet. If not provided, a default name will be assigned.
position Integer Query Specifies the position at which the new worksheet should be inserted. If not provided, the worksheet will be added at the end of the workbook.
sheetName String Query Specifies the type of worksheet to be added. If not provided, a default worksheet type will be used.
outPath String Query (Optional) The folder path where the workbook is stored. The default is null.
outStorageName String Query Output file storage name.
region String Query The spreadsheet region setting.
password String Query The password for opening the spreadsheet file.

Response

[
    {
        "Name": "ResponseFile",
        "DataType": {
            "Identifier": "File",
            "Reference": "Stream"
        }
    }
]

Error Codes

  • 400 Bad Request: Invalid Apose.Cells Cloud API URI.
  • 401 Unauthorized: Invalid access token. Or invalid client id and secret.
  • 404 Not Found: The spreadsheet file not accessible.
  • 500 Server Error: The spreadsheet has encountered an anomaly in obtaining calculation data.

Where should we use the Add Worksheet to Spreadsheet API?

When you need to add a worksheet for a spreadsheet, you can use this API.

Why should you use the Add worksheet to Spreadsheet API?

  • Add a worksheet to the spreadsheet, specifying the type and location of the worksheet.
  • Development can be quickly completed through the existing SDK.

How to Use the Add Worksheet to Spreadsheet API with SDKs

Add Worksheet to Spreadsheet API Specification

The Add Worksheet to Spreadsheet API Specification defines a publicly accessible programming interface and allows you to carry out REST interactions directly from a web browser.

Use Aspose.Cells Cloud SDKs

Using the SDK is the fastest way to develop, as it abstracts away the low-level details, allowing you to add a worksheet to a spreadsheet with short code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples demonstrate how to make API calls to Aspose.Cells web services using various SDKs: