加载指定打印纸张大小的工作簿

您可以使用 LoadOptions.SetPaperSize() 方法在加载工作簿时指定所需的打印纸张大小。请注意，如果你在MS Excel中创建一个新文件，你会发现纸张大小与你的机器上默认打印机的设置相同。

以下示例代码展示了LoadOptions.SetPaperSize()方法的用法。它首先创建一个工作簿，然后以XLSX格式将其保存在内存流中。然后用A5纸张大小加载并保存为PDF格式，再用A3纸张大小加载再次保存为PDF。如果打开输出的PDF并检查纸张大小，你会看到它们不同，一个是A5，另一个是A3。请下载由代码生成的A5输出PDF和A3输出PDF以供参考。

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();