Spire.Office 最新版v6.11.2发布！新增多重功能

支持设置图表数据栏的边框。

XlsConditionalFormats cfs = sheet.ConditionalFormats[0];
IConditionalFormat cf = cfs[0];
Spire.Xls.DataBar dataBar1 = cf.DataBar;
dataBar1.BarBorder.Type = Spire.Xls.Core.Spreadsheet.ConditionalFormatting.DataBarBorderType.DataBarBorderSolid;
dataBar1.BarBorder.Color = Color.GreenYellow; 

支持为折线图和面积图设置下拉线。

chart.Series[0].HasDroplines = true; 

支持在将 excel 文件转换为 pdf 时设置自定义页面大小。

workbook.Worksheets[0].PageSetup.SetCustomPaperSize(width, height); 

支持获取附件页码

int page = pdf.Attachments.GetAttachmentPage("attachmentFileName"); 

支持将 PDF 转换为线性化的 PDF

PdfToLinearizedPdfConverter converter = new PdfToLinearizedPdfConverter("inputFile");
converter.ToLinearizedPdf("outputFile");

添加一个新方法“SetColumnWidth”来设置表格列宽

table.SetColumnWidth(int columnIndex, float columnWidth, CellWidthType columnWidthType); 

添加新方法“UseNewEngine”以使用新引擎将 Word 转换为 PDF

Document doc = new Document();
doc.LoadFromFile("input.docx");
doc.UseNewEngine = true;
doc.SaveToFile("result.pdf", FileFormat.PDF); 

调整设置表格单元格宽度的方法

//Old method
//tableCell.Width //Deprecated
//tableCell.CellWidthType //Deprecated
//New method
tableCell.SetCellWidth(float width, CellWidthType widthType); 

支持获取表格单元格的填充颜色

table.TableRows[i][j].DisplayColor;

支持设置图表的数据标签范围

Presentation ppt = new Presentation();
IChart chart = ppt.Slides[0].Shapes.AppendChart(ChartType.ColumnStacked, new RectangleF(100, 100, 500, 400));
CellRange cellRange = chart.ChartData["F1"];
cellRange.Text = "aaa";
cellRange = chart.ChartData["F2"];
cellRange.Text = "bbb";
cellRange = chart.ChartData["F3"];
cellRange.Text = "ccc";
cellRange = chart.ChartData["F4"];
cellRange.Text = "ddd";
chart.Series[0].DataLabelRanges = chart.ChartData["F1", "F4"];
ChartDataLabel dataLabel1 = chart.Series[0].DataLabels.Add();
dataLabel1.ID = 0;
dataLabel1.LabelValueVisible = true;
dataLabel1.ShowDataLabelsRange = true;

支持获取自定义动画的路径数据

foreach (AnimationEffect effect in shape.Slide.Timeline.MainSequence)
{
    if (effect.ShapeTarget.Equals(shape as Spire.Presentation.Shape))
    {
        MotionPath path = ((AnimationMotion)effect.CommonBehaviorCollection[0]).Path;
        foreach (MotionCmdPath motionCmdPath in path)
        {
            PointF[] points = motionCmdPath.Points;
            MotionCommandPathType type = motionCmdPath.CommandType;
        }
    }
}

添加新方法“IShape.SaveAsImage()”以将形状转换为图像

Image image = shape.SaveAsImage();

支持获取表格单元格边框的显示颜色

table[0, 0].BorderLeftDisplayColor;
table[0, 0].BorderTopDisplayColor;
table[0, 0].BorderRightDisplayColor;
table[0, 0].BorderBottomDisplayColor;