The node offers following actions for your use-cases:
For this, Cobalt offers 2 actions CSV to JSON file or JSON to CSV file in which you provide the public URL of the file which needs to be converted.
Using this action, simply provide the CSV input which will be converted to a JSON object and returned by the node.
Using this action, provide the array of rows which will be converted to CSV and returned by the node.
This action will convert the JSON file that you provide as a Public URL into an Excel file.
If your Excel file will have formulas, you could also convert them from your CSV by enabling the Has Formulas toggle of the node. It will consider the strings starting with = as formulas.
This action will convert the JSON data that you provide into an Excel file.
If your Excel file will have formulas, you could also convert them from your CSV by enabling the Has Formulas toggle of the node. It will consider the strings starting with = as formulas.
In this, simply provide the public URL of the CSV file that you want to convert to Excel.
If your Excel file will have formulas, you could also convert them from your CSV by enabling the Has Formulas toggle of the node. It will consider the strings starting with = as formulas.
This action will merge multiple Excel files into a single Excel. You simply need to provide the Public URLs of all the Excel files as array items in the input.
