Igloo Posted December 14, 2004 Posted December 14, 2004 Hi guys, I have a big question about using excel sheets in a vb.net application. Ok here's 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 (doesn't 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. Quote
Mike_R Posted December 14, 2004 Posted December 14, 2004 I think the best way to go for this is to use the Office Web Components Spreadsheet Control. I've 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. It's pretty good for what you want to do, and it's pretty much the only control to do this. Quote Posting Guidelines Avatar by Lebb
Igloo Posted December 14, 2004 Author Posted December 14, 2004 Ty for the advice but I tried it and it does not have all the things that I need. Cause if you're in excel you can add comments to the cells and I need those comments. Quote
Mike_R Posted December 14, 2004 Posted December 14, 2004 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. Quote Posting Guidelines Avatar by Lebb
Recommended Posts