Using Excel sheets

[Igloo]

Hi guys, I have a big question about using excel sheets in a vb.net application. Ok heres the deal, I need to use the excel sheets in a silent way in my app. What I mean by that is the fact that The sheets must appear in the form (doesnt matter how) but without seeing the excel app starting and also the controls of excel. In other words I need to work with the sheets as they would do in excel but without opening excel and in my app the only thing u see is the sheets. But i have no idea how to do this. Can someone help me please.

 

[Mike_R]

I think the best way to go for this is to use the Office Web Components Spreadsheet Control. Ive not used it extensively, but it seems fine in .Net.

To find it, right-click on your Toolbox, choose Add Or Removed Items... and then choose the COM Tab. Then scroll down to find "Microsoft Office Spreadsheet 11.0" (or 10.0 or whatever is on your system).

This control looks and acts a lot like Excel and you can bind the data to a Worksheet source or give it a SQL String to connect it to any database. Its pretty good for what you want to do, and its pretty much the only control to do this.

 

[Igloo]

Ty for the advice but I tried it and it does not have all the things that I need. Cause if youre in excel you can add comments to the cells and I need those comments.

 

[Mike_R]

Ok, well... there really is nothing else. There is an OLE Container control, but it dates to like 1994 and is terrible, even in VB6.

Generally, Excel is Automated, stand-alone. Bringing it into your form is a nice idea, but the OLE Container (which is sort-of designed to do this) really is very tough, and is more of a "viewer" than an interactive control.