Sheetjs: Generate Excel sheet with Headings

Created on 7 Jan 2018 · 4Comments · Source: SheetJS/sheetjs

Hi all,
How I can get data in the following format

Employee Details
Emp Name Emp Sal
xyz 1000
abc 2000

Any help would be appreciated.

Source

rajuyadav-orchestratec

Most helpful comment

https://jsfiddle.net/hsgosmp5/ live example:

var Heading = [
  ["Employee Details"],
  ["Emp Name", "Emp Sal"]
];
var Data = [
  {name:"xyz", sal:1000},
  {name:"abc", sal:2000}
];
var ws = XLSX.utils.aoa_to_sheet(Heading);
XLSX.utils.sheet_add_json(ws, Data, {
  header:["name", "sal"],
  skipHeader:true,
  origin:-1
 });

var wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, "SheetJS");
var wbout = XLSX.write(wb, {bookType:'xlsx', type:'array'});
saveAs(new Blob([wbout],{type:"application/octet-stream"}), "issue946.xlsx");

reviewher on 9 Jan 2018

👍5

All 4 comments

https://jsfiddle.net/hsgosmp5/ live example:

var Heading = [
  ["Employee Details"],
  ["Emp Name", "Emp Sal"]
];
var Data = [
  {name:"xyz", sal:1000},
  {name:"abc", sal:2000}
];
var ws = XLSX.utils.aoa_to_sheet(Heading);
XLSX.utils.sheet_add_json(ws, Data, {
  header:["name", "sal"],
  skipHeader:true,
  origin:-1
 });

var wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, "SheetJS");
var wbout = XLSX.write(wb, {bookType:'xlsx', type:'array'});
saveAs(new Blob([wbout],{type:"application/octet-stream"}), "issue946.xlsx");

reviewher on 9 Jan 2018

👍5

Thank you, saved my day

On Jan 9, 2018 10:09 PM, "reviewher" notifications@github.com wrote:

https://jsfiddle.net/hsgosmp5/ live example:

var Heading = [
["Employee Details"],
["Emp Name", "Emp Sal"]
];var Data = [
{name:"xyz", sal:1000},
{name:"abc", sal:2000}
];var ws = XLSX.utils.aoa_to_sheet(Heading);XLSX.utils.sheet_add_json(ws, Data, {
header:["name", "sal"],
skipHeader:true,
origin:-1
});
var wb = XLSX.utils.book_new();XLSX.utils.book_append_sheet(wb, ws, "SheetJS");var wbout = XLSX.write(wb, {bookType:'xlsx', type:'array'});saveAs(new Blob([wbout],{type:"application/octet-stream"}), "issue946.xlsx");

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/SheetJS/js-xlsx/issues/946#issuecomment-356339743,
or mute the thread
https://github.com/notifications/unsubscribe-auth/Aeb8FLPhPhSbBUK-TG8Z73DfKe4NlLYsks5tI5X1gaJpZM4RVimp
.