Serving 3582 extensions to the community
Categories
Directory Menu
Login or Register
SQL 2 Excel Pro 
Version
2.2.1 (last update on Nov 4, 2009)
Rating
Compatibility
Votes
10
Favoured
12
License
GPL
Commercial
Type
Views
12012
Date Added
15 June 2009
- On-the-fly, Ajax driven, syntax check of your SQL queries
- Data Grid Plugin enabling you to embed table data inside Joomla content items
- Schedule automatic emails with Excel spreadsheet attachments. Run SQL queries/updates on your database using the built-in Scheduler
- Setup database connections and generate reports from remote databases (Oracle, MySQL, MS SQL, postgreSQL)
- Add arbitrary extra cells with text or formulas to your spreadsheet
- Export in CSV and HTM formats, as well as XLS
- Many more layout and color choices
- Create Parameterized Reports
- Workbook caching for high traffic sites, or for long running SQL queries
- Access to additional plugins and modules such as a cPanel module for easy access to your administrator reports
- Export/Import of Settings. Load your configuration from your development server onto the production server easily.
Sample reports for many popular extensions, such as Acajoom News, BookLibrary, Communicator, Community Builder, DOCman, EasyBook, EventList, Kunena Forum, Jx Jambook, JCollection, Joom!Fish, JomSocial, !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.
....plus much more
v2.2.1 - Nov 3 2009 : Support for Data Grid Plugin added. Embed data grid tables into your Joomla content items.
byBosse on October 13, 2009
Absolutely the best extension so far.
Fantastic support, fast and accurate, tremendous knowledge behind the extension.
One would only wish all extensions to be as good ;-)
Thanks Mats.
Fantastic support, fast and accurate, tremendous knowledge behind the extension.
One would only wish all extensions to be as good ;-)
Thanks Mats.
byswilliford on August 22, 2009
I needed a tool to get a complex report out of SQL and into Excel. I download this just to try and found that not only did it do what I needed in exporting to Excel, scheduling helped me in several other places and well....
The support was awesome! I was a bit lost trying to build my SQL queries and Mats walked me through it completely.
Highly recommend! Thanks for the great tool.
The support was awesome! I was a bit lost trying to build my SQL queries and Mats walked me through it completely.
Highly recommend! Thanks for the great tool.
bysmallparts4all on August 21, 2009
I first tried the free version of SQL 2 Excel which is great! Needed some of the functions that's provided by the Pro version so I decided to purchase it. That's the best spent money in a long time!
I'm using the database connections to pull in data from remote databases all over the company. Everything comes together through our internal support web server. Users love it - I love it!
Then I discovered Schedules. Wow! That feature alone is worth the small price they charge.
And the support is world-class! Better than for software's you pay 1000 times more for. Thanks Mats for this excellent piece of software!
I'm using the database connections to pull in data from remote databases all over the company. Everything comes together through our internal support web server. Users love it - I love it!
Then I discovered Schedules. Wow! That feature alone is worth the small price they charge.
And the support is world-class! Better than for software's you pay 1000 times more for. Thanks Mats for this excellent piece of software!
Amazing component, I have started with 1.0.6 pro version and now 1.7.3, great support !!! The best component for export data.
Thanks Mats
Thanks Mats
bykedmiston on July 29, 2009
This product is pretty handy as it is. Add to that an impressive support structure and you've got a real good solution that is worth paying the small price that's asked for it. Save yourself some time...download this now if you're looking for an easy way to get data to your users without having to provide access straight to the database. And fear not if you run in to problems...ask for help and you'll get it fast!
bykenlyle on July 6, 2009
4.5 stars in 9 reviews as of today for the Free version. Any questions?
Seriously, the Pro version lets you gather data from more than one (the Joomla!) database, which is HUGE, and there is a Scheduler for doing automatic report (XLS) generation and email, and you can put formulas into the generated sheets.
Get it before they wise up and raise the price!
Seriously, the Pro version lets you gather data from more than one (the Joomla!) database, which is HUGE, and there is a Scheduler for doing automatic report (XLS) generation and email, and you can put formulas into the generated sheets.
Get it before they wise up and raise the price!