Export Displayed or Dynamic Html Table to excel

PHP
1

Hello , I have a HTML Table Generating from PHP Code like echo "<table>" etc.
The <td> content is dynamically generated and I want that table to export to excel. I tried using some jQuery but its not working properly.

2

You could try outputting it to a CSV of some other format Excel imports.

3

I searched many of them but they don’t export dynamic data

4

You would need to write the PHP code to export the CSV file.

5

Can you give an example code? Thanks!

6

You can write to a file in php using the fwrite function. Explained here.

7

If the content of the table is loaded with JavaScript you’re not going to be able to do this via crawling the HTML of the page. You will need an alternative method that is considerably more complex. Is there any reason why you can’t just fetch the data from the database and avoid crawling a page altogether.

8

From where and by what means?

9

from temporary tables which are created during script execution

10

The content comes from temporary tables created during php script execution. Its not stored anywhere.

11

I imagine that since it’s a PHP script that is writing the table, it could write the CSV file at the same time.

1 Like
12

It could but I want it to do it when the user wants i.e on button click and it gets downloaded to the users pc

13

The file could be written at the same time the table renders as the page loads, then the page could have a download link to it for the user.

1 Like
14

ninja’d by @SamA74

15

btw I tried a jquery export but the excel file is getting the html tags into it

16

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.