Visual Studio Tools for the Microsoft Office System
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: Create New Workbooks
How to: Open Workbooks
How to: Open Text Files as Workbooks
How to: Activate Workbooks
How to: Save Workbooks
How to: Send Workbooks by E-Mail Programmatically
How to: Close Workbooks
How to: Display a Dialog Box to Open Excel Files
How to: Get and Set the Default File Path for Workbooks
How to: List Recently Used Workbook Files
Basic Worksheet Tasks
How to: Display a String in a Worksheet Cell
How to: Select Worksheets
How to: Add New Worksheets to Workbooks
How to: Delete Worksheets from Workbooks
How to: Hide Worksheets
How to: Move Worksheets Within Workbooks
How to: List All Worksheets in a Workbook
How to: Print Worksheets
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
How to: Display the Current User's Logon ID in a Cell
How to: Store and Retrieve Date Values in Excel Ranges
Securing Workbooks
How to: Protect Workbooks
How to: Protect Worksheets
How to: Remove Protection from Worksheets
How to: Set and Clear Workbook Passwords
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
0 评论:
发表评论