Have a look at http://www.cfcomet.com/cfcomet/ its a great resource site
for cf and integration for ms office products.
enjoy
Jerry Staple
Web Application Developer
Certified Coldfusion (5.0) Developer
Head Office
133-137 Lisburn Road, Belfast
Northern Ireland BT9 7AG
T +44 (0) 28 9022 3224
F +44 (0) 28 9022 3223
E [EMAIL PROTECTED]
W www.biznet-solutions.com
-----Original Message-----
From: Michael Kear [mailto:[EMAIL PROTECTED]]
Sent: 03 April 2002 08:23
To: CF-Talk
Subject: Exporting data to Excel spreadsheet
At one of my clients, the content providers each look after an allocated
part of the data used for displaying information on the web site. They
want to be able to export their data to a spreadsheet so they can review
it and update it off line. These are not IT people but experts in their
various consumer fields. They want me to put a button in their admin
areas for each category of comsumer data so it will export the data for
them automatically. I was going to do it this way and I wondered if
there
was a better way:
(1) Have a spreadsheet already attached to CF as a datasource.
(2) Use a CFQuery to delete all the records in that datasource.
(3) CFQUERY the SQL7 table the content provider wants to export
(4) loop through the query, inserting the data into the (now blank)
spreadsheet.
(5) Use CFMail to email the spreadsheet to the user (getting their
email
address from their logon details).
I seem to remember a function or a tag that output the results of a
query
into spreadsheet format but I can't find any reference to it any more.
Can anyone enlighten me?
Is this the easiest way? Will CFMail be able to send the spread sheet
or
will I need to unlock it from the server first? in which case, how can i
do that automatically?
Cheers,
Mike Kear
AFP Webworks,
Windsor, NSW, Australia
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
