Export

Export grid data as CSV or TSV.

Use the namespaced export API for CSV and TSV output.

CSV And TSV

export.ts
const csv = grid.export.csv({
rows: 'all',
columns: 'visible',
includeHeaders: true,
});
const tsv = grid.export.tsv({
rows: 'filtered',
columns: [0, 1, 2],
includeHeaders: true,
});

Download

download-csv.ts
function downloadCsv() {
const csv = grid.export.csv({ rows: 'filtered', columns: 'visible', includeHeaders: true });
const blob = new Blob([csv], { type: 'text/csv;charset=utf-8' });
const url = URL.createObjectURL(blob);
const link = document.createElement('a');
link.href = url;
link.download = 'zengrid-export.csv';
link.click();
URL.revokeObjectURL(url);
}

Filtered Exports

filtered-export.ts
grid.filter.set(2, 'equals', 'active');
grid.filter.set(3, 'in', ['Electronics', 'Computers']);
const csv = grid.export.csv({
rows: 'filtered',
columns: 'visible',
includeHeaders: true,
});
Info

Compatibility aliases exportCSV() and exportTSV() exist, but new code should prefer grid.export.csv() and grid.export.tsv().