Description

Convert a CSV file to XLSX (Excel 2007+ XML Format).

Input Parameters

Output Parameters

Instructions

1. Provide File ID:

   • Select the CSV file to be converted using its fileId.

2. Processing:

   • The component processes the file and converts it into an XLSX format.

3. Retrieve Output:

   • The converted file is returned with a fileId and fileName for further use.

Overview

The Archive component allows you to create a ZIP or TAR archive from a set of files. You can also append files to an existing archive, provided it matches the specified format.

Input Parameters

Output Parameters

Instructions

1. Select Output Format:

   • Choose between zip or tar as the output format.

2. Provide File Name:

   • Specify a name for the archive file, ensuring it includes the appropriate extension (.zip or .tar).

3. Add Files to Archive:

   • Upload or select files using their fileId.

   • If an archiveFileID is provided, new files will be appended to the existing archive.

4. Processing:

   • The component processes and creates the archive, returning the generated file’s fileId and fileName.

Use Cases

• Batch File Compression: Combine multiple files into a single ZIP or TAR archive.

• Incremental Archiving: Append files to an existing archive for ongoing data collection.

• Data Backup & Export: Store or transfer multiple files efficiently as a single archive.

Overview

The CSV2JSON component converts a CSV file into a JSON file.

Input Parameters

Output Parameters

Instructions

1. Provide File ID:

   • Select or upload the CSV file to be converted.

2. Processing:

   • The component processes the CSV file and converts it into JSON format.

3. Output:

   • The converted JSON file is available with its unique fileId and fileName.

Overview

The CSV2HTML component converts a CSV file into an HTML table. This allows for easier visualization and sharing of structured data.

Input Parameters

Output Parameters

Instructions

1. Select the CSV File:

   • Provide the fileId of the CSV file to be converted.

2. Processing:

   • The component will transform the CSV file into an HTML table.

3. Retrieve Output:

   • The converted HTML file’s fileId and fileName will be returned.

Overview

The HTML to CSV Converter component allows you to transform an HTML table file into a CSV format. This is useful for extracting structured data from HTML documents into a tabular format.

Input Parameters

Output Parameters

Instructions

1. Select the HTML File:

   • Provide the fileId of the HTML document that contains a table.

2. Processing:

   • The component extracts the table data from the HTML file and converts it into a structured CSV format.

3. Retrieve Output:

   • The component returns a new file with fileId and fileName in CSV format.

Overview

The DataUri2File component converts a Data URI into a file. It extracts the file content and metadata from the Data URI and generates a downloadable file.

Input Parameters

Output Parameters

Instructions

1. Provide a Data URI

   • Input a valid Data URI string that represents a file.

2. Specify a File Name (Optional)

   • Enter a desired file name with or without an extension.

   • If omitted, the extension is inferred from the file type.

3. Processing

   • The component extracts the file content from the Data URI and saves it as a downloadable file.

   • Returns the fileId and fileName of the newly created file.

Overview

The JSON2HTML component converts a JSON file into an HTML table.

Input Parameters

Output Parameters

Instructions

1. Provide the JSON File:

   • Select or upload a JSON file using its fileId.

2. Processing:

   • The component reads the JSON file and converts it into an HTML table.

3. Retrieve the Output:

   • The output file is provided as an HTML file with a fileId and fileName.

JSON2CSV Component

Overview

The JSON2CSV component converts a JSON file into a CSV format. This enables easier data handling for spreadsheet applications and data processing tools that require CSV input.

Input Parameters

• fileId (string, required): The ID of the JSON file to be converted.

Output Parameters

• fileId (string): The ID of the newly generated CSV file.

• fileName (string): The name of the generated CSV file.

Instructions

1. Upload JSON File: Provide the fileId of the JSON file you wish to convert.

2. Processing: The component processes the input JSON and converts it into a structured CSV format.

3. Retrieve Output: The resulting CSV file's fileId and fileName are returned as output.

JSON2XLSX Component

Overview

The JSON2XLSX component converts a JSON file into an XLSX (Excel 2007+ XML Format) file.

Input Parameters

Output Parameters

Instructions

1. Select the Input JSON File:

   • Upload or provide the fileId of the JSON file to be converted.

2. Processing:

   • The component converts the JSON file into an XLSX format.

3. Retrieve the XLSX File:

   • The output provides the new file's fileId and fileName.

HTML to JSON Converter

Description Convert an HTML table file into a JSON file.

Input Parameters

• fileId (string) - The ID of the file to be converted.

Output Parameters

• fileId (string) - The ID of the newly created JSON file.

• fileName (string) - The name of the converted JSON file.

Overview

The HTML2XLSX component converts an HTML table file into an XLSX (Excel 2007+ XML Format) file.

Input Parameters

Output Parameters

Instructions

1. Provide the File ID:

   • Select or upload an HTML file containing a table.

2. Conversion Process:

   • The component extracts tabular data from the HTML file and converts it into an Excel spreadsheet.

3. Retrieve the Output:

   • The resulting XLSX file is provided as output with a unique fileId and fileName.

XLSX2HTML Component

Overview

The XLSX2HTML component converts an XLSX (Excel 2007+ XML) file into an HTML table format.

Input Parameters

Output Parameters

Instructions

1. Select the XLSX File

   • Choose an existing XLSX file by providing its fileId.

2. Processing

   • The component will convert the XLSX file into an HTML table.

3. Output

   • The resulting file ID and name will be returned for further use.

XLSX2JSON Component

Description: Convert an XLSX (Excel 2007+ XML format) file to JSON.

Input Parameters:

• fileId (string, required): The ID of the file to be converted.

Output Parameters:

• fileId (string): The unique ID of the converted JSON file.

• fileName (string): The name of the generated JSON file.

XLSX2CSV Component

Overview

The XLSX2CSV component converts an XLSX Excel 2007+ XML format file into a CSV file.

Input Parameters

Output Parameters

Instructions

1. Provide File ID:

   • Select an XLSX file using its fileId.

2. Conversion Process:

   • The component processes the XLSX file and converts it into CSV format.

3. Retrieve Output:

   • The converted file is returned with its fileId and fileName.

This component is useful for extracting tabular data from Excel files into a widely used CSV format for further processing.