Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 977998 - Last Review: December 16, 2009 - Revision: 1.3
How to create and manipulate Microsoft Excel by using Office Automation in Visual C++, Visual C# and Visual Basic.NET
Rapid publishing disclaimer
Microsoft corporation and/or its respective suppliers make no representations about the suitability, reliability, or accuracy of the information and related graphics contained herein. All such information and related graphics are provided "as is" without warranty of any kind. Microsoft and/or its respective suppliers hereby disclaim all warranties and conditions with regard to this information and related graphics, including all implied warranties and conditions of merchantability, fitness for a particular purpose, workmanlike effort, title and non-infringement. You specifically agree that in no event shall Microsoft and/or its suppliers be liable for any direct, indirect, punitive, incidental, special, consequential damages or any damages whatsoever including, without limitation, damages for loss of use, data or profits, arising out of or in any way connected with the use of or inability to use the information and related graphics contained herein, whether based on contract, tort, negligence, strict liability or otherwise, even if Microsoft or any of its suppliers has been advised of the possibility of damages.
This article describes an All-In-One Code Framework sample that is available for download. This code sample demonstrates how to create and manipulate Excel by using Automation from Visual C++, Visual C# and Visual Basic.NET.
Difficulty level
Collapse this imageExpand this image
Download information
To download this code sample, click the following link:
Technical overview
The code sample automates Microsoft Excel to perform the following operations in Visual C++, Visual C# and Visual Basic.NET.
- Create a Microsoft Excel instance.
- Create a new workbook.
- Fill data into a range.
- Save the workbook.
- Close the Microsoft Excel instance, and then clean up unmanaged COM resources.
Note For more information about how to create the sample application and how to deploy the sample application, see the Readme.txt file that is included in the download package.
Technology category
- Office Solutions Development
Languages
This code sample contains the following programming languages:
Collapse this tableExpand this table
| Language | Project Name |
| Visual C++ | CppAutomateExcel |
| Visual C# | CSAutomateExcel |
| Visual Basic .NET | VBAutomateExcel |
Prerequisites
- You must run this code sample on a computer that has Microsoft Excel 2007 installed.
- This sample application was created by using Visual Studio 2008 with Service Pack 1 installed.
Tags
What is All-In-One Code Framework?
All-In-One Code Framework shows most Microsoft development techniques by using code samples in different programming languages. Each example is carefully selected, composed, and documented to show one common code scenario. For more information about All-In-One Code Framework, visit the following Web site:
http://cfx.codeplex.com
(http://cfx.codeplex.com)
How to find more All-In-One Code Framework samples
To find more All-In-One Code Framework samples, you can search for
kbcodefx together with related keywords on support.microsoft.com. Or, you can simply click the following link:
http://support.microsoft.com/search/default.aspx?query=kbcodefx
(http://support.microsoft.com/search/default.aspx?query=kbcodefx)
For more information, visit the following Web sites:
APPLIES TO
- Microsoft Visual Studio 2008 Academic Edition
- Microsoft Visual Studio 2008 Professional Edition
- Microsoft Visual Studio 2008 Standard Edition
- Microsoft Visual Studio Team System 2008 Database Edition
- Microsoft Visual Studio Team System 2008 Architecture Edition
- Microsoft Visual Studio Team System 2008 Development Edition
- Microsoft Visual Studio Team System 2008 Test Edition
- Microsoft Visual Studio Team System 2008 Team Suite
| kbnomt kbcodefx atdownload kbrapidpub kbsurveynew kbinfo KB977998 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please