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/v4.0/cells/spreadsheet/create
Security and Authentication
The Aspose.Cells Cloud APIs are secure and require JWT token-based authentication.
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"
}
}
]
HTTP Status Codes
| Code | Meaning | Description |
|---|---|---|
| 200 | OK | Filter applied successfully; response contains operation details. |
| 400 | Bad Request | Missing or invalid parameters (e.g., unsupported file type). |
| 401 | Unauthorized | Invalid or missing JWT token. |
| 413 | Payload Too Large | Uploaded file exceeds size limit. |
| 500 | Internal Server Error | Unexpected server error. |
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.
For subsequent operations such as adding worksheets or populating cells, see the Add Worksheet API, Update Cell API, and Export Workbook API.
Why should you use the Create Spreadsheet API?
- Developer‑Friendly – Provides SDK libraries for multiple languages and extensive documentation, simplifying integration compared to building custom solutions.
- Labor Efficiency – Allows automation of document consolidation, reducing manual effort.
- Pay‑per‑Use Pricing – Charges are based on API usage without upfront licensing fees.
- Managed Service – The API is fully hosted, removing the need for on‑premises server maintenance or software updates.
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.
You can use the cURL command‑line tool to access Aspose.Cells web services easily. The following example shows how to make calls to the Cloud API with cURL.
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: