How to Create New Excel Spreadsheets – Generate Blank or Template‑Based Files

Programmatically create new Excel spreadsheets using Aspose.Cells Cloud API. Generate blank workbooks or instantiate files from custom templates. The RESTful API enables automated Excel file creation, perfect for report generation, document automation, and data‑processing workflows.

Create Spreadsheet API

Web API

PUT https://api.aspose.cloud/v5.0/cells/spreadsheet/create

Request Parameters

Parameter Name Type Location Description
format String Query Required. File format for the new spreadsheet (e.g., XLSX, XLS, ODS, CSV).
template String Query Optional. Name of a template file stored in your cloud storage (e.g., invoice_template.xlsx). If omitted, a blank workbook is created.
outPath String Query Optional. Target folder path in cloud storage for the generated file. If null or omitted, the spreadsheet is saved to the default location.
outStorageName String Query Required. Identifier of the configured cloud storage (e.g., MyDrive).
region String Query Optional. Locale setting (e.g., fr-FR) that determines default date, number, and currency formats.
password String Query Optional. Password for an encrypted template file. Leave empty if the template is not protected.

Response

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

Error Codes

  • 400 Bad Request – Invalid Aspose.Cells Cloud API URI.
  • 401 Unauthorized – Invalid access token or incorrect client ID/secret.
  • 404 Not Found – The specified spreadsheet or template file is not accessible.
  • 500 Server Error – An internal error occurred while processing the request.

Where should we use the Create Spreadsheet API?

  • Initialization of the Automated Reporting System – Create a new blank workbook or generate a report file from a standard template at the start of each daily/weekly automation cycle.
  • User Self‑service Portal – Allow customers to select a template (quotation, project schedule, etc.) and instantly download a customized Excel file.
  • Batch Data Export and Distribution – Produce separate workbooks with a uniform format for each exported data set, simplifying downstream distribution and processing.

Why should you use the Create Spreadsheet API?

  • Developer‑Friendly – Aspose.Cells Cloud offers SDK libraries in multiple languages, enabling quick development and providing comprehensive documentation. Compared with building custom chart‑rendering solutions, this significantly reduces development effort.
  • Reduced Labor Costs – Eliminates the need for dedicated staff to consolidate documents manually.
  • Pay‑per‑Use – No upfront investment; you only pay for the API calls you actually use.
  • Zero Maintenance Costs – No servers to maintain, no software updates, and no compatibility concerns.

How to Use the Create Spreadsheet API with SDKs

Create Spreadsheet API Specification

The Create Spreadsheet API Specification defines a publicly accessible programming interface and enables REST interactions directly from a web browser.

Use Aspose.Cells Cloud SDKs

Using an SDK is the fastest way to develop, as it abstracts low‑level details and lets you build the spreadsheet with concise code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

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