How to export Javascript array data to excel on the client side

Question

I have been struggling with Javascript array data to put it in excel on the client side. I have read this,How to export JavaScript array info to csv (on client side)?

But that is for CSV. I want Excel.

score 2 · Answer 1 · answered Nov 23 '17 at 04:40

2

I got a good answer. It may help someone out there

function excelformat() {
        var result_table = [
            ["Day", "Month", "Year"],
            ["1", "January", "2016"],
            ["2", "February", "2016"],
            ["3", "March", "2016"],
            ["4", "April", "2016"],
        ];
        var lineArray = [];
        result_table.forEach(function(infoArray, index) {
            var line = infoArray.join(" \t");
            lineArray.push(index == 0 ? line : line);
        });
        var csvContent = lineArray.join("\r\n");
        var excel_file = document.createElement('a');
        excel_file.setAttribute('href', 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(csvContent));
        excel_file.setAttribute('download', 'Visitor_History.xls');
        document.body.appendChild(excel_file);
        excel_file.click();
        document.body.removeChild(excel_file);
    }

answered Nov 23 '17 at 04:40

kimoduor

375
4
12

that's not an excel file at all - it's still a CSV, with a `.xls` file extension – Jaromanda X Nov 23 '17 at 04:46
CSV comes with "," for rows and "\n" for new lines then datatype for csv is text/csv;charset=utf-8. – kimoduor Nov 23 '17 at 04:51
my point is you claim this creates an XLS file, it does not, it creates a CSV file with `.xls` as the filename extension - this doesn't change the actual content from csv to the far more complex xls – Jaromanda X Nov 23 '17 at 04:56
How can I do that please? For instance bold some lines, draw border lines. – kimoduor Nov 23 '17 at 05:11
it's your answer, dude – Jaromanda X Nov 23 '17 at 05:16
OK, I will revisit – kimoduor Nov 23 '17 at 05:19

score 0 · Answer 2 · answered Oct 12 '21 at 15:52

You can also use the package fs-browsers.
It has nice and easy export method for xls files.
It goes like this:

import { exportFile, EXCEL_FILE } from 'fs-browsers';
const result_table = [
        ["1", "January", "2016"],
        ["2", "February", "2016"],
        ["3", "March", "2016"],
        ["4", "April", "2016"],
    ];
const headings = ["Day", "Month", "Year"];
exportFile(result_table, { type: EXCEL_FILE, headings: headings });

How to export Javascript array data to excel on the client side

2 Answers2

Linked