使用 Interop 打印 Excel [英] Printing Excel using Interop

问题描述

有人知道如何使用 C# 和 Excel Interop 以编程方式打印 excel 文件吗?如果是这样，你能提供代码吗?

Does anybody have any idea how to print an excel file programatically using C# and the Excel Interop? If so, can you please provide code?

推荐答案

为了打印，您可以使用 Worksheet.PrintOut() 方法.您可以通过传入 Type 来省略任何或所有可选参数.不见了.如果您省略所有这些，它将默认从您的活动打印机打印一份副本.但是您可以使用参数来设置要打印的份数、整理等.请参阅 Worksheet.PrintOut() 方法了解更多.

In order to print, you can make use of the Worksheet.PrintOut() method. You can omit any or all of the optional arguments by passing in Type.Missing. If you omit all of them, it will default to printing out one copy from your active printer. But you can make use of the arguments to set the number of copies to print, collation, etc. See help on the Worksheet.PrintOut() method for more.

他们在帮助文件中显示的示例是:

The example they show in the help file is:

private void PrintToFile()
{
    // Make sure the worksheet has some data before printing.
    this.Range["A1", missing].Value2 = "123";
    this.PrintOut(1, 2, 1, false, missing, true, false, missing);
}

但除非您需要更改默认设置，否则您只需传入 Type.Missing 所有参数.下面是一个使用自动化打开 Excel 工作簿，打印第一页，然后关闭的示例:

But unless you need to change the default settings, you can simply pass in Type.Missing for all the arguments. Here's an example using automation to open an Excel Workbook, print the first page, and then shut down:

void PrintMyExcelFile()
{
    Excel.Application excelApp = new Excel.Application();

    // Open the Workbook:
    Excel.Workbook wb = excelApp.Workbooks.Open(
        @"C:My DocumentsBook1.xls",
        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
        Type.Missing, Type.Missing,Type.Missing,Type.Missing);

    // Get the first worksheet.
    // (Excel uses base 1 indexing, not base 0.)
    Excel.Worksheet ws = (Excel.Worksheet)wb.Worksheets[1];

    // Print out 1 copy to the default printer:
    ws.PrintOut(
        Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
        Type.Missing, Type.Missing, Type.Missing, Type.Missing);

    // Cleanup:
    GC.Collect();
    GC.WaitForPendingFinalizers();

    Marshal.FinalReleaseComObject(ws);

    wb.Close(false, Type.Missing, Type.Missing);
    Marshal.FinalReleaseComObject(wb);

    excelApp.Quit();
    Marshal.FinalReleaseComObject(excelApp);
}

希望这有帮助！

迈克

这篇关于使用 Interop 打印 Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！