Update Word Case

Excel API : PostUpdateWordCase

Managing inconsistent text case in spreadsheets (Excel, Google Sheets, CSV) can be frustrating, especially with large datasets. The PostUpdateWordCase WEB API solves this by automating text case conversions, ensuring clean and standardized data with minimal effort.

Interface Details

Endpoint

POST http://api.aspose.cloud/v3.0/cells/updatewordcase

Function Description

The PostUpdateWordCase WEB API is a powerful tool designed to address the common issue of inconsistent text case in spreadsheets, which can significantly impact data analysis and processing. This API automates the conversion of text case, ensuring that your data is clean, standardized, and ready for further manipulation or analysis.

  • Automated Text Case Conversion:

    • Uppercase to Lowercase: Convert all uppercase letters to lowercase.
    • Lowercase to Uppercase: Convert all lowercase letters to uppercase.
    • Capitalize First Letter: Capitalize the first letter of each word.
    • Title Case: Convert text to title case, where the first letter of each major word is capitalized.
  • Support for Multiple Formats: The API supports a wide range of spreadsheet formats, including Excel , Open Office, Json,CSV, and so on. This versatility makes it suitable for various data processing needs.

The request parameters of postUpdateWordCase API are

Parameter Name Type Path/Query String/HTTPBody Description
wordCaseOptions Class Body

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: