Spire.XLS for .NET 是一个独立的 Excel 组件,不依赖于 Microsoft Office Excel。它同时支持旧版的 Excel 97-2003(.xls) 格式文档和新版的 Excel 2007、Excel 2010、Excel 2013、Excel 2016(.xlsx, .xlsb, .xlsm) 以及 Open Office(.ods) 格式文档。
Spire.XLS for .NET 提供免费版和商业版,根据需要自行定夺,本站不给予任何授权和破解支持。官网:http://www.e-iceblue.cn/
以下是简单的 Execl 文件打印例子:
/// <summary>
/// 打印 Execl
/// </summary>
/// <param name="fileName">要打印的 Execl 文件</param>
/// <param name="documentName">打印机上显示的文件名称</param>
/// <param name="printerName">打印机全名</param>
/// <param name="paperName">纸张名称(默认:A4)</param>
/// <param name="landscape">是否横向打印(默认:false)</param>
/// <param name="copies">打印份数(默认:1)</param>
public static void PrintExecl(string fileName, string documentName, string printerName, string paperName = "A4", bool landscape = false, short copies = 1)
{
using (Spire.Xls.Workbook workbook = new Spire.Xls.Workbook())
{
//加载要打印的execl
workbook.LoadFromFile(fileName);
//打印机全名
workbook.PrintDocument.PrinterSettings.PrinterName = printerName;
//打印机上显示的文件名称
workbook.PrintDocument.DocumentName = documentName;
//打印份数
workbook.PrintDocument.PrinterSettings.Copies = copies;
//设定纸张大小
foreach (PaperSize pageSize in workbook.PrintDocument.PrinterSettings.PaperSizes)
{
if (pageSize.PaperName == paperName)
{
workbook.PrintDocument.PrinterSettings.DefaultPageSettings.PaperSize = pageSize;
}
}
//是否横向打印
workbook.PrintDocument.PrinterSettings.DefaultPageSettings.Landscape = landscape;
//打印
workbook.PrintDocument.Print();
}
}