Parse an uploaded excel spreadsheet?

[Mark Murphy]

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]

---