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 and return a file_uuid. The file is stored in its own uuid folder: when file_name is given the file keeps that name (folder = uuid, name = file_name, e.g. /report.xlsx); when file_name is empty a default name is used. Later calls address the file via the returned file_uuid regardless of the name.

Download the file identified by the given file_uuid 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.

Extract the full structure of a spreadsheet stored in Aspose Cloud Storage as a JSON document: workbook metadata, worksheets, tables (with column formulas), pivot tables, charts, and shape coordinates. Call this to inspect a workbook before editing or converting. Redundant empty nodes are omitted.

Extract the full structure of a spreadsheet (provided as a Base64 string) as a JSON document: workbook metadata, worksheets, tables (with column formulas), pivot tables, charts, and shape coordinates. Call this to inspect a workbook before editing or converting. Redundant empty nodes are omitted.

Save a spreadsheet in cloud storage to another format while enforcing a print-scaling strategy for large reports (e.g. compress all data onto one page, or fit columns to page width) so the output matches the intended page layout instead of truncating content. Scaling only applies when the target format's save options support it; otherwise the call fails with a clear error rather than silently ignoring the mode.

Parameters:

• file_uuid: The unique identifier of the stored workbook.

• target_format: The desired output format (e.g. 'PDF', 'CSV', 'XLSX').

• scaling_mode: one of NoScaling, FitSheetOnOnePage, FitAllColumnsOnOnePage.

  • NoScaling: no automatic scaling; honors the worksheet's own page setup.

  • FitSheetOnOnePage: scale all rows and columns onto a single page (supported for PDF, XPS, DOCX, PPTX and image output).

  • FitAllColumnsOnOnePage: scale all columns to one page width; rows may extend over multiple pages (supported for DOCX, PPTX and XPS output). FitAllRowsOnOnePage is NOT supported by Aspose.Cells Cloud save options and requesting it returns an error. Returns:

• The file_uuid of the saved file.

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.