C# Openxml在word的图表中插入一条折线,要设置这条线的图表类型为折线图
时间: 2024-03-21 17:39:54 浏览: 217
C#折线图类
4星 · 用户满意度95%
您可以按照以下步骤在Word的图表中插入一条折线并设置为折线图:
1. 使用C# Openxml代码创建一个Word文档并添加一个图表。
```
//创建Word文档
WordprocessingDocument wordDocument = WordprocessingDocument.Create("Document.docx", WordprocessingDocumentType.Document);
//添加一个空白段落
MainDocumentPart mainPart = wordDocument.AddMainDocumentPart();
mainPart.Document = new Document();
Body body = mainPart.Document.AppendChild(new Body());
Paragraph para = body.AppendChild(new Paragraph());
//添加一个图表
ChartPart chartPart = mainPart.AddNewPart<ChartPart>();
chartPart.ChartSpace = new ChartSpace(new EditingLanguage() { Val = new StringValue("en-US") });
Chart chart = chartPart.ChartSpace.AppendChild(new Chart());
```
2. 在图表中添加一个数据系列,并将其类型设置为折线图。
```
//添加一个数据系列
LineChartSeries lineChartSeries = chart.PlotArea.AppendChild(new LineChartSeries());
uint index = 0;
string seriesText = "Series 1";
string rangeReference = "Sheet1!$A$1:$B$5";
DocumentFormat.OpenXml.Drawing.Charts.Values values = lineChartSeries.AppendChild(new DocumentFormat.OpenXml.Drawing.Charts.Values());
DocumentFormat.OpenXml.Drawing.Charts.NumberReference numberReference = values.AppendChild(new DocumentFormat.OpenXml.Drawing.Charts.NumberReference());
numberReference.AppendChild(new DocumentFormat.OpenXml.Drawing.Charts.Formula() { Text = rangeReference });
numberReference.AppendChild(new DocumentFormat.OpenXml.Drawing.Charts.NumberingCache());
lineChartSeries.AppendChild(new Index() { Val = new UInt32Value(index) });
lineChartSeries.AppendChild(new Order() { Val = new UInt32Value(index) });
lineChartSeries.AppendChild(new SeriesText(new NumericValue() { Text = seriesText }));
//将数据系列类型设置为折线图
LineChart lineChart = chart.PlotArea.InsertAfter(new LineChart(), chart.PlotArea.Descendants<ScatterChart>().First());
lineChartSeries.ChartType = lineChart.ChartSubElementType;
```
3. 在折线图中添加一条折线。
```
//添加一条折线
LineChartSeries lineChartSeries2 = chart.PlotArea.AppendChild(new LineChartSeries());
lineChartSeries2.AppendChild(new Index() { Val = new UInt32Value(1) });
lineChartSeries2.AppendChild(new Order() { Val = new UInt32Value(1) });
string seriesText2 = "Series 2";
string rangeReference2 = "Sheet1!$A$1:$C$5";
DocumentFormat.OpenXml.Drawing.Charts.Values values2 = lineChartSeries2.AppendChild(new DocumentFormat.OpenXml.Drawing.Charts.Values());
DocumentFormat.OpenXml.Drawing.Charts.NumberReference numberReference2 = values2.AppendChild(new DocumentFormat.OpenXml.Drawing.Charts.NumberReference());
numberReference2.AppendChild(new DocumentFormat.OpenXml.Drawing.Charts.Formula() { Text = rangeReference2 });
numberReference2.AppendChild(new DocumentFormat.OpenXml.Drawing.Charts.NumberingCache());
lineChartSeries2.AppendChild(new SeriesText(new NumericValue() { Text = seriesText2 }));
lineChartSeries2.ChartShapeProperties = new ChartShapeProperties();
lineChartSeries2.ChartShapeProperties.AppendChild(new NoFill());
//将折线的线条颜色设置为黑色
DocumentFormat.OpenXml.Drawing.Charts.LineProperties lineProperties = lineChartSeries2.AppendChild(new DocumentFormat.OpenXml.Drawing.Charts.LineProperties());
SolidFill solidFill = new SolidFill();
RgbColorModelHex rgbColorModelHex = new RgbColorModelHex() { Val = "000000" };
solidFill.AppendChild(rgbColorModelHex);
lineProperties.AppendChild(solidFill);
```
4. 对折线进行其他设置,如添加数据标签等。
```
//添加数据标签
DataLabels dataLabels = lineChartSeries2.AppendChild(new DataLabels());
ShowValue showValue = new ShowValue() { Val = true };
dataLabels.AppendChild(showValue);
//设置折线的宽度
lineProperties.AppendChild(new Width() { Val = 28575 });
//设置折线的样式
lineProperties.AppendChild(new DashStyle() { Val = DocumentFormat.OpenXml.Drawing.Charts.LineDashStyleValues.Solid });
```
以上代码可以在C# Openxml中插入一条折线并设置为折线图。
阅读全文