Programmatically print worksheets

You can print any worksheet in a workbook.

Applies to: The information in this topic applies to document-level projects and VSTO Add-in projects for Excel. For more information, see Features available by Office application and project type.

Print a worksheet in a document-level customization

To print a worksheet

1. Call the PrintOut method of Sheet1, request two copies, and preview the document before printing.

   • C#
   • VB

   Globals.Sheet1.PrintOut(1, 1, 2, true);
   

   The PrintPreview method enables you to display the specified object in the Print Preview window. The following code assumes you have a Worksheet host item named Sheet1.

To preview a page before printing

1. Call the PrintPreview method of the worksheet.

   • C#
   • VB

   Globals.Sheet1.PrintPreview();
   

Print a worksheet in a VSTO Add-in

To print a worksheet

1. Call the PrintOut method of the active worksheet, request two copies, and preview the document before printing.

   • C#
   • VB

   ((Excel.Worksheet)Application.ActiveSheet).PrintOut
       (1, 1, 2, true);
   

   The PrintPreview method enables you to display the specified object in the Print Preview window.

To preview a page before printing

1. Call the PrintPreview method of the active worksheet.

   • C#
   • VB

   ((Excel.Worksheet)Application.ActiveSheet).PrintPreview();
   

Related content

• Work with worksheets
• How to: Programmatically check spelling in worksheets
• Worksheet host item
• Global access to objects in Office projects
• Optional parameters in Office solutions