The SQL 2 Excel component allows you to define multiple Worksheets based on SQL queries, then assemble the desired Worksheets into a single Excel Workbook.

You can download the Workbook directly from the Joomla backend. You don't have to make these spreadsheets available in the frontend if you don't want to. You can use it as an administrator's tool if you so desire.

We don't have any live demo of the backend interface, buit please see the screenshots below. You can always Download and try it out for yourself.

Screenshots from the SQL 2 Excel Component backend

Click on the tumbnails to view high resolution images.

Back to SQL 2 Excel Demo

Comments (9)

Subscribe to this comment's feed

Mike said:

	... I can't seem to find a way to download from the back end. How do I achieve it?
	report abuse vote down vote up

October 02, 2009
Votes: +2

Mats @ Joomla-R_Us said:

	... @Mike: In the backend, create one or more Worksheets. Then create a Workbook, and add your Worksheet(s). You can download the Workbooks in the backend using the "Download" links which are located on the right hand side of the Workbook list in the backend.
	report abuse vote down vote up

October 02, 2009
Votes: +1

Robert Duke said:

	... Hope it works in native all pic is with legacy plg Is it possible to set up a cron job with different emails to send reports automatically like report 1 cron job 1 send email to person a + admin email report 2 cron job 2 send email to person b + admin email is this possible? rdgs
	report abuse vote down vote up

November 06, 2009
Votes: +0

Mats @ Joomla-R-Us said:

... @Robert Duke: Yes it does work in Native 1.5 (and in Legacy Mode). You setup one cron job which triggers the schedule handler. You can then setup as many schedules that you want in SQL 2 Excel. One schedule can sen emails to one person, another schedule sends two other reports to a group of persons and so on... You can also use rule based execution on these schedules. For example, you only send out a specific schedule when you have got more than 1000 hits on your website the last day etc. You can also use rules to define to run certain schedules at certain days of the month/week, or hours of the day etc etc.. More info about the scheduler: http://joomla-r-us.com/faq/31-...-scheduler -Mats

report abuse vote down vote up

November 07, 2009
Votes: +0

JtB said:

	... I am using chrono forms and need an SQL to Excel program that will take all data, from user forms, and convert to an Excel spreadsheet...does this program do that?
	report abuse vote down vote up

February 16, 2010
Votes: -1

Mats @ Joomla-R-Us said:

... @JtB: SQL 2 Excel can generate Excel spreadsheets from ANY data that you have in your database. I don't have Chrono Forms, but I assume it stores the submissions into one or more database tables. If that's the case, then you can use SQL 2 Excel to generate Excel spreadsheets with the data that was submitted through Chrono Forms. You will however need to write one or more SQL queries to grab the data that you need.

report abuse vote down vote up

February 16, 2010
Votes: +0

JtB said:

	... thanks so much for the prompt response how do I determine what the correct SQL queries are to grab the data from chrono forms? any ideas? again, thanks so much!
	report abuse vote down vote up

February 16, 2010
Votes: +0

Mats @ Joomla-R-Us said:

	... @JtB: Well, which SQL query to use depends on how you configured ChronoForms I assume. Which form data that you want to grab, which fields you have defined and which data you want to display in the Excel spreadsheet and so on. You have to look at the database tables, and figure out how the data is stored, then write a SQL query that grabs the info that you want. -Mats
	report abuse vote down vote up

February 16, 2010
Votes: +0

JtB said:

	... perfect, thanks again so much tremendous support!!
	report abuse vote down vote up

February 16, 2010
Votes: +0