SQL 2 Excel
Version
2.1.3 (last update on Nov 22, 2010)
Rating
Compatibility
Votes
Favoured
79
License
GPLv2 or later
Non-Commercial
Type
Views
99224
Date Added
19 February 2009
You can publish your reports in three different ways:
- Download them in the Joomla Administrator backend
- Publish the SQL 2 Excel Module to one or more pages and let users download the spreadsheets through the module links
- Publish the Sections / Categories list view to a menu and let users browse your sections/categories to locate desired report(s)
Use SQL 2 Excel for all your reporting needs. Deliver dynamic reports to your users, export table data from Joomla, get usage statistics or just a quick data dump for debugging purpose etc.
Sample reports for many popular extensions, such as Acajoom News, BookLibrary, Communicator, Community Builder, DOCman, EasyBook, EventList, Kunena Forum, Jx Jambook, JCollection, JomSocial, Joom!Fish, !JoomlaComment, Jom Comment, Lyften Bloggie, Media Library, Phoca Download, Phoca Gallery, Qcontacts, RD Autos, RokDownloads, RSMonials, SimpleCaddy, SOBI2, Teamlog, Virtuemart, WebAmoeba Tickets System, as well as for the standard Joomla content and users.
v2.1.3 - Nov 21 2010 : Bug fix: sys_get_temp_dir function not defined in older PHP versions.
v2.1.2 - Sep 30 2010 : Bug fix: Blank spreadsheet created on some servers
Added: Showing write permission on temp folders in System Information
v2.1.1 - Sep 16 2010 : Updated Excel Writer Library. Fixes problems on servers with newer PHP versions. Excel files now iPod/iPhone/iPad compatible
v2.1.0 - Apr 17 2010 : Added repeatable print headers and footers to Worksheets
v2.0.3 - Mar 19 2010 : Bug fix: Warning messages when no records returned from query on some servers
Improved: No records message written after header
v2.0.2 - Mar 9 2010 : Bug fix: Javascript error on (Admin) Worksheet page affecting some servers
v2.0.1 - Mar 5 2010 : Added support for SET statements before the main SQL query
v2.0.0 - Feb 2 2010 : Added Section and Category views for menu assigment
Added setting for Download Button (Show/Hide) in Preview in each Workbook
Bug fix: HTML problem in Preview
Bug fix: Download Message for Preview
Bug fix: CSS issues fixed
Images
The really satisfied a need for my users. Easy to use right out of the box - just paste in your SQL code. And the developer has been really quick and accommodating for addition of suggested new features.
The module I was looking for to allow extracting some table-contents in the frontend as an excel sheet!
Easy to use. You only need some SQL-Knowhow, that's all!
Seems not te be the final version, can be improved, but makes what you want it to do!
THANKS FOR THE GOOD MODULE!
... and for the very quick support via the forum!
Easy to use. You only need some SQL-Knowhow, that's all!
Seems not te be the final version, can be improved, but makes what you want it to do!
THANKS FOR THE GOOD MODULE!
... and for the very quick support via the forum!
Page 2 of 2