c# - 使用 EPPLUS c# 在一页上适合所有列

Question

我想使用 epplus 在一页上设置打印机设置 Fit All 列。任何人都可以请帮忙。

我的代码:

Worksheet.PrinterSettings.PaperSize = ePaperSize.A4;
Worksheet.PrinterSettings.Orientation = eOrientation.Landscape;
Worksheet.PrinterSettings.FitToPage = true;

Worksheet.PrinterSettings.FitToWidth = 1;

Answer 1

我认为这有点违反直觉，但您还必须设置 worksheet.PrinterSettings.FitToHeight = 0为了使这个工作。

这是我在设置打印工作表时通常使用的代码:

worksheet.PrinterSettings.PaperSize = ePaperSize.A4;
worksheet.PrinterSettings.Orientation = eOrientation.Portrait;
worksheet.PrinterSettings.HorizontalCentered = true;
worksheet.PrinterSettings.FitToPage = true;
worksheet.PrinterSettings.FitToWidth = 1;
worksheet.PrinterSettings.FitToHeight = 0;