Loading a CSV file into the grid.

Discontinued products Uncategorized discussions
#1

Hey,

I have been trying to load data from a CSV file into my grid. There are over 40,000 columns so I created my own for testing purposes. For some reason I cannot get the CSV to load. Here is my HTML.









Simple dhtmlxSuite

























Simple dhtmlxSuite























And in my csv file i have tried using no spaces after commas, and vice versa. Please help!
#2

You need to define grid structure before loading data from CSV, at least headers, column types and column widths

mygrid = new dhtmlXGridObject(‘gridbox’);

mygrid.setHeader(…
mygrid.setColTypes(…
mygrid.setInitWidths(…
mygrid.init();

mygrid.loadCSV(“test1.csv”);


or enable mode, when grid headers build based on first row in CSV file

mygrid = new dhtmlXGridObject(‘gridbox’);

mygrid.enableCSVHeader();

mygrid.loadCSV(“test1.csv”);