2D array and formatting options
CSV text
Gets the number of columns in a CSV file. Example: csv='name,age,city John,30,NYC' → 3
CSV text and options
Number of columns
Gets the headers from a CSV file. Example: csv='name,age John,30', headerRow=0 → ['name', 'age']
CSV text and options
Array of header names
Gets the number of rows in a CSV file (excluding headers if specified). Example: csv='name,age John,30 Jane,25', headerRow=0 → 2
CSV text and options
Number of data rows
Converts an array of JSON objects to CSV text. Example: json=[{'name':'John','age':'30'}], headers=['name','age'] → 'name,age John,30'
JSON array, headers, and formatting options
CSV text
Converts an array of JSON objects to CSV text using object keys as headers. Example: json=[{'name':'John','age':'30'}] → 'name,age John,30'
JSON array and formatting options
CSV text
Parses CSV text to a 2D array of strings (rows and columns). Example: csv='a,b,c 1,2,3' → [['a','b','c'], ['1','2','3']]
CSV text and parsing options
2D array of strings
Parses CSV text to an array of JSON objects using headers. Example: csv='name,age John,30 Jane,25', headerRow=0, dataStartRow=1 → [{'name':'John','age':'30'}, {'name':'Jane','age':'25'}]
CSV text and parsing options
Array of JSON objects
Parses CSV text to JSON using custom headers (ignores CSV headers if present). Example: csv='John,30 Jane,25', headers=['name','age'] → [{'name':'John','age':'30'}, {'name':'Jane','age':'25'}]
CSV text, custom headers, and parsing options
Array of JSON objects
Queries CSV data by column/header name and returns all values in that column. Example: csv='name,age John,30 Jane,25', column='name' → ['John', 'Jane']
CSV text, column name, and parsing options
Array of values from the specified column
Queries CSV data and filters rows where a column matches a value. Example: csv='name,age John,30 Jane,25', column='age', value='30' → [{'name':'John','age':'30'}]
CSV text, column name, value, and parsing options
Array of matching rows as JSON objects
Generated using TypeDoc
Converts a 2D array to CSV text. Example: array=[['name','age'], ['John','30']] → 'name,age John,30'
generate
array to csv
false