Examples and code:

Basic Table



Rank Name City State Section District Points
1 Small, Steve New York NY Eastern Metropolitan Region 378
2 Novello, Rodolfo Lawrence NY Eastern Long Island Region 223
3 O'Neill, Jim Philmont NY Eastern Northern Region 192
4 Sobong, Emmanuel River Edge NJ Eastern New Jersey Region 162
5 Stewart, Cliff Bridgewater NJ Eastern New Jersey Region 132
6 Erskine, Ronald G Ridgewood NJ Eastern New Jersey Region 126
6 Levine, Max West Sand Lake NY Eastern Northern Region 126
6 Warren, Paul Schenectady NY Eastern Northern Region 126
9 Fischbach, David Prt Washingtn NY Eastern Long Island Region 97
9 Lai, Ben Bridgewater NJ Eastern New Jersey Region 97
11 Gitterman, Matthew Bridgewater NJ Eastern New Jersey Region 96
11 Kalina, Jonathan Fair Lawn NJ Eastern New Jersey Region 96
11 Elfant, Scott Paramus NJ Eastern New Jersey Region 96
14 Salandy, John East Orange NJ Eastern New Jersey Region 81
15 Sendich, Sadik Staten Island NY Eastern Metropolitan Region 66
16 Grey, James Westwood NJ Eastern New Jersey Region 41
16 Wirstrom, Robert Upper Saddle River NJ Eastern New Jersey Region 41
16 Prevost, Christopher Hoboken NJ Eastern New Jersey Region 41
16 Koch, Vladimir Cresskill NJ Eastern New Jersey Region 41
20 bullaro, joseph Great Neck NY Eastern Long Island Region 6
21 Scarpati, Steven Basking Ridge NJ Eastern New Jersey Region 2
21 MIRZA, SHAHZEB Jackson heights NY Eastern Metropolitan Region 2
21 Voellmicke, Craig New York NY Eastern Metropolitan Region 2
24 Sulsky, Ben Cornwall NY Eastern Southern Region 1
24 Jasnosz, Michael Ridgewood NJ Eastern New Jersey Region 1
24 PEREZ, JACOB Haworth NJ Eastern New Jersey Region 1
24 Gonzalez, Christopher North Bergen NJ Eastern New Jersey Region 1
24 Margolin, Ken East Brunswick NJ Eastern New Jersey Region 1
24 Watson, Michael Manville NJ Eastern New Jersey Region 1
24 Garbisch, Leif Ghent NY Eastern Northern Region 1
24 Shkop, Sergey Ridgewood NJ Eastern New Jersey Region 1
24 Honore, Daniel Albany NY Eastern Northern Region 1
24 Israel, Matthew Great Neck NY Eastern Long Island Region 1
24 Chung, Dong-Ha Delmar NY Eastern Northern Region 1
24 Auler, Robert Oswego NY Eastern Western Region 1
24 Killebrew, Steve Ridgewood NJ Eastern New Jersey Region 1
24 Mehringer, Daniel Boyd Middletown NJ Eastern New Jersey Region 1

Code:

$("#generate-excel-basic").click(function () {
  excel = new ExcelGen({
    "src_id": "basic_table",
    "show_header": true,
    "type": "table"
  });
  excel.generate();
});



Formatted Column Table



ID Product Quantity Amount Purchase Date
1 Bottled Water 1000 3.49 06/26/2017
2 Microsoft Surface Book 2 2341.44 07/04/2017
3 Microsoft Surface Arc Mouse 4 86.99 07/06/2017
4 Long-sleeve Shirt 7 20.23 01/02/2018

Code:

$("#generate-excel-formatted").click(function () {
  excel = new ExcelGen({
    "src_id": "formatted_table",
    "show_header": true,
    "type": "table",
    "column_formats": ["1", "1", "4", "6", "18"]
  });
  excel.generate();
});



CSV Output



