C# Spire.Xls -数据表错误(添加图例键)
C# Spire.Xls -数据表错误(添加图例键)
提问于 2017-02-23 18:57:59
这是我的代码：
using System.Drawing;
using Spire.Xls;
using System;
using System.Windows.Forms.DataVisualization;
using Spire.Xls.Charts;
namespace XLS_Program
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:\Users\my_user\Desktop\export222.xls");
Worksheet sheet = workbook.Worksheets["Chart1"];
/* there was some code here, not important */
chart = sheet.Charts.Add(ExcelChartType.ColumnClustered);
chart.DataRange = sheet.Range[range_s];
chart.SeriesDataFromRange = true;
chart.HasDataTable = true;
chart.DataTable.ShowSeriesKeys = true;
chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90;
chart.Legend.Position = LegendPositionType.Right;
workbook.SaveToFile("Excel_Charts.xlsx",ExcelVersion.Version2010);
System.Diagnostics.Process.Start("Excel_Charts.xlsx");
}
}
}它工作得很好。但有一个例外。这一行：
chart.DataTable.ShowSeriesKeys = true;是否存在错误：
System.InvalidCastException: Unable to cast object of type 'Spire.Xls.Core.Spreadsheet.Charts.ChartDataTableXls' to type 'Spire.Xls.Charts.ChartDataTable'.
at Spire.Xls.Chart.get_DataTable()
at XLSTest.Program.Main(String[] args) in c:\Users\my_user\Documents\SharpDevelop Projects\projekt1\projekt1\Program.cs:line 81我正在尝试将图例键添加到我的图表中。我以为这句话能帮到我。你知道怎么修吗？
回答 2
Stack Overflow用户
回答已采纳
发布于 2017-02-28 23:00:30
试试这个：
(chart as Spire.Xls.Core.Spreadsheet.Shapes.XlsChartShape).DataTable.ShowSeriesKeys = true;Stack Overflow用户
发布于 2017-02-24 18:00:54
尝试使用以下代码来设置图例键：
foreach (ChartSerie cs in chart.Series)
{
cs.DataPoints.DefaultDataPoint.DataLabels.HasLegendKey = true;
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/42413785
复制相关文章
相似问题
腾讯云开发者
