Class CSVBitByBit

Converts a 2D array to CSV text. Example: array=[['name','age'], ['John','30']] → 'name,age\nJohn,30'

Converts an array of JSON objects to CSV text. Example: json=[{'name':'John','age':'30'}], headers=['name','age'] → 'name,age\nJohn,30'

Converts an array of JSON objects to CSV text using object keys as headers. Example: json=[{'name':'John','age':'30'}] → 'name,age\nJohn,30'

Parses CSV text to a 2D array of strings (rows and columns). Example: csv='a,b,c\n1,2,3' → [['a','b','c'], ['1','2','3']]

Parses CSV text to an array of JSON objects using headers. Example: csv='name,age\nJohn,30\nJane,25', headerRow=0, dataStartRow=1 → [{'name':'John','age':'30'}, {'name':'Jane','age':'25'}]

Parses CSV text to JSON using custom headers (ignores CSV headers if present). Example: csv='John,30\nJane,25', headers=['name','age'] → [{'name':'John','age':'30'}, {'name':'Jane','age':'25'}]

Queries CSV data by column/header name and returns all values in that column. Example: csv='name,age\nJohn,30\nJane,25', column='name' → ['John', 'Jane']

Queries CSV data and filters rows where a column matches a value. Example: csv='name,age\nJohn,30\nJane,25', column='age', value='30' → [{'name':'John','age':'30'}]

Gets the headers from a CSV file. Example: csv='name,age\nJohn,30', headerRow=0 → ['name', 'age']

Gets the number of rows in a CSV file (excluding headers if specified). Example: csv='name,age\nJohn,30\nJane,25', headerRow=0 → 2

Gets the number of columns in a CSV file. Example: csv='name,age,city\nJohn,30,NYC' → 3