If you can't do what you need to do using ODBC you could use Apache
Jakarta POI (http://jakarta.apache.org/poi/index.html). You can
interface to it using cfobject as it a Java API. As far as I know,
with this API you can pretty much create a complete Excel sheet with
multiple workbook, etc.
Good luck.
Andrew.
----- Original Message -----
From: Adam Haskell <[EMAIL PROTECTED]>
Date: Fri, 3 Sep 2004 13:59:34 -0700
Subject: Re: Parse an uploaded excel spreadsheet?
To: CF-Talk <[EMAIL PROTECTED]>
Create and ODBC connection to an excel file. So long as you save the
file as the same name all the time it should work out ok.
Adam
On Fri, 03 Sep 2004 16:51:17 -0400, Mark Murphy
<[EMAIL PROTECTED]> wrote:
> We have an interesting user requirement to be able to download an
excel spreadsheet from one of our systems (a simple data grid-type
sheet), make changes to the xls, and upload it back to the web server
to have the records automatically added/updated/deleted in one
operation.
>
> I can envision the CF logic to do the add/update/delete processing,
but before I get that far, how can I get CF to query an uploaded
spreadsheet? Isn't there a way to setup a datasource inline in a
cfquery? Or do I have to mess around with createobject() and have
excel installed on the server, etc? Has anyone done this?
>
> Thanks
> -Mark
>
>________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
