如题,Dev控件DevExpress.XtraSpreadsheet.SpreadsheetControl或者DevExpress.Spreadsheet.SpreadsheetControl这两个控件(类似)中,如何选定Range然后对选定的Range生成统计图。
spreadsheetControl1.BeginUpdate();
Worksheet worksheet = spreadsheetControl1.ActiveWorksheet;
Chart chart = worksheet.Charts.Add(ChartType.Line);
chart = spreadsheetControl1.SelectedShape as Chart;
ChartData argumentChartData = new ChartData();
argumentChartData.RangeValue = WorkSheets[0]["A3:A393"];
ChartData valueChartData = new ChartData();
valueChartData.RangeValue = WorkSheets[0]["H3:H393"];
Series series = _currentChart.Series.Add("title", argumentChartData, valueChartData);
series.Outline.Width = 2;
series.AxisGroup = AxisGroup.Secondary;
spreadsheetControl1.EndUpdate();
以上代码无法使用.