Thanks for Choosing to use this Wordpress Plugin for your Excel Sheet generation.

Instruction On How to Use this plugin:

1.Once you download this plugin, please cut the folder "themefile" from this plugin main directory and paste it at some other safe location, as we will use it during setup of this plugin.

2.Now place this plugin folder in Wordpress installation plugin directory and activate this plugin from the wordpress admin side.

3.Now go to your "themefile" folder and copy the file "xlsgen.php" and paste it to the prefered location i.e your root theme installation directory, of course you could place it anywhere in your preferred location in the Wordpress active theme directory, then after that add that page to your Wordpress website from admin side by choosing the template name contained in  "xlsgen.php" file and note the permalink that is generated as we will need this permalink to refer our link to this file. You can use other methods to refer to this file if you know how to do it, but only thing necessary is that, the link should refer to this "xlsgen.php" file correctly. 																																									Alternatively there is a variable called 'xlsTempURL' defined in the cofig.php file that can be assigned the permalink url here. Any thing you use but you should provide a correct link to xlsgen.php file to generate the excel sheet. So to avoid confusion there is a define function in the 'config.php' file that contains a variable named 'xlsTempURL' that contains the value of the url to the xlsgen template file except the root url i.e it's value is the url to it after the main domain name, because for the root url generation we wil be using the site_url function, let me explain with an example. Suppose our site name is http://www.example.com and the 'xlsgen.php' file is having the permalink: http://www.example.com/test/xslgen, then value of the variable xlsTempURL in the config.php will be 'test/xslgen', i hope this makes things clear.

4.Now for creating a link to download the excel sheet we need to provide a query for our database for that we will use a session variable as we cannot pass database table name/database query as parameter from the client side. So please start_session() in the page where you want to create a link to download the excel sheet. The session variable name is "$_SESSION['xlsgentbnm']", assign the query  of the database table to this session variable. After that create a download link, referring to the "xlsgen.php" file. Now your work is done. Once you publish this page with downloadable link, the link will generate the Excel sheet for you. 

5.For querying the database we are using a session variable called: $_SESSION['xlsgentbnm'], this variable contains the query for your database that you want to see in the excel sheet. You can assign a query to this session variable while writing the code above the anchor tag or other link that refers to the template file xlsgen.php.

6.You can have a look at the demo.php file to see how to bring the plugin in action.

NOTE: Before you create a link referring to the "xlsgen.php" file you need to assign the "$_SESSION['xlsgenQuery']" variable to the correct database query. Also note that folder "themefile" contains two files one is the 'xlsgen.php' that was already explained and the other file is 'demo.php' that is just a small demo on how to use this plugin the code.

7.You can have a look at the demo.php file to see how to bring the plugin in action

Thanks for Choosing this plugin.