Hi, I have a general question about Excel programming since I haven't done any in this area. What I'm trying to do is I want to have 3-tier application where presentation layer as Excel worksheet, application layer using C#, and MSSql database as my database layer. What I want to achieve here is that I want to have Excel program itself as my user interface interactively reflects data to my application layer in C#. I can read in an Excel worksheet file using browser control, but I want to have data control over the worksheet, in other words, if anything changes in the worksheet, I want to know what has been changed and eventually store the data into my database. Is this possible? Thanks.
Yes Check out VSTO, or just automate Excel cheers Simon "pak20116" wrote in message news:A2600649-250E-4521-9F5B-16D42A3F4DA0@microsoft.com... > Hi, > > I have a general question about Excel programming since I haven't done any > in this area. What I'm trying to do is I want to have 3-tier application > where presentation layer as Excel worksheet, application layer using C#, > and > MSSql database as my database layer. What I want to achieve here is that > I > want to have Excel program itself as my user interface interactively > reflects > data to my application layer in C#. > I can read in an Excel worksheet file using browser control, but I want to > have data control over the worksheet, in other words, if anything changes > in > the worksheet, I want to know what has been changed and eventually store > the > data into my database. > > Is this possible? > > Thanks. >
