Export Report To Excel With Multiple Tabs

I need to create a fairly simple report that exports into excel. It is meeting information and its venues. These venues sometimes can be in 1 "zone" or upto 20 "zones". Zones are internal ways that we identify them. Each "zone will need to be exported into its own sheet in a workbook. So for example, a meeting might have 5 zones. When I export the excel file, you will see 5 tabs at the bottom of the worksheet that says Zone 1, Zone 2, Zone 3, etc

The information in the worksheet would be items like, venue name, venue location, venue date, venue attendees, venue provider, all the stuff that is in the database.

Here is an example of a query with that information.

<cfquery name="x" datasource="#request.data_source#" username="#request.db_un#" password="#request.db_pw#">

SELECT *, meeting_venue_status.venue_status_name, meeting_venue_status.venue_status_color

FROM meeting_venues INNER JOIN

meeting_venue_status ON meeting_venues.venue_status = meeting_venue_status.venue_status_id

WHERE (venue_active = 1) AND (venue_meeting_id = #Val(attributes.meeting_id)#)

Order By venue_zone asc, venue_meeting_date ASC


In case anyone is familiar with the CFX tag.. I do own a license to this if it makes it easier....

[url removed, login to view];ProductID=cfx_excel

I am willing to pay up to $40 for help on this and need it within 1-2 days

Skills: Cold Fusion

See more: coldfusion export excel tabs, zones, www excel, we excel, excel &, c# report, asc it, export project excel tab, coldfusion tabs excel, multiple tabs excel coldfusion, cfx_excel, sql multiple tab excelsheets, coldfusion export excel, export excel coldfusion, coldfusion excel export cfx excel, coldfusion excel report multi tab, cfx excel, n excel, report example, need excel help, venue, val , report from excel, join with you, IT report

About the Employer:
( 1 review ) Hamilton Square, United States

Project ID: #229332

3 freelancers are bidding on average $38 for this job


details via pm

$40 USD in 2 days
(21 Reviews)

I can provide the solution you need. If you can provide me with the specifics on how you want your data queried for each excel sheet, and the names of the sheets you will require.

$40 USD in 1 day
(4 Reviews)

See My personal message.

$35 USD in 1 day
(0 Reviews)