加载指定打印纸张大小的工作簿
Contents
[
Hide
]
您可以使用 LoadOptions.SetPaperSize() 方法在加载工作簿时指定所需的打印纸张大小。请注意,如果你在MS Excel中创建一个新文件,你会发现纸张大小与你的机器上默认打印机的设置相同。
以下示例代码演示了LoadOptions.SetPaperSize()方法的用法。它首先创建一个工作簿,然后以XLSX格式将其保存在内存流中。然后使用A5纸张大小加载它并以PDF格式保存。然后再次加载它并使用A3纸张大小再次以PDF格式保存。如果您打开输出的PDF并检查它们的纸张大小,您会发现它们是不同的。一个是A5,另一个是A3。请下载代码生成的A5输出PDF和A3输出PDF以供参考。
This file contains 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
Aspose::Cells::Startup(); | |
U16String dataDir = u""; | |
// Create a sample workbook and add some data inside the first worksheet | |
Workbook workbook; | |
Worksheet worksheet = workbook.GetWorksheets().Get(0); | |
worksheet.GetCells().Get(u"P30").PutValue(u"This is sample data."); | |
// Save the workbook in memory stream | |
Vector<uint8_t> ms = workbook.SaveToStream(); | |
// Now load the workbook from memory stream with A5 paper size | |
LoadOptions opts(LoadFormat::Xlsx); | |
opts.SetPaperSize(PaperSizeType::PaperA5); | |
workbook = Workbook(ms, opts); | |
// Save the workbook in pdf format | |
workbook.Save(dataDir + u"LoadWorkbookWithPrinterSize-a5_out.pdf"); | |
// Now load the workbook again from memory stream with A3 paper size | |
opts = LoadOptions(LoadFormat::Xlsx); | |
opts.SetPaperSize(PaperSizeType::PaperA3); | |
workbook = Workbook(ms, opts); | |
// Save the workbook in pdf format | |
workbook.Save(dataDir + u"LoadWorkbookWithPrinterSize-a3_out.pdf"); | |
Aspose::Cells::Cleanup(); |