+4 votes
23 views
How to export an HTML table to Excel with JavaScript?

in Guides by (482k points)
reopened | 23 views

1 Answer

+5 votes
Best answer

Export an HTML table to Excel with JavaScript step by step
Scripts to include
Layout of the table to export
Export the table to HTML
The final HTML code
The definitive JavaScript code
Final result in Excel or XLSX format

➥ Go to the start of the free online Excel Course

  • If you have an HTML document in table format, you can export it to Excel with JavaScript
  • It is not a simple tutorial, which can be done without learning some previous concepts, but it is not as complicated as a beginner might think. It's a matter of following some guidelines

Although many users do not know it, it is possible to generate Office documents, more precisely Excel, with practically any starting element. For example, knowing how to export an HTML table to Excel with JavaScript will allow you to manage new spreadsheet content as you wish, without limits..

As we said, it is perfectly possible to generate an Excel document, with its respective XLSX extension, starting from the content of an HTML table, something that you could come to believe unlikely, doing it by hand.

In the following lines, we are going to show you how to proceed using the TableExport library, which will allow you to export a spreadsheet, reports, tables created by a framework, etc. from the web ..

Export an HTML table to Excel with JavaScript step by step

Scripts to include

Before starting, you will have to download a total of three scripts, the following:

  1. XLSX https://unpkg.com/[email protected]/dist/xlsx.full.min.js
  2. FileSaver https://unpkg.com/[email protected]/FileSaver.min.js
  3. TableExport https://unpkg.com/[email protected]/dist/js/tableexport.min.js

Then, you have to enter them in the head, as follows:

 <head> <! - In this order -> <script src = "./ js / xlsx.full.min.js"> </script> <script src = "./ js / FileSaver.min.js"> </script> <script src = "./ js / tableexport.min.js"> </script> </head> 

Layout of the table to export

image

If you want a TABLE element like the one above, the code should look like this:

 <table id = "table"> <thead> <tr> <th> Language </th> <th> Website </th> <th> Some uses </th> </tr> </thead> <tbody> <tr> <td> PHP </td> <td> php.net </td> <td> Web Applications </td> </tr> <tr> <td> Python </td> <td> python.org </td> <td> Web and desktop applications. Machine learning </td> </tr> <tr> <td> Go </td> <td> golang.org </td> <td> Web and desktop applications </td> </tr> </tbody> </table> 

The initial id, in this case "table", is very important, and will serve you well for the future . Do not forget.

Export the table to HTML

To export the table to HTML, the first thing will be to add a button that allows us to do it, like this:

 <button id = "btnExportar"> Export </button> 

Then, from JavaScript you have to do a recovery using querySelector and, taking advantage of the movement, we are also going to do a reference recovery to the table, so it will look like this:

 const $ btnExportar = document.querySelector ("# btnExportar"), $ table = document.querySelector ("# table"); $ btnExportar.addEventListener ("click", function () { // Here export the table }); 

At this point, the final export code should look like this:

 let tableExport = new TableExport ($ table, { exportButtons: false, // We don't want buttons filename: "My Excel table", // Excel file name sheetname: "My Excel table", // Sheet title }); let data = tableExport.getExportData (); let document preferences = data.table.xlsx; tableExport.export2file (Document preferences.data, Document preferences.mimeType, Document preferences.filename, Document preferences.fileExtension, Document preferences.merges, Document.RTL preferences, Document preferences.sheetname); 

As you can see, there is the option to export the customization elements, export data, etc ..

The final HTML code

 <! DOCTYPE html> <html lang = "es"> <head> <meta charset = "UTF-8"> <meta name = "viewport" content = "width = device-width, initial-scale = 1.0"> <meta http-equiv = "X-UA-Compatible" content = "ie = edge"> <title> Export HTML table to Excel </title> <script src = "./ js / xlsx.full.min.js"> </script> <script src = "./ js / FileSaver.min.js"> </script> <script src = "./ js / tableexport.min.js"> </script> <link rel = "stylesheet" href = "styles.css"> </head> <body> <h1> HTML table to Excel </h1> <p> Export table data from web page to Excel spreadsheet for <a href="//parzibyte.me/blog"> By Parzibyte </a> </p> <button id = "btnExportar"> Export </button> for for <table id = "table"> <thead> <tr> <th> Language </th> <th> Website </th> <th> Some uses </th> </tr> </thead> <tbody> <tr> <td> PHP </td> <td> php.net </td> <td> Web Applications </td> </tr> <tr> <td> Python </td> <td> python.org </td> <td> Web and desktop applications. Machine learning </td> </tr> <tr> <td> islaBit </td> <td> islabit.com </td> <td> Free Excel Courses and Tutorials! ^^ </td> </tr> </tbody> </table> <script src = "./ js / script.js"> </script> </body> </html> 

The definitive JavaScript code

 const $ btnExportar = document.querySelector ("# btnExportar"), $ table = document.querySelector ("# table"); $ btnExportar.addEventListener ("click", function () { let tableExport = new TableExport ($ table, { exportButtons: false, // We don't want buttons filename: "My Excel table", // Excel file name sheetname: "My Excel table", // Sheet title }); let data = tableExport.getExportData (); let document preferences = data.table.xlsx; tableExport.export2file (Document preferences.data, Document preferences.mimeType, Document preferences.filename, Document preferences.fileExtension, Document preferences.merges, Document.RTL preferences, Document preferences.sheetname); }); 

Final result in Excel or XLSX format

image

Over there you have the final result, already in XLSX format , which makes clear how this tutorial works.



by (3m points)

Related questions

+5 votes
1 answer
asked Jun 3, 2021 in Help by backtothefuture (482k points) | 35 views
+3 votes
1 answer
asked May 24, 2020 in Help by backtothefuture (482k points) | 163 views
+5 votes
1 answer
asked Sep 19, 2019 in Office by backtothefuture (482k points) | 161 views
+4 votes
1 answer
asked Feb 24 in Guides by backtothefuture (482k points) | 13 views
+5 votes
1 answer
asked Jan 6 in Guides by backtothefuture (482k points) | 15 views
Sponsored articles cost $40 per post. You can contact us via Feedback
9,253 questions
9,362 answers
472 comments
2 users