|
The SQL 2 Excel Pro Data Grid Plugin allows you to embed data from any valid SQL query as a simple HTML table embedded in your article/content. The queries, defined in SQL 2 Excel Worksheets, can be simple, or very complex joining two or more tables, min/max, grouping, roll-up, sorting etc etc. And SQL 2 Excel Pro allows you to setup database connections so the data can even be pulled from remote databases if needed.
Installation
Requirement: SQL 2 Excel Pro v2.2.1 or higher
- Download the Data Grid Plugin from the Members Site
- Install the plugin using the standard Joomla extension installation
- Go to Extension > Plugin Manager and locate the "SQL 2 Excel Pro Data Grid Plugin"
- Enable the "SQL 2 Excel Pro Data Grid Plugin" Plugin
Usage
In any Joomla content item, add the following tags :
{sql2excelgrid}Workbook_ID:Worksheet_ID{/sql2excelgrid}
for example:
{sql2excelgrid}2:3{/sql2excelgrid}
..to display Worksheet ID=3 in Workbook ID=2
The reason you need to specify the Workbook ID is because we may have Workbook parameters which needs to be passed to the Worksheet,
Edit the article and add the tags:
When the article is rendered in the frontend the plugin tags aredynamically replaced with the Worksheet data. Here's an example on what it could look like:
Configuration
You can configure the look and feel of the data grid tables using the Plugin Parameters:
Advanced
The default Workbook parameter values will be used when the SQL query for the Worksheet is evaluated. You can however set the values for your Workbook parameters for the plugin, by using this syntax :
{sql2excelgrid}2:3,MYPARM1=10,MYPARM2=3{/sql2excelgrid}
Note how the values of the MYPARM1 and MYPARM2 workbook parameters values has been defined.
 |
Subscribe to this comment's feed
