Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Studio .Net C# and Excel
I am intending to use C# and Excel together, using excel much like a grid
control. Can anyone point me in the right direction for tools in studio 2003 that will allow me to do this? I have seen references to an Office Toolkit and I have seen references to create an excel add-in in visual studio. Yet I have been unable to find any current information on this and to find out what is the best practices for dialoging with excel via COM and C#. Any help would be appreciated to highlight the best and worst methods. Thanks in advance. Regards, Adam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Studio .Net C# and Excel
"Adam" wrote:
I am intending to use C# and Excel together, using excel much like a grid control. Can anyone point me in the right direction for tools in studio 2003 that will allow me to do this? Let me take a deep breath before I say this: "Visual Studio Tools for the Microsoft Office System," or VSTO for short. http://msdn.microsoft.com/office/und...o/default.aspx It's not part of the standard Visual Studio distribution. If you're an MSDN subscriber, you'll find it on one of the Developer Tools disks. Otherwise, check out http://msdn.microsoft.com/howtobuy/vsto/default.aspx for some sobering news. Besides the sample code, tutorials & multimedia links available at the first URL above, there is a relatively new book from MS Press by Andrew Whitechapel called "Microsoft .NET development for Microsoft Office." I just started it. Looks promising. And if you go to all the effort to figure out .NET for Office, you'll be happy to know you can do more than use Excel as a grid control. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Studio .Net C# and Excel
Thanks for the info. After I posted I looked into VSTO, but I also came
across some info on PIA and also creating Excel Addins with PIA in VS. Can you or anyone tell me what the disadvantages of using either method of development? Regards, Adam "Shawn O'Donnell" wrote: "Adam" wrote: I am intending to use C# and Excel together, using excel much like a grid control. Can anyone point me in the right direction for tools in studio 2003 that will allow me to do this? Let me take a deep breath before I say this: "Visual Studio Tools for the Microsoft Office System," or VSTO for short. http://msdn.microsoft.com/office/und...o/default.aspx It's not part of the standard Visual Studio distribution. If you're an MSDN subscriber, you'll find it on one of the Developer Tools disks. Otherwise, check out http://msdn.microsoft.com/howtobuy/vsto/default.aspx for some sobering news. Besides the sample code, tutorials & multimedia links available at the first URL above, there is a relatively new book from MS Press by Andrew Whitechapel called "Microsoft .NET development for Microsoft Office." I just started it. Looks promising. And if you go to all the effort to figure out .NET for Office, you'll be happy to know you can do more than use Excel as a grid control. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
get Excel array values in Visual Studio VB | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Excel 2003 RTD Server with Visual Studio .NET/C# | Excel Programming | |||
Problem getting excel to work in Visual Studio (C#) | Excel Programming |