[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Chart Control
  [Expand]Pivot Grid
   [Expand]Product Information
    Getting Started
    [Expand]Spreadsheet Document
     Supported Formats
     Import and Export
    [Expand]Cell Basics
    [Expand]Spreadsheet Formulas
     Defined Names
     Data Validation
    [Expand]Data Presentation
     Pivot Table
    [Expand]Mail Merge
     Keyboard Shortcuts
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)


The ASPxSpreadsheet control provides two basic approaches to printing: you can print a document from code using the appropriate API methods and properties, or using the spreadsheet Ribbon UI. Note that the printing command is located in the Common Ribbon page group of the File tab.

The document includes the following sections.

Expanded Print a Workbook using the Print Dialog

  • Invoke the Print dialog using the Ribbon UI

    To print a document and set print options, click the Print button in the Common group, or press CTRL+P.

    In the invoked Print dialog box, specify the required settings such as printer name, the number of document copies and the number of pages you wish to print, and click Print.

Expanded Specify Print Options

  • Via the Ribbon UI

    Before printing a workbook, an end-user can specify print settings for each worksheet separately using the Page Layout ribbon tab of the ASPxSpreadsheet control. Use buttons located in the Page Setup group to specify page margins, document orientation, and paper size. To set more specific printout settings (such as print scaling, page order, header and footer options, etc.), click the Margings - Custom Margins... command to invoke the Page Setup dialog.

  • In code

    To specify print options, use properties of the WorksheetView object, accessible using the Worksheet.ActiveView property. The WorksheetView enables you to specify general page options such as orientation, margins and paper size settings. More print-specific options can be specified using the properties of the WorksheetPrintOptions object.

Expanded See Also

Is this topic helpful?​​​​​​​