How can I . . .
-
. . . embedd an, say excel sheet in my application? I was looking at OLE, but as far as I can understand that has to do more with manipulating an open application rather than using components of the app. What I'm really trying to do, is to create an Excel graph from data that my app collects. Quite new to this! Regards, Venet. Donec eris felix, multos numerabis amicos.
-
. . . embedd an, say excel sheet in my application? I was looking at OLE, but as far as I can understand that has to do more with manipulating an open application rather than using components of the app. What I'm really trying to do, is to create an Excel graph from data that my app collects. Quite new to this! Regards, Venet. Donec eris felix, multos numerabis amicos.
Search this forum with "Excel" in the search box right above.
How low can you go ?
(MS rant) -
Search this forum with "Excel" in the search box right above.
How low can you go ?
(MS rant)Thanks, I did do a search before posting, however all the examples that I've come accross describe Excel automation, i.e. opening excel and populating the fields in it. My question was, if I can embedd an excel workbook in my application, rather than having that workbook opened in the Excel app itslef. (Something like IE does when viewing .PDF files) Regards, Venet. Donec eris felix, multos numerabis amicos.
-
Thanks, I did do a search before posting, however all the examples that I've come accross describe Excel automation, i.e. opening excel and populating the fields in it. My question was, if I can embedd an excel workbook in my application, rather than having that workbook opened in the Excel app itslef. (Something like IE does when viewing .PDF files) Regards, Venet. Donec eris felix, multos numerabis amicos.
You've got OLE components with progids such like
Excel.SheetandExcel.Chart(you probably already know theExcel.Applicationprogid, which in turn launches Excel). These are OLE components, not ActiveX controls. That's why they don't appear in the IDE (customize toolbox for instance). But they are here and ready. For instance, They appear when you are in Word, Insert \ Object, then select either Microsoft Excel Sheet, or Microsoft Excel Chart. That's exactly the entry point for that. More info here[^].
How low can you go ?
(MS rant) -
You've got OLE components with progids such like
Excel.SheetandExcel.Chart(you probably already know theExcel.Applicationprogid, which in turn launches Excel). These are OLE components, not ActiveX controls. That's why they don't appear in the IDE (customize toolbox for instance). But they are here and ready. For instance, They appear when you are in Word, Insert \ Object, then select either Microsoft Excel Sheet, or Microsoft Excel Chart. That's exactly the entry point for that. More info here[^].
How low can you go ?
(MS rant) -
. . . embedd an, say excel sheet in my application? I was looking at OLE, but as far as I can understand that has to do more with manipulating an open application rather than using components of the app. What I'm really trying to do, is to create an Excel graph from data that my app collects. Quite new to this! Regards, Venet. Donec eris felix, multos numerabis amicos.
You know how IE does it? IE is an "ActiveX Document Host". The simplest way is to reuse the WebBrowser control in your form to host excel documents... HOWTO: Use the WebBrowser Control to Open Office Documents with Visual C# .NET[^]
-
You know how IE does it? IE is an "ActiveX Document Host". The simplest way is to reuse the WebBrowser control in your form to host excel documents... HOWTO: Use the WebBrowser Control to Open Office Documents with Visual C# .NET[^]