Add Excel worksheet to form ?

[f_n_d]

Hi I am working on a project where the user enters data and i do the calculations. I need a way to organize a tabular form of entering the data, something like an excel worksheet. Would really appreciate any suggestions.

[Dan Neely]

Try this container. It supports almost every excel feature except change tracking. The demo was written in vb6, and will need a bit of work to port to .net. Based on my own searching, and several other recent requests for the same in .net usegroups I think it's the best solution available. http://support.microsoft.com/default.aspx?scid=kb;en-us;311765

[f_n_d]

i did, and i was able to add a Framer Control where the user can open an excel document. how can i just add an excel worksheet without the Framer Control?

[Dan Neely]

I don't think you can. The control holds the sheet. If you don't need menu support you can load the SS using a webbrower control, or if you only need a very limited ammount of functionality you can use the excel COM control. IMO both of those approaches stink. The framer control's not perfect, but afaik short of writing your own it's the best solution available.

[Dan Neely]

Correction to my previous post. You can turn off the controls titlebar and border via the Titlebar and Border Style properies. If you do that and place the control as large as the form you can make it's presence all but invisible. I don't know how, or if you could merge menus if you needed to add a custom one for the rest of your app.

[f_n_d]

Thanx, that's much better :D