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 content, supporting multiple insertion modes and format handling.Supports multiple insertion modes:
- Add text to the beginning of selected cells: Prepend text to all selected cells, ensuring consistency in your data entry.This option is perfect for adding common identifiers or labels to a column of data, such as product codes, categories, or prefixes.
- Insert characters before or after specific text: Tailor your data presentation by placing characters before or after specified text in the selected cells. This allows you to create structured and organized content with ease.
- Append same text to the end of every selected cell: Add the same text to the end of multiple cells in one go. This simplifies data entry and ensures a uniform appearance throughout your document.
- Insert text before or after a specified number of characters: Precision meets convenience as you add certain text after a specified number of characters from the beginning or from the end of every cell in the target range.Typical use cases include:
The request parameters of postAddTextContent API are
| Parameter Name | Type | Path/Query String/HTTPBody | Description |
|---|---|---|---|
| addTextOptions | Class | Body | that 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 the development. An SDK takes care of low-level details and lets you 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 make calls to Aspose.Cells web services using various SDKs: