Add Text to Excel: Efficiently Insert Data with Spreadsheet WEB API
Excel API : PostAddTextContent
Adds text content to a specified location within a spreadsheet. It requires an object that defines the text to be added and the insertion location.
Interface Details
Endpoint
POST http://api.aspose.cloud/v3.0/cells/addtext
Function Description
This method safely appends new text to specified cells, supporting multiple insertion modes and format handling.
-
Add text to the beginning of selected cells
Prepends text to all selected cells, ensuring consistency in your data entry. Ideal for adding common identifiers or labels such as product codes, categories, or prefixes. -
Insert characters before or after specific text
Places characters before or after the target text in the selected cells, allowing you to create structured and organized content easily. -
Append the same text to the end of every selected cell
Adds identical text to the end of multiple cells in one operation, simplifying data entry and guaranteeing a uniform appearance. -
Insert text before or after a specified number of characters
Inserts text after a defined number of characters from the beginning or the end of each cell in the target range. Typical use cases include formatting codes, timestamps, or custom delimiters.
The request parameters of postAddTextContent API are
| Parameter Name | Type | Location | Description |
|---|---|---|---|
| addTextOptions | Class | Body | Specifies the text content and the position where the text should be added. |
Response Description
{
"Filename": "xxxxxx.pdf",
"FileSize": xxxx,
"FileContent": "File Content: base64_encoded_string"
}
OpenAPI Specification
The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.
Excel API SDK
Using an SDK is the best way to speed up development. An SDK handles low‑level details so you can focus on your project tasks. 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: