M
MichaelL
Hi All,
This is a request for advice on Excel and data connectivity over the
web.
I am looking to add a feature to a web site (& web service) that has a
large but simple data set (imagine 5000 rows of data). I want users
to be able to download this dataset to their client machine (in some
form such as xml or even csv) where they can manipulate this data
locally, and then _upload_ this modified data back to the web site.
One unsatisfactory approach to doing this is to present the user with
a url where they can download the data, modify it and save it to a
local file, then upload this file to the web site. However, requiring
the user to mess about with local files like this is going to be error
prone and is not ideal.
Instead I'd hoped to download/import the data into excel using some
kind of data connection (such as an .iqy file), but having made the
changes to the data then allow the user to save the data back to the
web site directly.
Getting the data into Excel appears to be easy; but I can't see a way
to republish the data back to the web site/service. Note that I'm
targeting Excel 2007, and the web site is written in Java (using JSF
etc) and this is not changeable.
Any thoughts or suggestions on how to do this would be much
appreciated.
Thanks in advance,
Michael Lewis
(Solution Architect, Thomson Reuters)
This is a request for advice on Excel and data connectivity over the
web.
I am looking to add a feature to a web site (& web service) that has a
large but simple data set (imagine 5000 rows of data). I want users
to be able to download this dataset to their client machine (in some
form such as xml or even csv) where they can manipulate this data
locally, and then _upload_ this modified data back to the web site.
One unsatisfactory approach to doing this is to present the user with
a url where they can download the data, modify it and save it to a
local file, then upload this file to the web site. However, requiring
the user to mess about with local files like this is going to be error
prone and is not ideal.
Instead I'd hoped to download/import the data into excel using some
kind of data connection (such as an .iqy file), but having made the
changes to the data then allow the user to save the data back to the
web site directly.
Getting the data into Excel appears to be easy; but I can't see a way
to republish the data back to the web site/service. Note that I'm
targeting Excel 2007, and the web site is written in Java (using JSF
etc) and this is not changeable.
Any thoughts or suggestions on how to do this would be much
appreciated.
Thanks in advance,
Michael Lewis
(Solution Architect, Thomson Reuters)