Hi,
I'm researching how I can :
1- dynamically generate an Excel spreadsheet by querying a database on
an ASP page
* I understand how to do this
2- open this spreadsheet by a user (client side)
* I understand how to do this
3- allow this user to apply changes
* that's done via Excel.
4- post the changes (if any) back to my database
I am aware of the OWC and Excel objects I have at my disposal. I also
read an article how to query an Excel spreadsheet. This requires me to
1) define labels on the first row and
2) define a range I'd like to query.
My challenge is that users might add rows to the spreadsheet or even
insert new columns. In addition, the spreadsheet they're updating is
first generated by my ASP page. Hence, how can I dynamically add this
range to the generated spreadsheet (or could I define a 'template'
spreadsheet and use this each time I dynamically populate my
spreadsheet?
I guess I'm looking for a generic way of importing an entire worksheet
and then have my asp page parse and validate it.
Could anyone give me some pointers for #4?
I appreciate your help.
JV