Spire.XLS for C++ 15.5.0 现已正式发布。该版本增加了一系列新功能，例如支持转换 Excel 到 PDF 时设置页面大小，支持将图像嵌入单元格，支持对形状进行分组以及启用修订模式。详情请查阅以下内容。

调整：:

• • 升级SkiaSharp->3.116.1

新功能:

• • 支持在Excel到PDF转换时设置页面大小。

intrusive_ptr workbook = new Workbook();
intrusive_ptr sheet = workbook->GetWorksheets()->Add(L""0"");
intrusive_ptr a1 = sheet->GetRange(L""A1"");
a1->SetValue(L""taatat"");
sheet->GetPageSetup()->SetPaperSize(PaperSizeType::PaperA0);
workbook->SaveToFile(outputFile.c_str(), ExcelVersion::Version2013);
workbook->Dispose();

• • 支持对Shape分组。

intrusive_ptr book = new Workbook();
book->GetWorksheets()->Clear();
intrusive_ptr sheet = book->GetWorksheets()->Add(L""0"");
intrusive_ptr shape1 = sheet->GetPrstGeomShapes()->AddPrstGeomShape(1, 3, 50, 50, PrstGeomShapeType::RoundRect);
intrusive_ptr shape2 = sheet->GetPrstGeomShapes()->AddPrstGeomShape(5, 3, 50, 50, PrstGeomShapeType::Triangle);

wcout << sheet->GetName() << endl;
intrusive_ptr groupShapeCollection = sheet->GetGroupShapeCollection();
vector> shapes;
shapes.push_back(shape1);
shapes.push_back(shape2);

groupShapeCollection->Group(shapes);
book->SaveToFile(outputFile.c_str(), ExcelVersion::Version2013);
book->Dispose();

• • 支持获取Excel文档中所有Shape。

intrusive_ptr book = new Workbook();
book->LoadFromFile(inputFile.c_str());
intrusive_ptr sheet = dynamic_pointer_cast(book->GetWorksheets()->Get(0));

std::vector> images;
for (int i = 0; i < sheet->GetShapes()->GetCount(); ++i)
{
    intrusive_ptr shape = dynamic_pointer_cast(sheet->GetShapes()->Get(i));
    intrusive_ptr image = shape->SaveToImage();
    shape->SaveToImage((outputFile + L""Bug_out_"" + std::to_wstring(i) + L"".png"").c_str());
}

• • 支持启用修订模式。

intrusive_ptr workbook = new Workbook();
workbook->LoadFromFile(inputFile.c_str());
workbook->TrackedChanges(true);
workbook->SaveToFile(outputFile.c_str(), ExcelVersion::Version2013);

• • 支持嵌入图片到单元格。

intrusive_ptr workbook = new Workbook();
workbook->LoadFromFile(inputFile.c_str());
intrusive_ptr sheet = dynamic_pointer_cast(workbook->GetWorksheets()->Get(0));
intrusive_ptr range = dynamic_pointer_cast(sheet->GetRange(L""D1""));
intrusive_ptr fs = new Stream(inputFile_Img.c_str());
range->InsertOrUpdateCellImage(fs, true);
workbook->SaveToFile(outputFile.c_str(), ExcelVersion::Version2013);
workbook->Dispose();

• • 支持对透视表进行分组。

intrusive_ptr workbook(new Workbook());
workbook->LoadFromFile(inputFile.c_str());
intrusive_ptr pivotSheet = workbook->GetWorksheets()->Get(0);

intrusive_ptr pivot = dynamic_pointer_cast(pivotSheet->GetPivotTables()->Get(0));
intrusive_ptr dateBaseField = pivot->GetPivotFields()->Get(L""number"");
dateBaseField->CreateGroup(3000, 3800, 1);
pivot->CalculateData();
workbook->SaveToFile(outputFile.c_str());

https://www.e-iceblue.cn/Downloads/Spire-XLS-CPP.html