Workbook.Print(PrinterSettings, IEnumerable<String>) Method

Defines printer settings and prints the specified sheets.

You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Docs.v23.2.dll

NuGet Package: DevExpress.Document.Processor

Declaration

C#

public void Print(
    PrinterSettings printerSettings,
    IEnumerable<string> sheetNames
)

VB.NET

Public Sub Print(
    printerSettings As PrinterSettings,
    sheetNames As IEnumerable(Of String)
)

Parameters

Name	Type	Description
printerSettings	PrinterSettings	Specifies printer settings.
sheetNames	IEnumerable<String>	Lists the names of the sheets to be printed.

Remarks

Use this Print method to print individual sheets in a workbook. It prints all the specified sheets despite their visibility type (WorksheetVisibilityType).

The PrinterSettings class allows you to specify printer settings: the printer’s name, the number of copies, a print range, and so on.

C#

using DevExpress.Spreadsheet;
using System.Drawing.Printing;
// ...

// Create a new Workbook object.
Workbook workbook = new Workbook();

// Load a document from a file.
workbook.LoadDocument("Documents\\Document.xlsx");

// Create an object that contains printer settings.
PrinterSettings printerSettings = new PrinterSettings();

// Define the printer to use.
printerSettings.PrinterName = "Microsoft Print to PDF";
printerSettings.PrintToFile = true;
printerSettings.PrintFileName = "PrintedDocument.pdf";

// Print specific worksheets in the document.
workbook.Print(printerSettings, new string[] { "Sheet1", "Sheet2" });

VB.NET

Imports DevExpress.Spreadsheet
Imports System.Drawing.Printing
' ...

' Create a new Workbook object.
Dim workbook As New Workbook()

' Load a document from a file.
workbook.LoadDocument("Documents\Document.xlsx")

' Create an object that contains printer settings.
Dim printerSettings As New PrinterSettings()

' Define the printer to use.
printerSettings.PrinterName = "Microsoft Print to PDF"
printerSettings.PrintToFile = True
printerSettings.PrintFileName = "PrintedDocument.pdf"

' Print specific worksheets in the document.
workbook.Print(printerSettings, New String() { "Sheet1", "Sheet2" })

Use the WorksheetView and WorksheetPrintOptions objects’ properties to define page options and specify print settings.

Calculate Formulas Before Print Operation

The default calculation mode for a Workbook is Manual. This mode implies that the Spreadsheet does not calculate formulas before it prints a document. Call the Workbook.Calculate or Workbook.CalculateFull method to calculate all formulas in the workbook.