Replies

• colin Posts: 15,177Questions: 1Answers: 2,590

  November 2019

  Nice, that'll be really useful. Thanks for sharing
• Vkay Posts: 3Questions: 0Answers: 0

  September 2021

  Hi @kthorngren

  I have tried to add one more table as example3 and was passing something like

  addSheet(xlsx, '#example3', 'My Sheet3', 'Roles', '3');

  to export it with other data, but i was un-successful the excel crashed and the file is stated to be corruppted in some form when i tried to open the exported excel.

  any help on this???
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  September 2021

  The addSheet() function has some hard coded statements that need refactored to allow for more sheets to be added. I think there is a thread on the forum, can't find it right now, where someone fixed this code to allow for more than one sheet to be added.

  My guess is the changes need to happen in this section of code:

      //Add sheet relationship to xl/_rels/workbook.xml.rels => Relationships
      //=====================================================================
      var source = xlsx.xl._rels['workbook.xml.rels'].getElementsByTagName('Relationship')[0];
      var clone = source.cloneNode(true);
      clone.setAttribute('Id','rId3');  // remove hard coding
      clone.setAttribute('Target','worksheets/sheet2.xml');  // remove hard coding
      xlsx.xl._rels['workbook.xml.rels'].getElementsByTagName('Relationships')[0].appendChild(clone);
      
      //Add second sheet to xl/workbook.xml => <workbook><sheets>
      //=========================================================
      var source = xlsx.xl['workbook.xml'].getElementsByTagName('sheet')[0];
      var clone = source.cloneNode(true);
      clone.setAttribute('name', name);
      clone.setAttribute('sheetId', sheetId);
      clone.setAttribute('r:id','rId3');  // remove hard coding
      xlsx.xl['workbook.xml'].getElementsByTagName('sheets')[0].appendChild(clone);
  

  I added the comment // remove hard coding of the places I think need changing.

  Kevin
• Vkay Posts: 3Questions: 0Answers: 0

  September 2021

  Atlast I found a way with your solution, here

  http://live.datatables.net/kuyayeto/9/edit with the solution given by @you2525