Excel Tasks
This section provides examples of commonly performed tasks that make use of the Microsoft Office Excel 2003 object model in Microsoft Visual Studio 2005 Tools for the Microsoft Office System.
Basic Workbook Tasks
How to: Open Text Files as Workbooks
How to: Send Workbooks by E-Mail Programmatically
How to: Display a Dialog Box to Open Excel Files
Basic Worksheet Tasks
How to: Display a String in a Worksheet Cell
How to: Add New Worksheets to Workbooks
How to: Delete Worksheets from Workbooks
How to: Move Worksheets Within Workbooks
How to: List All Worksheets in a Workbook
How to: Sort Data in Worksheets Programmatically
How to: Add and Delete Worksheet Comments
How to: Display Worksheet Comments
How to: Create Groups in Worksheets
How to: Clear Groups in Worksheets
How to: Refer to Worksheet Ranges in Code
How to: Send Values to Worksheet Cells
Securing Workbooks
Formatting
How to: Apply Styles to Ranges in Workbooks
How to: Clear Styles from Ranges in Workbooks
How to: Copy Data and Formatting across Worksheets
How to: Change Formatting in Worksheet Rows Containing Selected Cells
Working with Ranges
How to: Run Excel Calculations Programmatically
How to: Check Spelling in Worksheets
How to: Automatically Fill Ranges with Incrementally Changing Data
