>- see footer for list info -<
You can also use POI from Apache foundation to do native Excel
writing/reading.



-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Duncan Cumming
Sent: 26 October 2005 13:47
To: [email protected]
Subject: Re: [CF-Dev] Excel Datasource

>- see footer for list info -<
CFComet is no longer up, but someone has nicely mirrored it.  Have a look
at:
http://cfregex.com/cfcomet/excel/


Duncan Cumming
New Media Developer
Customer Relations Management / Education
Fife Council
700 4105 / 01592 414105

>>> [EMAIL PROTECTED] 26/10/2005 11:38 >>>
>- see footer for list info -<
I have a requirement where the client stores lots of financial data on a 
spreadsheet.

I want to be able to use this spreadsheet as a datasource.

Here are the concearns. The spreadsheet changes quaterly. Sometimes in its 
physical structure i.e. column names won't be the same. The client wants to 
have an easy mechanism to upload the spreadsheet and the application does 
the rest.

So.....

I was thinking that the client could upload the spreadsheet via a backend 
system. CF would then need to create an on the fly datasource to this 
spreadsheet and be able to read all of the column headings etc ..... I have 
no idea how to even start this one....?

Can this even be done?
Can anyone point me in the direction of some reading around this ...?

Regards - Paul


_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo 

--

>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<


**********************************************************************
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed
and should not be disclosed to any other party. 
If you have received this email in error please notify your system manager
and the sender of this message.

This email message has been swept for the presence of computer viruses but
no guarantee is given that this e-mail message and any attachments are free
from viruses.

Fife Council
Tel: +44 (0) 1592 414141
**********************************************************************
_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo

--

>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
_______________________________________________

For details on ALL mailing lists and for joining or leaving lists, go to 
http://list.cfdeveloper.co.uk/mailman/listinfo

--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<

Reply via email to