а

CSV support vs JSON


#1

Hello, We are evaluating this product for our needs. I like the JSON loading, bit we don’t want to store our data in a format that ties us to a specific tool. Does the spreadsheet support the loading of CVS files. or would I need to convert those to Excel?

Also, is there a performance hit in loading an xls file vs json data?

Thanks


#2

Yes, the component can load data from CSV

https://docs.dhtmlx.com/spreadsheet/loading_data.html#externaldataloading
https://docs.dhtmlx.com/spreadsheet/samples/01_init/05_csv_load.html

we don’t want to store our data in a format that ties us to a specific tool

You can store data in the dabase in any format, and just convert data to the format of spreadsheet as part of REST api. CSV is fine, but you will not be able to store styling info in the CSV