SQL 2 Excel -> Component - Joomla-R-Us

Main Menu

Latest Downloads

Downloads

Component

sql2excel_icon_trans SQL 2 Excel is a Joomla 1.5 Component which allows you to deliver data from your database directly to your users as downloadable Excel files. Write any valid SQL query in the configuration of this module. The query is run when a user clicks the link and the current information in the database is delivered to the users browser as an Excel file.

The component backend allows you to assemble multiple worksheets into one single downloadable Excel Workbook. You can control access to sections, categories, workbooks and even down to worksheet level. Your configurations are stored in database tables. You will not loose your configurations when you upgrade SQL 2 Excel in the future. And the best of all, it's free!

SQL 2 Excel is partly based on:

Phoca Download by Phoca. Thanks Jan!
Spreadsheet::WriteExcel: A library for generating Excel Spreadsheets, Copyright (C) 2002 Xavier Noguer xnoguer@rezebra.com.

Set as favorite

Bookmark

Email this

Comments (8) add comment

Subscribe to this comment's feed

Waldemar said:

	... Great stuff and progress! Would be nice if you can set up reports like this with different cron jobs and also to different email to be sent! Thanks!
	report abuse vote down vote up

March 11, 2009
Votes: +0

Mats @ Joomla-R-Us said:

	... @Waldemar: I'm looking into email scheduling for the Pro version.
	report abuse vote down vote up

May 09, 2009
Votes: +0

Mats @ Joomla-R-Us said:

	... @Waldemar: SQL 2 Excel Pro now has a built-in Scheduler which allows you to schedule automatic emails with Excel Spreadsheets as attachments (or as links).
	report abuse vote down vote up

June 07, 2009
Votes: +0

suhu said:

	... nice and very helpfull
	report abuse vote down vote up

June 15, 2009
Votes: +0

albs said:

	... Suggestion: what about integration with EventList? For example, one could click on an event, and there would be a button for "download attendance information as spreadsheet". It would be great to be able to retrieve reports for attendance over a period of time (such as attendance for training in a sport season) but I think I can do that without integration Nice tool!
	report abuse vote down vote up

July 12, 2009
Votes: +1

albs said:

	... Whoops I think I've found just the tool!
	report abuse vote down vote up

July 12, 2009
Votes: +0

albs said:

	... Hi mate, Just played with the EventList query - my suggestion still stands... Thanks for making the free version available! Albert
	report abuse vote down vote up

July 12, 2009
Votes: +0

Mats @ Joomla-R-Us said:

...
There's a sample EventList report that you can download on the Sample Reports page.

But you seem to have figured it out already

Great!

Regarding the tighter integration. EventList doesn't seem to have open plugin standard that third party developers like me can leverage to add functionality. You will have to take it up with the EventList developers and see if they can do an add-on to EventList.

SQL 2 Excel Pro does have a feature called "Workbook Parameters" which allows you to create parametrized reports. For instance you can create a SQL-based parameter which lists your Events. The user will be prompted to select event when clicking on the download link. You can the build a report which only returns the records/users etc for the selected event.

July 12, 2009
Votes: +0

Write comment

Name

Comment

smaller | bigger

I have read and agree to the Terms of Usage.

security image
Write the displayed characters

Design by augs-burg.de & go-vista.de

The Joomla!(R) name is used under a limited license from Open Source Matters in the United States and other countries. http://Joomla-R-Us.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.