{"id":2261,"date":"2026-08-22T07:45:55","date_gmt":"2026-08-21T23:45:55","guid":{"rendered":"https:\/\/xlwings.net\/blog\/?p=2261"},"modified":"2026-03-28T12:02:21","modified_gmt":"2026-03-28T12:02:21","slug":"how-to-use-worksheetsprintout-in-the-xlwings-api-way","status":"publish","type":"post","link":"https:\/\/xlwings.net\/blog\/how-to-use-worksheetsprintout-in-the-xlwings-api-way\/","title":{"rendered":"How to use Worksheets.PrintOut in the xlwings API way"},"content":{"rendered":"\n

The PrintOut<\/code> method in the Worksheets collection, accessible via the xlwings API, provides a powerful way to print worksheets directly from Python. This functionality is essential for automating report generation and document distribution workflows, allowing you to control various aspects of the printing process without manual intervention in Excel.<\/p>\n\n\n\n

Functionality<\/strong>
The PrintOut<\/code> method sends one or more worksheets to a printer. You can specify a range of pages, the number of copies, whether to print to a file, and other standard print settings. It is particularly useful for batch printing multiple sheets or generating physical\/digital copies of reports as part of an automated script.<\/p>\n\n\n\n

Syntax in xlwings<\/strong>
The method is called on a Sheet<\/code> object (representing a single worksheet) or can be applied to multiple sheets via the sheets<\/code> collection. The xlwings syntax mirrors the VBA object model closely.<\/p>\n\n\n\n

sheet.api.PrintOut(From, To, Copies, Preview, ActivePrinter, PrintToFile, Collate, PrToFileName, IgnorePrintAreas)<\/code><\/p>\n\n\n\n

Parameters and Their Meanings<\/strong><\/p>\n\n\n\n

Parameter<\/th>Data Type<\/th>Description<\/th>How to Access\/Example Value<\/th><\/tr><\/thead>
From<\/code><\/td>Integer<\/td>The page number at which to start printing. If omitted, printing starts from the beginning.<\/td>Set to a number, e.g., 1<\/code>.<\/td><\/tr>
To<\/code><\/td>Integer<\/td>The page number at which to stop printing. If omitted, printing goes to the last page.<\/td>Set to a number, e.g., 3<\/code>.<\/td><\/tr>
Copies<\/code><\/td>Integer<\/td>The number of copies to print. Default is 1.<\/td>Set to a number, e.g., 2<\/code>.<\/td><\/tr>
Preview<\/code><\/td>Boolean<\/td>True<\/code> to have Excel invoke print preview before printing. False<\/code> (default) to print immediately.<\/td>Use True<\/code> or False<\/code>.<\/td><\/tr>
ActivePrinter<\/code><\/td>String<\/td>Sets the name of the active printer.<\/td>Provide a printer name string. Often left as None<\/code> to use default.<\/td><\/tr>
PrintToFile<\/code><\/td>Boolean<\/td>True<\/code> to print to a file. If True<\/code>, you must specify PrToFileName<\/code>.<\/td>Use True<\/code> or False<\/code>.<\/td><\/tr>
Collate<\/code><\/td>Boolean<\/td>True<\/code> (default) to collate multiple copies.<\/td>Use True<\/code> or False<\/code>.<\/td><\/tr>
PrToFileName<\/code><\/td>String<\/td>If PrintToFile<\/code> is True<\/code>, this is the name of the file to print to.<\/td>Provide a full file path string.<\/td><\/tr>
IgnorePrintAreas<\/code><\/td>Boolean<\/td>True<\/code> to ignore any print areas set in the worksheet and print the entire sheet.<\/td>Use True<\/code> or False<\/code>.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Most parameters are optional. In xlwings, you pass them as keyword arguments, and you can omit any you don’t need, using Excel’s defaults.<\/p>\n\n\n\n

Code Examples<\/strong><\/p>\n\n\n\n

    \n
  1. Basic Print:<\/strong> Print the active sheet immediately to the default printer.<\/li>\n<\/ol>\n\n\n\n
    import xlwings as xw\nwb = xw.Book('report.xlsx')\nwb.sheets['Sheet1'].api.PrintOut()<\/code><\/pre>\n\n\n\n
      \n
    1. Print Multiple Copies with Collation:<\/strong> Print two collated copies of a specific page range from “DataSheet”.<\/li>\n<\/ol>\n\n\n\n
      sheet = wb.sheets['DataSheet']\nsheet.api.PrintOut(From=1, To=1, Copies=2, Collate=True)<\/code><\/pre>\n\n\n\n
        \n
      1. Print to a PDF File:<\/strong> Print the entire “Summary” worksheet to a PDF file, ignoring any set print area.<\/li>\n<\/ol>\n\n\n\n
        output_path = r'C:\\Reports\\summary.pdf'\nwb.sheets['Summary'].api.PrintOut(PrintToFile=True, PrToFileName=output_path, IgnorePrintAreas=True)<\/code><\/pre>\n\n\n\n
          \n
        1. Print Preview:<\/strong> Open the print preview for the first three sheets without actually printing.<\/li>\n<\/ol>\n\n\n\n
          for sheet in wb.sheets[:3]: # Loop through first three sheets\nsheet.api.PrintOut(Preview=True, Copies=1)<\/code><\/pre>\n\n\n\n
          <\/p>\n","protected":false},"excerpt":{"rendered":"
          The `PrintOut` method in the Worksheets collection, accessible via the xlwings API, provides a power…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-2261","post","type-post","status-publish","format-standard","hentry","category-xlwings-api-reference"],"_links":{"self":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2261","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/comments?post=2261"}],"version-history":[{"count":2,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2261\/revisions"}],"predecessor-version":[{"id":3452,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/posts\/2261\/revisions\/3452"}],"wp:attachment":[{"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/media?parent=2261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/categories?post=2261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlwings.net\/blog\/wp-json\/wp\/v2\/tags?post=2261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}