加载指定打印纸张大小的工作簿
Contents
[
Hide
]
您可以在加载工作簿时使用LoadOptions.SetPaperSize()方法指定所需的打印纸张大小。请注意,如果在Microsoft Excel中新建文件,默认打印机的纸张大小会被应用设置覆盖。
以下示例演示了如何使用LoadOptions.SetPaperSize()方法。首先创建一个工作簿,然后在内存流中以XLSX格式保存。之后以A5纸张大小加载,保存为PDF格式;再以A3纸张大小加载,保存为PDF。打开输出的PDF文件检查纸张大小即可看到不同的设置。可下载由此代码生成的A5输出PDF 和 A3输出PDF。
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
workbook, _ := NewWorkbook() | |
worksheets, _ := workbook.GetWorksheets() | |
worksheet, _ := worksheets.Get_Int(0) | |
cells, _ := worksheet.GetCells() | |
cell, _ := cells.Get_String("P40") | |
cell.PutValue_String("This is sample data.") | |
stream, _ := workbook.SaveToStream() | |
opt, _ := NewLoadOptions_LoadFormat(LoadFormat_Xlsx) | |
opt.SetPaperSize(PaperSizeType_PaperA5) | |
wb1, _ := NewWorkbook_Stream_LoadOptions(stream, opt) | |
wb1.Save_String("LoadWorkbookWithPrinterSize.xlsx") |