Javascript Many tables to excel (rows/columns size can be different)

Question

What I want to do is to find all tables in my page:

$('table')

In jQuery, and then to convert all of them to one excel file and one sheet. The tables should appear in the same order like they appear in the original page, with an empty excel row between them.

I have found already many answers about converting a single table to excel or two with same rows/columns size, but I didn't find any clue for what I'm trying to do.

This is what I used so far: http://jsfiddle.net/cmewv/537

http://stackoverflow.com/questions/17126453/html-table-to-excel-javascript — Michael Dennis, Apr 08 '17 at 16:04
questions should be self contained. Edit question with particulars — charlietfl, Apr 08 '17 at 16:14

score 0 · Accepted Answer · answered Apr 08 '17 at 19:11

Here's my solution, appending all the tables to one table. Ugly - but works.

$('body').append('<table style="display:none;" id="test"></table>');

$('table').each(function() {
    $('#test').append($(this).html()); 
    $('#test').append('<tr><td/></tr>');
  });

$('table#test').remove();

And then just to use any table to excel converter code approach (before doing last command).

Javascript Many tables to excel (rows/columns size can be different)

1 Answers1