Aspose.Cells 8.3.1中的公共API更改

本文介绍了Aspose.Cells API从版本8.3.0到8.3.1的更改，可能会引起模块/应用程序开发人员的兴趣。

添加的 API

添加了DataLabels.ShowCellRange属性

已向 DataLabels 类添加了 ShowCellRange 属性，以模仿 Excel 在运行时格式化图表数据标签的功能。请注意，Excel 通过以下步骤提供此功能。

选择系列的数据标签，右键单击以打开弹出菜单。
单击格式数据标签…，将显示标签选项。
检查或取消选中标签包含 - 来自单元格的数值复选框。

下面的示例代码访问图表系列的数据标签，然后将 DataLabels.ShowCellRange 方法设置为 true，以模仿 Excel 的 标签包含 - 来自单元格的值 功能。

 //Create workbook from the source Excel file

Workbook workbook = new Workbook("sample.xlsx");

//Access the first worksheet

Worksheet worksheet = workbook.Worksheets[0];

//Access the chart inside the worksheet

Chart chart = worksheet.Charts[0];

//Check the "Label Contains - Value From Cells"

DataLabels dataLabels = chart.NSeries[0].DataLabels;

dataLabels.ShowCellRange = true;

//Save the workbook

workbook.Save("output.xlsx");

在工作表中实现 GridDesktop 数据绑定功能

'Create workbook from the source Excel file

Dim m_workbook As Workbook = New Workbook("sample.xlsx")

'Access the first worksheet

Dim m_worksheet As Worksheet = m_workbook.Worksheets(0)

'Access the chart inside the worksheet

Dim m_chart As Chart = m_worksheet.Charts(0)

'Check the "Label Contains - Value From Cells"

Dim m_dataLabels As DataLabels = m_chart.NSeries(0).DataLabels

m_dataLabels.ShowCellRange = True

'Save the workbook

m_workbook.Save("output.xlsx")

更多信息，请查看显示单元范围作为数据标签文章。

添加了 Cell.GetTable 和 ListObject.PutCellValue 方法

与Aspose.Cells for .NET 8.3.1，已添加了方法Cell.GetTable和ListObject.PutCellValue，以便让用户访问单元格中的ListObject并使用行和列偏移添加值到其中。以下示例代码加载源电子表格，并在表内添加值。

 //Create workbook from source Excel file

Workbook workbook = new Workbook("source.xlsx");

//Access first worksheet

Worksheet worksheet = workbook.Worksheets[0];

//Access cell D5 which lies inside the table

Cell cell = worksheet.Cells["D5"];

//Put value inside the cell D5

cell.PutValue("D5 Data");

//Access the Table from this cell

ListObject table = cell.GetTable();

//Add some value using Row and Column Offset

table.PutCellValue(2, 2, "Offset [2,2]");

//Save the workbook

workbook.Save("output.xlsx");

在工作表中实现 GridDesktop 数据绑定功能

 'Create workbook from source Excel file

Dim m_workbook As Workbook = New Workbook("source.xlsx")

'Access first worksheet

Dim m_worksheet As Worksheet = m_workbook.Worksheets(0)

'Access cell D5 which lies inside the table

Dim m_cell As Cell = m_worksheet.Cells("D5")

'Put value inside the cell D5

m_cell.PutValue("D5 Data")

'Access the Table from this cell

Dim table As ListObject = m_cell.GetTable()

'Add some value using Row and Column Offset

table.PutCellValue(2, 2, "Offset [2,2]")

'Save the workbook

m_workbook.Save("output.xlsx")

更多信息，请查看从单元格访问表和使用行和列偏移量在其中添加值文章。

添加了 OdsSaveOptions.IsStrictSchema11 属性

在 OdsSaveOptions 类中添加了 IsStrictSchema11 属性，以允许开发人员将电子表格保存为符合 ODF v1.2 规范的格式。IsStrictSchema11 属性的默认值为 false，这意味着从 Aspose.Cells API 的版本 8.3.1 开始，默认情况下将 ODS 文件保存为 ODF 格式版本 1.2。

以下提供的代码片段将ODS文件保存为ODF 1.2格式。

 //Create workbook

Workbook workbook = new Workbook();

//Access first worksheet

Worksheet worksheet = workbook.Worksheets[0];

//Put some value in cell A1

Cell cell = worksheet.Cells["A1"];

cell.PutValue("Welcome to Aspose!");

//Save ODS in ODF 1.2 version which is default

OdsSaveOptions options = new OdsSaveOptions();

workbook.Save("ODF1.2.ods", options);

//Save ODS in ODF 1.1 version

options.IsStrictSchema11 = true;

workbook.Save("ODF1.1.ods", options);

在工作表中实现 GridDesktop 数据绑定功能

 'Create workbook 

Dim m_workbook As Workbook = New Workbook()

'Access first worksheet

Dim m_worksheet As Worksheet = m_workbook.Worksheets(0)

'Put some value in cell A1

Dim m_cell As Cell = m_worksheet.Cells("A1")

m_cell.PutValue("Welcome to Aspose!")

'Save ODS in ODF 1.2 version which is default

Dim options As OdsSaveOptions = New OdsSaveOptions()

m_workbook.Save("ODF1.2.ods", options)

'Save ODS in ODF 1.1 version

options.IsStrictSchema11 = True

m_workbook.Save("ODF1.1.ods", options)

更多信息，请查看在 ODF 1.1 和 1.2 规范中保存 ODS 文件文章。

添加了 SparklineCollection.Add 方法

Aspose.Cells API已公开了SparklineCollection.Add(string dataRange, int row, int column)方法，以指定Sparkline Group的数据范围和位置。请注意，Excel通过以下步骤提供了相同的功能。

选择包含Sparkline的单元格。
在设计选项卡的编辑区域中选择编辑数据。
选择编辑组位置和数据。
指定数据范围和位置。

以下示例代码加载源电子表格，访问第一个折线图组并为折线图组添加新的数据范围和位置。

 //Create workbook from source Excel file

Workbook workbook = new Workbook("source.xlsx");

//Access first worksheet

Worksheet worksheet = workbook.Worksheets[0];

//Access the first sparkline group

SparklineGroup group = worksheet.SparklineGroupCollection[0];

//Add Data Ranges and Locations inside this sparkline group

group.SparklineCollection.Add("D5:O5", 4, 15);

group.SparklineCollection.Add("D6:O6", 5, 15);

group.SparklineCollection.Add("D7:O7", 6, 15);

group.SparklineCollection.Add("D8:O8", 7, 15);

//Save the workbook

workbook.Save("output.xlsx");

在工作表中实现 GridDesktop 数据绑定功能

 'Create workbook from source Excel file

Dim m_workbook As Workbook = New Workbook("source.xlsx")

'Access first worksheet

Dim m_worksheet As Worksheet = m_workbook.Worksheets(0)

'Access the first sparkline group

Dim group As SparklineGroup = m_worksheet.SparklineGroupCollection(0)

'Add Data Ranges and Locations inside this sparkline group

group.SparklineCollection.Add("D5:O5", 4, 15)

group.SparklineCollection.Add("D6:O6", 5, 15)

group.SparklineCollection.Add("D7:O7", 6, 15)

group.SparklineCollection.Add("D8:O8", 7, 15)

'Save the workbook

m_workbook.Save("output.xlsx")

请查看文章通过指定Sparkline组的数据范围和位置复制Sparkline以获取更多信息。

Aspose.Cells 8.3.0中的公共API更改 Aspose.Cells 8.3.2中的公共API更改