How to Download table data as excel sheet using php..?

PHP
1

Guys i’m generating a set of data in a table after som set of calculation… as soon as user clicks save button excel file with that data must be generated for downloading…

What is the php code for that …

guys the data is not retrieved from database…its being displayed after a set of calculation as been performed

Since i dont have any idea ive not posted any related code…sry for that…:sweat:

below is how my table looks like

840×588 37.3 KB

2

You will probably need this:-

1 Like
3

@SamA74…i downloaded the zip file…now what just include that file in my php code…??

4

I’ve not actually used that library myself yet, but it was recommended by @swader (so it can’t be bad).
You will have to read the documentation.
http://phpspreadsheet.readthedocs.io/en/develop/
Then ask if you get stuck.

1 Like
5

Below is the link that allows to download html data in excel format…

1)Include jQuery library and the jQuery table2excel plugin in the Html document.

src=“//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js”
src=“src/jquery.table2excel.js”

  1. Create an ‘Export’ button to export table data to an Excel file manually. Optional.

Export

3)Call the plugin on the table and done.

$(“button”).click(function(){
$(“#table2excel”).table2excel({
// exclude CSS class
exclude: “.noExl”,
name: “Worksheet Name”,
filename: “SomeFile” //do not include extension
});
});

6

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