Install-Package Spire.XLS

using Spire.Xls;

namespace ExcelPrintSetup
{
    class Program
    {
        static void Main(string[] args)
        {
            // 創(chuàng)建Workbook對象并加載Excel文檔
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("測試.xlsx");

            // 獲取第一張工作表的PageSetup對象
            Worksheet worksheet = workbook.Worksheets[0];
            PageSetup pageSetup = worksheet.PageSetup;

            // 設置頁邊距（單位：英寸）
            pageSetup.TopMargin = 0.3;
            pageSetup.BottomMargin = 0.3;
            pageSetup.LeftMargin = 0.3;
            pageSetup.RightMargin = 0.3;

            // 指定打印區(qū)域和標題行
            pageSetup.PrintArea = "A1:F7";        // 只打印A1到F7區(qū)域
            pageSetup.PrintTitleRows = "$1:$2";   // 每頁都打印前兩行作為標題

            // 設置打印選項
            pageSetup.IsPrintHeadings = true;     // 打印行/列標題
            pageSetup.IsPrintGridlines = true;    // 打印網(wǎng)格線
            pageSetup.PrintComments = PrintCommentType.InPlace;  // 打印注釋

            // 設置打印質(zhì)量和其他選項
            pageSetup.PrintQuality = 300;          // 打印分辨率
            pageSetup.BlackAndWhite = true;        // 黑白打印
            pageSetup.Order = OrderType.OverThenDown;  // 打印順序：先列后行
            pageSetup.IsFitToPage = true;          // 縮放到一頁

            // 保存設置后的文檔
            workbook.SaveToFile("頁面打印選項.xlsx", ExcelVersion.Version2016);

            Console.WriteLine("打印設置已保存成功！");
        }
    }
}

using Spire.Xls;
using System.Drawing.Printing;

namespace ExcelSilentPrint
{
    class Program
    {
        static void Main(string[] args)
        {
            // 創(chuàng)建Workbook對象并加載文檔
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("測試.xlsx");

            // 設置工作表縮放到一頁
            PageSetup pageSetup = workbook.Worksheets[0].PageSetup;
            pageSetup.IsFitToPage = true;

            // 設置打印控制器，隱藏打印對話框
            workbook.PrintDocument.PrintController = new StandardPrintController();

            // 獲取并配置打印機設置
            PrinterSettings settings = workbook.PrintDocument.PrinterSettings;
            settings.PrinterName = "HP LaserJet P1007";  // 指定打印機名稱
            settings.Duplex = Duplex.Simplex;            // 單面打印
            settings.FromPage = 1;                        // 起始頁
            settings.ToPage = 3;                          // 結束頁

            // 執(zhí)行打印
            workbook.PrintDocument.Print();

            Console.WriteLine("打印任務已發(fā)送到打印機！");
        }
    }
}

foreach (string printer in PrinterSettings.InstalledPrinters)
{
    Console.WriteLine(printer);
}

pageSetup.PaperSize = PaperSizeType.A4;
pageSetup.Orientation = PageOrientationType.Landscape;  // 橫向打印