angular-csv-ext icon indicating copy to clipboard operation
angular-csv-ext copied to clipboard

How to add another header with one row in Angular5Csv generated Csv in Angular5?

Open fahad88 opened this issue 6 years ago • 0 comments

I have a custom component in Angular5 application named data-graph component. In that custom component i received data which i am exporting to Csv using Angular5Csv angular package which is downloading instantly on button click correctly. Here is that clicked function code from data-graph.component.ts

import { Angular5Csv } from 'angular5-csv/dist/Angular5-csv' exportToCsv() { let fileName = this.sensors[0].meter.name + 'Sensors Report'; this.sensorsData.map(item => { if (item._id) { delete item._id; } item.Time = new Date(item.date).toLocaleString(); delete item.date; }) this.customData = this.sensorsData; let fields = Object.keys(this.customData[0]); var options = { fieldSeparator: ',', decimalseparator: '.', title: '', showLabels: true, showTitle: true, noDownload: false, headers: fields, }; new Angular5Csv(this.customData, fileName, options); let anotherCsv = new Angular5Csv(this.customData, fileName, options); }

This exports a csv with data and headers very correctly in this format :

 `F1      C1      P1        Time
 10.0   12.54    9.32   2/26/2019, 2:08:22 PM
 08.32  12.54    2.32   2/26/2019, 2:08:24 PM
 05.01  12.54    5.32   2/26/2019, 2:08:27 PM
 11.0   12.54    6.32   2/26/2019, 2:09:22 PM`

But i want to add another header with one row like this :

`Min     Max    Average
F1   05.01  11.0     09.32
C1   02.66  15.04    10.65
P1   2.32   6.32     3.44`

`F1      C1      P1        Time
10.0   12.54    9.32   2/26/2019, 2:08:22 PM
08.32  15.04    2.32   2/26/2019, 2:08:24 PM
05.01  04.33    5.32   2/26/2019, 2:08:27 PM
11.0   02.66    6.32   2/26/2019, 2:09:22 PM`

How can i achieve this result using angular5Csv?

fahad88 avatar Feb 27 '19 07:02 fahad88