With the widespread use of spreadsheets in business management and data analysis, the demand for converting web tables into Excel format is also increasing. The powerful function and cross-platform characteristics of JavaScript make it the best choice to implement this function. Here is a method to use JavaScript to convert web tables into Excel.
1.Introduce JavaScript library
First you need to introduce the necessary JavaScript library-SheetJS and FileSaver. SheetJS is a powerful spreadsheet processing library that can read and write Excel, CSV and other spreadsheet formats. The FileSaver library provides a simple way to save HTML or binary data generated from the browser. Add the following code to the HTML file to introduce these two libraries.
<script src="https://cdn.jsdelivr.net/npm/xlsx/dist/xlsx.full.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/FileSaver.js/1.3.8/FileSaver.min.js"></script>
2. Create table HTML code
Next, you need to create a table in the HTML page to display data. Here we create a simple table with header and data.
<table id="table"> <thead> <tr> <th>姓名</th> <th>年龄</th> <th>性别</th> </tr> </thead> <tbody> <tr> <td>张三</td> <td>30</td> <td>男</td> </tr> <tr> <td>李四</td> <td>25</td> <td>女</td> </tr> <tr> <td>王五</td> <td>40</td> <td>男</td> </tr> </tbody> </table>
3. Write JavaScript code
Now we start writing JavaScript code to realize the function of converting the table into Excel.
First you need to get the table, use the document.getElementById() method to get the table element with the id "table".
const table = document.getElementById('table');
Then get the number of rows and columns in the table through table.rows, and create an empty array to save the table data.
const rowLength = table.rows.length; const colLength = table.rows[0].cells.length; const data = [];
Then you need to traverse all the rows and columns in the table and store the cell text data in the data array. This is achieved using a double loop.
for (let i = 0; i < rowLength; i++) { const rowData = []; for (let j = 0; j < colLength; j++) { rowData.push(table.rows[i].cells[j].textContent); } data.push(rowData); }
Finally, use the SheetJS library to convert the data into binary data in Excel format, and use the FileSaver library to save it locally. This is implemented using the XLSX.writeFile() method of SheetJS.
const wb = XLSX.utils.book_new(); const ws = XLSX.utils.aoa_to_sheet(data); XLSX.utils.book_append_sheet(wb, ws, 'Sheet1'); XLSX.writeFile(wb, 'table.xlsx');
The complete JavaScript code is as follows:
const table = document.getElementById('table'); const rowLength = table.rows.length; const colLength = table.rows[0].cells.length; const data = []; for (let i = 0; i < rowLength; i++) { const rowData = []; for (let j = 0; j < colLength; j++) { rowData.push(table.rows[i].cells[j].textContent); } data.push(rowData); } const wb = XLSX.utils.book_new(); const ws = XLSX.utils.aoa_to_sheet(data); XLSX.utils.book_append_sheet(wb, ws, 'Sheet1'); XLSX.writeFile(wb, 'table.xlsx');
4. Test the conversion result
After completing the above steps, open the HTML file in the browser and click the button, it will automatically Download an Excel file named "table.xlsx".
Through the above steps, we have successfully converted the web table into Excel format. This method is based on JavaScript, is simple to implement, highly efficient, and can be cross-platform. It is very suitable for batch processing of web forms. It is undoubtedly a good tool for business managers and data analysts.
The above is the detailed content of How to convert web table to Excel using javascript. For more information, please follow other related articles on the PHP Chinese website!