Ranking
Move
Player
Age
Points
Tourn Played
Points Dropping
Next Best
1
Rafael Nadal 31 9,760 17 0 0
2
Roger Federer 36 9,605 17 0 0
3
Marin Cilic 29 4,960 22 0 0
4
Grigor Dimitrov 26 4,630 23 250 45
5
Alexander Zverev 20 4,610 25 250 90
6
Dominic Thiem 24 4,060 26 0 0
7
David Goffin 27 3,460 25 150 45
8
Jack Sock 25 2,880 22 0 0
9
Juan Martin del Potro 29 2,815 20 0 0
10
Pablo Carreno Busta 26 2,705 25 0 0
11
Kevin Anderson 31 2,620 23 0 0
12
Sam Querrey 30 2,490 23 0 0
13
Novak Djokovic 30 2,470 15 0 0
14
Nick Kyrgios 22 2,395 20 0 0
15
Stan Wawrinka 32 2,385 14 0 0
16
Tomas Berdych 32 2,320 19 0 0
17
Lucas Pouille 23 2,235 23 0 0
18
John Isner 32 2,230 24 0 0
19
Jo-Wilfried Tsonga 32 2,050 19 90 10
20
Andy Murray 30 1,960 15 0 0
21
Albert Ramos-Vinolas 30 1,925 30 90 45
22
Fabio Fognini 30 1,850 24 0 0
23
Roberto Bautista Agut 29 1,845 25 0 0
24
Diego Schwartzman 25 1,810 27 0 0
25
Adrian Mannarino 29 1,670 27 0 0
26
Kyle Edmund 23 1,667 26 0 0
27
Kei Nishikori 28 1,655 20 0 0
28
Gilles Muller 34 1,535 22 0 0
29
Hyeon Chung 21 1,472 21 0 0
30
Damir Dzumhur 25 1,471 29 0 0
31
Milos Raonic 27 1,400 20 0 0
32
Pablo Cuevas 32 1,380 25 0 0
33
Richard Gasquet 31 1,375 22 150 45
34
Alexandr Dolgopolov 29 1,341 24 0 0
35
1
Philipp Kohlschreiber 34 1,335 21 0 0
36
1
Andrey Rublev 20 1,310 21 0 0
37
Feliciano Lopez 36 1,295 26 0 0
38
Filip Krajinovic 25 1,283 27 0 0
39
David Ferrer 35 1,280 22 0 0
40
Fernando Verdasco 34 1,260 26 0 0
41
Yuichi Sugita 29 1,235 26 0 0
42
Robin Haase 30 1,175 30 0 0
43
1
Gael Monfils 31 1,130 18 0 0
44
1
Benoit Paire 28 1,110 33 90 55
45
2
Ryan Harrison 25 1,105 25 0 0
46
Paolo Lorenzi 36 1,085 34 150 20
47
Borna Coric 21 1,036 28 0 0
48
Denis Shapovalov 18 1,031 24 0 0
49
Karen Khachanov 21 1,030 27 0 0
50
Steve Johnson 28 975 26 0 0
51
Leonardo Mayer 30 974 21 0 0
52
Aljaz Bedene 28 968 22 0 0
53
Mischa Zverev 30 952 31 0 0
54
1
Tennys Sandgren 26 928 32 0 0
55
1
Julien Benneteau 36 923 19 12 0
56
Daniil Medvedev 21 919 26 45 20
57
Nikoloz Basilashvili 25 916 29 90 10
58
Jan-Lennard Struff 27 905 32 0 0
59
Jared Donaldson 21 878 27 0 0
60
1
Guido Pella 27 864 24 0 0
61
1
Jiri Vesely 24 850 26 0 0
62
1
Marton Fucsovics 25 844 25 48 10
63
3
Peter Gojowczyk 28 816 21 0 0
64
Gilles Simon 33 815 27 0 0
65
Donald Young 28 781 24 0 0
66
Horacio Zeballos 32 768 29 0 0
67
Viktor Troicki 31 755 28 45 0
68
Joao Sousa 28 755 30 0 0
69
Guillermo Garcia-Lopez 34 755 29 0 0
70
Federico Delbonis 27 755 20 0 0
71
Evgeny Donskoy 27 739 28 0 0
72
Florian Mayer 34 733 21 0 0
73
Mikhail Kukushkin 30 730 25 8 6
74
1
Denis Istomin 31 713 23 0 0
75
1
Matthew Ebden 30 712 21 20 5
76
1
Pierre-Hugues Herbert 26 690 22 20 0
77
1
Andreas Seppi 33 686 26 20 10
78
5
Stefanos Tsitsipas 19 678 30 0 0
79
Thomas Fabbiano 28 676 27 0 0
80
Nicolas Kicker 25 674 28 20 6
81
Yen-Hsun Lu 34 674 22 0 0
82
Maximilian Marterer 22 669 29 12 8
83
7
Taylor Fritz 20 669 26 0 0
84
Dusan Lajovic 27 652 26 0 0
85
Vasek Pospisil 27 648 25 55 10
86
Victor Estrella Burgos 37 642 26 250 0
87
Cedrik-Marcel Stebe 27 640 21 32 0
88
Laslo Djere 22 626 27 0 0
89
Radu Albot 28 618 30 20 10
90
Ivo Karlovic 38 615 22 0 0
91
Jeremy Chardy 30 605 24 45 20
92
Mikhail Youzhny 35 604 26 20 8
93
1
Marius Copil 27 596 25 15 6
94
1
Frances Tiafoe 20 586 26 17 0
95
Nicolas Jarry 22 557 25 0 0
96
Lukas Lacko 30 551 25 0 0
97
Dudi Sela 32 550 23 0 0
98
Gerald Melzer 27 545 22 20 0
99
Marco Cecchinato 25 543 31 0 0
100
Taro Daniel 25 539 26 0 0

Code:

$("#generate-csv").click(function () {
  excel = new ExcelGen({
    "file_name": "output.csv",
    "src_id": "csv_table",
    "show_header": true,
    "format": "csv",
  });
  excel.generate();
});



Exlude Columns and DOM Source Input



ID Name Location Favorite Colour
1 Enkeleda Cuko NY, Albania Blue
2 Paul Warren NY, USA Orange
3 Marko Fier, Albania Red

Code:

var myTable = $("#exclude_table"); $("#generate-exclude").click(function () {
  excel = new ExcelGen({
    "file_name": "output.xlsx",
    "src": myTable,
    "show_header": true,
    "exclude_selector": ".xl_none",
  });
  excel.generate();
});