Before we begin the chapter, let's see where you will stand once you complete reading this chapter on Microsoft Office Excel programming. Beginning with programming in Excel 2007 using VSTO 3.0 and proceeding with programming concepts, you will learn how to manipulate data inside Excel. Later, you will learn the concepts of workbook manipulation and worksheet manipulation, with code samples. When programming in the Excel 2007, the object model plays an important role. You will learn the most important and widely used objects, with the help of demonstrations.
In this chapter, you will learn:
Excel 2007 in Visual Studio 2008, including how to start an Excel solution in Visual Studio 2008
Excel 2007 solution: the object model, and the object model functional area
Data and worksheet manipulation in Excel 2007
Data processing with Microsoft SQL Server 2008
Working with ranges, cell unions, named ranges, and so on
Working with host items in Excel, and charts...