Microsoft Office Tutorials and References
In Depth Information
Want to know your growth levels for a specific product sales range? Check which
parts of your business are performing worse? The pivot table provides more
information from your business in depth.
Every application in this computer world works with data. The data can be in any
form and can belong to different sources. The key question for data management is
where to place the data. You manage the data in two ways: data managed outside
the program and data managed inside the program. The data managed outside
the program includes data managed in a database, a file system, and so on. Data
managed inside the program includes data in different worksheets within the
workbook, embedded images, and so on.
For users who are not satisfied with the default features in Microsoft Office Excel,
VSTO programming makes Excel more flexible, and provides a development tool
for the creation of custom solutions for data manipulation and data analysis.
Custom programming using VSTO 3.0 improves most part of the Microsoft Office
Excel solution. Custom programming using VSTO 3.0 provides a wide range of
advantages, including saving time by automating most of the frequently-performed
tasks, reducing errors due to manual operations, as well as enforcing standards
for data processing, and building the capability to seamlessly integrate with other
Reading worksheet cells
There are many ways to manipulate data and write to the cells in an Excel worksheet.
Let's see some of these ways.
We can read worksheet cells directly through the Cells property of the sheets, rows,
and columns, and can set a value directly by using the cell's row and column index.
Open Visual Studio 2008 and create a new Excel solution. Refer to the previous
example for full instructions of how to do this. Write the following code inside the
ThisWorkbook.cs file. In this sample explanation, you are writing data into the
worksheet by using the Cells object.
// The Startup event of workbook in our Excel solution
private void ThisWorkbook_Startup(object sender,
// Set value for Cells row and column index