Angular5CSV formatting directly with a delimiter in excel?

Asked Mar 22 '19 at 15:10

Active Mar 22 '19 at 15:10

Viewed 578 times

I've been using https://www.npmjs.com/package/angular5-csv to export my material data table to CSV format. I used the ',' field seperator but in excel you actually have to convert data using the delimiter, and I would like to know if it's possible to directly have the formatted csv.

Here's my code.

exportCsv() {
    let options = {
      fieldSeparator: ',',
      showLabels: true,
      useBom: true,
      headers: ['Name', 'Errors'],
      nullToEmptyString: true
    };
    new Angular5Csv(this.renderedData, 'Test Report', options);
}

If anyone could help me that would be greatly appreciated.

Thanks in advance !

asked Mar 22 '19 at 15:10

Mich

I think excel uses `;` as default separator for CSV files. – Askirkela Mar 22 '19 at 16:03
Thanks man that actually solves the problem :) – Mich Mar 22 '19 at 16:37

Angular5CSV formatting directly with a delimiter in excel?

0 Answers0