Hi Team,
Please let me know how to export the igGrid content into CSV format.
Please update with the sample code to achieve the same.
Thanks,
Shrenath.
Hi Shrenath,
Thank you for posting in our community.
I have created and attached a sample illustrating the behavior of downloading the igGrid data to an CSV file.
On the onClick handler the dataSource and the columns of the grid are retrieved. Also an empty array is created which will contain the parsed data in the correct CSV format.
var ds = $("#grid").igGrid("option", "dataSource"); var cols = $("#grid").igGrid("option", "columns"); var csv = [];
Then the columns are iterated through to get the key value from each one and then it is pushed to an empty headerRow array. Afterwards the array is flattened with the joint method and the pushed into the the csv array:
var headerRow = []; $.each(cols, function (index, col) { headerRow.push(col.key); }); csv.push(headerRow.join(","));
The same is done for the rows with the data:
$.each(ds, function (index, row) { var csvRow = []; $.each(row, function (index, cell) { csvRow.push(cell); }); csv.push(csvRow.join(",")); });
Finally the populated csv array is passed to a function witch is responsible for converting the array into csv file and start downloading it:
downloadCSV(csv.join("\n"), "csvExport.csv");
Let me know if you have any questions.
1273.Sample.zip