This content has been marked as final. Show 4 replies
Consider making the Excel spreadsheet a datasource. That way, you can save an updated spreadsheet, run your ColdFusion app and query the spreadsheet.
Sorry, but I'm talking about client-side Excel. When saving, it opens the save-to dialogue and shows the webserver-location.
We tried using Excel as ODBC-datasource, never again ... Excel guesses the datatype of columns by scanning the first 20 rows ...the 20 is adjustable but still not usable for us.
Ideas, questions, solutions, popcorn anyone?
I've never used MS Sharepoint but are you talking about something like this...
If you do find a freeware, please let us know!
I guess one alternative might be to have your users make their changes locally
and then upload their changes to the webserver. You would then write code
to read/parse/datasource/etc this .xls. Or you could leave it as is and the next
time someone wants the file, send them the version that was uploaded last.
I know it's a really ugly hack so please respond back with how you settled on