Get Supported File Load/Import Formats

Use this tool to query the list of all source file formats that Aspose.Cells can read (load). Call this tool when a user wants to upload or process a non-standard Excel file (e.g., .csv, .json, .xml, .ods, .txt) and you need to verify if the system can parse it.

Returns:

• Format Name: The name of the format (e.g., CSV, JSON, XML, ODS, XLSX, XLS, TXT, HTML).

• Extension: The file suffix (e.g., .csv, .json).

• Description: Characteristics of loading this format (e.g., 'Data only, no formatting', 'Requires specific parser', 'Preserves formulas').

Usage Guidelines:

1. Before calling upload_file, if the user is uploading a file with an extension other than .xlsx or .xls, use this tool to confirm the format is recognizable.

2. If a user asks 'Can you handle CSV files?', check this list and provide a confirmation.

3. Distinguish between 'Load Formats' (Input) and 'Save Formats' (Output). Some formats may support reading but not writing (or vice versa).

Get Supported File Save/Export Formats

Use this tool to query the list of all file formats supported by Aspose.Cells for conversion. Call this tool when a user asks to convert an Excel file to another format (e.g., 'convert to PDF', 'save as image', 'export to JSON') and you need to verify the correct file extension or availability.

Returns:

• Format Name: The name of the format (e.g., PDF, HTML, CSV, JSON, XLSX, ODS, TXT, SVG).

• Extension: The file suffix (e.g., .pdf, .html).

• Description: A brief explanation of the format's use case (e.g., 'Suitable for printing', 'Web display', 'Programmatic access').

💡 Usage Guidelines:

1. Before calling convert_file or convert_with_options, if you are unsure what string to pass for the target_format parameter, use this tool to get the standard extension.

2. If a user requests an unsupported format, use this list to recommend the closest available alternative.

Upload file content (provided as a Base64 string) to Aspose Cloud Storage at a specified path.

Download the file identified by the given file token and return its contents as a Base64-encoded string.

Convert a spreadsheet in Aspose Cloud Storage to a different format (e.g., XLSX to PDF) and save it as a new file.

This tool is specifically designed to handle the printing needs of large-scale data reports. It allows you to enforce specific print scaling strategies when converting spreadsheets into target formats (such as PDF or images). By specifying the scaling mode, you can ensure that the output files strictly conform to the intended page layout, for example, compressing all data onto a single page, or adjusting only the column widths to fit the page width, thereby perfectly addressing issues of content truncation or layout disorder.

This tool is specifically designed to handle the printing needs of large-scale data reports. It allows you to enforce specific print scaling strategies when converting spreadsheets into target formats (such as PDF or images). By specifying the scaling mode, you can ensure that the output files strictly conform to the intended page layout, for example, compressing all data onto a single page, or adjusting only the column widths to fit the page width, thereby perfectly addressing issues of content truncation or layout disorder.

This tool is specifically designed to handle the printing needs of large-scale data reports. It allows you to enforce specific print scaling strategies when converting spreadsheets into target formats (such as PDF or images). By specifying the scaling mode, you can ensure that the output files strictly conform to the intended page layout, for example, compressing all data onto a single page, or adjusting only the column widths to fit the page width, thereby perfectly addressing issues of content truncation or layout disorder.

This tool saves spreadsheet data in a specified format and applies custom save options. It allows users to precisely control the behavior of the output file through a JSON object, such as setting passwords, optimizing output, or adjusting rendering properties.

Convert Spreadsheet content (provided as a Base64 string) to a specified format such as PDF, CSV, HTML, or XPS.

Convert an Excel file to PDF. Input must be provided as a Base64 encoded string.

Convert a ODS file to PDF. Input must be provided as a Base64 encoded string.

Convert Excel content (provided as a Base64 string) to CSV format.

Convert Excel content (provided as a Base64 string) to JSON format

Convert Excel content (provided as a Base64 string) to a specified format such as PDF, CSV, HTML, or XPS.

Removes specified leading and trailing characters from text values within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Removes specified leading characters only (from the beginning) of text values within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Removes specified trailing characters only (from the end) of text values within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Removes excessive line breaks (multiple consecutive newline characters) from text values within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Collapses multiple line breaks into single line breaks or removes them entirely based on configuration. Returns True if the operation succeeds.

Removes ALL line break characters (including \n, \r\n, \r) from text values within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Converts multi-line text into single-line text by deleting all newline characters. Returns True if the operation succeeds.

Converts text case (uppercase, lowercase, title case, sentence case, or toggle case) within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Removes all non-printing control characters (ASCII 0-31 except tab, newline, carriage return) and other invisible characters from text values within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Removes all text/alphabetic characters (A-Z, a-z) from cells within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API, preserving numbers, symbols, and whitespace. Returns True if the operation succeeds.

Removes all numeric digit characters (0-9) from cells within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API, preserving letters, symbols, and whitespace. Returns True if the operation succeeds.

Removes all symbol and special characters (punctuation, currency symbols, mathematical operators, etc.) from cells within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API, preserving alphanumeric characters (A-Z, a-z, 0-9) and whitespace. Returns True if the operation succeeds.

Removes punctuation marks from text cells while preserving alphanumeric characters and other symbols. This function uses Aspose.Cells Cloud API to process an Excel file and delete punctuation marks from text within cells. It removes sentence-ending punctuation (periods, question marks, exclamation points), internal punctuation (commas, semicolons, colons), quotation marks, apostrophes, parentheses, brackets, and other punctuation. However, it preserves letters (A-Z, a-z), numbers (0-9), spaces, and other symbol characters like currency symbols ($, €, £), mathematical operators (+, -, =, *, /), and special symbols (@, #, %, &, etc.). This is useful for text preprocessing in NLP, removing sentence boundaries for analysis, cleaning text for word counting, or preparing data for text mining where punctuation is considered noise.

Removes user-specified custom characters from text values within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Supports case-sensitive or case-insensitive removal. Returns True if the operation succeeds.

Removes the first N characters from the beginning of each text cell within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Removes the last N characters from the end of each text cell within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Removes all characters before (to the left of) a specified delimiter text within each text cell in a worksheet range using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Removes all characters after (to the right of) a specified delimiter text within each text cell in a worksheet range using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Adds specified text to the beginning (head) of each text cell within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Adds specified text to the end(tail) of each text cell within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Adds specified text immediately before a target delimiter/selector text within each text cell in a worksheet range using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Adds specified text immediately after a target delimiter/selector text within each text cell in a worksheet range using Aspose.Cells Cloud API. Returns True if the operation succeeds.

Converts numeric values (integers, decimals, percentages, currencies, dates, times) to text strings within a specified range of a worksheet in an Excel file using Aspose.Cells Cloud API. Preserves formatting and converts to user-readable text representation. Returns True if the operation succeeds.

Replaces all line break characters (\n, \r\n, \r) within text cells with a specified replacement text string in a worksheet range using Aspose.Cells Cloud API. Returns True if the operation succeeds.