riyadhalnur / excelbuilderjs-node Goto Github PK

var originalData = [
        ['Artist1', 'Album', 'Price'],
        ['Buckethead2', 'Albino Slug', 8.99],
        ['Buckethead3', 'Electric Tears', 13.99],
        ['Buckethead4', 'Colma', 11.34],
        ['Crystal Method5', 'Vegas', 10.54],
        ['Crystal Method6', 'Tweekend', 10.64],
        ['Crystal Method7', 'Divided By Night', 8.99]
    ];

    var artistWorkbook = Excel.createWorkbook();
    var albumList = artistWorkbook.createWorksheet({name: 'Album List'});

    albumList.setData(originalData); //<-- Here's the important part

    artistWorkbook.addWorksheet(albumList);

    //artistWorkbook.generateFiles();

    var data = Excel.createFile(artistWorkbook);
    var result = new Buffer(data, 'base64');
     res.setHeader('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64');
  res.setHeader('Content-Disposition', 'attachment; filename=' + 'demo.xlsx');
  res.end(result);

["Simple Text", {values: [
    {
         "value": "Complex",
          "size": 12,
          "bold": true,
          "color": "#ff0000"
    }, 
    { 
          "value": "Text",
           "size": 18,
           "color": "#0000ff"
    }        
]}]

<si>
        <t>Simple Text</t>
</si>
<si>
        <r>
            <rPr>
                <sz val="12"/>
                <color rgb="FF00000"/>
                <bold/>
            </rPr>
            <t>Complex</t>
        </r>
        <r>
            <t xml:space="preserve"> </t>
        </r>
        <r>
            <rPr>
                <b/>
                <sz val="18"/>
                <color theme="0000FF"/>
            </rPr>
            <t>0000ff</t>
        </r>
</si>

var wb = Excel.createWorkbook();
var stylesheet = wb.getStyleSheet();
stylesheet.fonts[0].size = 12;

var sheetFormatPr = util.createElement(doc, 'sheetFormatPr');
  sheetFormatPr.setAttribute('baseColWidth', 11);
  sheetFormatPr.setAttribute('defaultRowHeight', 15);
  worksheet.appendChild(sheetFormatPr);


  if (this.columns.length) {
     worksheet.appendChild(this.exportColumns(doc));
  }
  worksheet.appendChild(sheetData);