Managing inconsistent text case formatting in spreadsheets (Excel, Google Sheets, CSV) can be frustrating, especially with large datasets. The PostUpdateWordCase WEB API of Aspose.Cells Cloud solves this by automating text case conversions, ensuring clean and standardized data with minimal effort.
Core Features: Intelligent Text Case Formatting Conversion in Excel
1. Text Case Formatting
-
UPPERCASE: Convert all text to uppercase (e.g., “product name” → “PRODUCT NAME”).
- Use Case: Formatting product SKUs or invoice IDs (“inv_123” → “INV_123”).
-
lowercase: Convert all text to lowercase (e.g., “Customer Email” → “customer email”).
- Use Case: Preparing email lists for CRM imports.
-
Title Case: Capitalize the first letter of each word (e.g., “sales report 2024” → “Sales Report 2024”).
- Use Case: Formatting report headers or document titles.
-
Sentence Case: Capitalize only the first letter of each sentence (e.g., “this is a test. hello world!” → “This is a test. Hello world!”).
- Use Case: Standardizing user-generated content in databases.
2. Precise Range Control
- Worksheet: Apply cleaning across the whole sheet.
- Workbook: Process all worksheets in the workbook.
- SelectionOnly: Target specific ranges only.
3. Flexible Data Input
- CloudFileSystem: Process files from cloud storage (set DataSourceType + DataPath).
- RequestFiles: Handle files uploaded directly via FileInfo.
- HttpUri: Access files from web URLs(set DataSourceType + DataPath).
How It Works: 3-Step Spreadsheet Cleaning
- Acquire Access Token.
- Process Text Format.
- Parse Response to Retrieve Result File.
Reference code:
Why Use This API?
- Ensures consistent and professional-looking data with minimal coding.
- Simplifies spreadsheet text formatting, saving hours of manual work.
- Easy Integration, provides Multi-Language SDK Libraries.
SDKs Guide: Installing and Using Aspose.Cells Cloud SDKs
Streamline your development workflow with our multi-language SDKs for seamless Excel/spreadsheet automation. Get started in minutes with these battle-tested installation methods.
Comprehensive SDK Installation Matrix
Language | Package Manager | Installation Command | Documentation Link |
---|---|---|---|
.NET | NuGet | dotnet add package Aspose.Cells-Cloud |
.NET SDK Quick Start |
Java | Maven | mvn repository: https://repository.aspose.cloud/repo/ |
Java SDK Quick Start |
Python | pip | pip install asposecellscloud |
Python SDK Quick Start |
Node.js | npm | npm i asposecellscloud |
Node.js SDK Quick Start |
PHP | Composer | composer require aspose/cells-sdk-php |
PHP SDK Quick Start |
Go | Go Modules | go install github.com/aspose-cells-cloud/aspose-cells-cloud-go/v25@latest |
GoLang SDK Quick Start |
Ruby | RubyGems | gem install aspose_cells_cloud |
Ruby SDK Quick Start |
Perl | CPAN | cpanm AsposeCellsCloud::CellsApi |
Perl SDK Quick Start |
Conclusion
Aspose.Cells Cloud Text Formatting API automates Excel text case standardization (UPPER/lower/Title/Sentence case) with precision range control and multi-language SDKs, transforming hours of manual cleaning into a few lines of code
FAQ
-
Q: What file formats does this API support? A: We fully support Excel(.xlsx/.xls), CSV and Open office documents to meet all your office needs.
-
Q: Does it support Chinese text processing? A: Yes! We’ve specially optimized our Chinese processing engine, perfectly supporting case conversion for Chinese, English and mixed texts.
-
Q: Is there an API call limit? A: The free version has a month limit of 150 calls. See our pricing page for details.
-
Q: How do you handle cells with formulas? A: By default we only process text content, but you can choose to process formula cells through parameter settings.