半岛外围网上直营

支持在将 PDF 转换为 Doc/Docx 时设置文档属性。

Spire.Pdf.Conversion.PdfToDocConverter doc = new Spire.Pdf.Conversion.PdfToDocConverter(inputFile);
doc.DocxOptions.Title = "PDFTODOCX";
doc.DocxOptions.Subject = "Set document properties.";
doc.DocxOptions.Tags = "Test Tags";
doc.DocxOptions.Categories = "PDF";
doc.DocxOptions.Commments = "This document just for testing the properties";
doc.DocxOptions.Authors = "TEST";
doc.DocxOptions.LastSavedBy = "/E-iceblue";
doc.DocxOptions.Revision = (int)7.9;
doc.DocxOptions.Version = "csharp V4.0";
doc.DocxOptions.ProgramName = "Spire.Pdf for .NET";
doc.DocxOptions.Company = "E-iceblue";
doc.DocxOptions.Manager = "Test";
doc.SaveToDocx(outputFile);

工作簿工作簿 = new Workbook(); 

workbook.LoadFromFile("waterfall_sample.xlsx"); 
var sheet = workbook.Worksheets[0]; 
var officeChart = sheet.Charts.Add(); 
//设置图表类型为瀑布
officeChart.ChartType = ExcelChartType.WaterFall; 

//将工作表中的数据范围设置为图表
officeChart.DataRange = sheet["A2:B8"]; 

//数据点设置为图表中的总数
officeChart.Series[0].DataPoints[3].SetAsTotal = true; 
officeChart.Series[0].DataPoints[6].SetAsTotal = true; 

//显示数据点之间的连接线
officeChart.Series[0].Format.ShowConnectorLines = true; 

//设置图表标题
officeChart.ChartTitle = "Company Profit (in USD)";

//格式化数据标签和图例选项
officeChart.Series[0].DataPoints.DefaultDataPoint.DataLabels.HasValue = true; 
officeChart.Series[0].DataPoints.DefaultDataPoint.DataLabels.Size = 8; 
officeChart.Legend.Position = LegendPositionType.Right; 
workbook.SaveToFile("waterfall_chart.xlsx"); 
工作簿工作簿 = new Workbook();

                      



workbook.LoadFromFile("Pareto_sample.xlsx"); 
var sheet = workbook.Worksheets[0]; 
var officeChart = sheet.Charts.Add(); 
//设置图表类型为Pareto 
officeChart.ChartType = ExcelChartType.Pareto; 

//在工作表中设置数据范围   
officeChart.DataRange = sheet["A2:B8"]; 

//将类别值设置为 bin 值   
officeChart.PrimaryCategoryAxis.IsBinningByCategory = true; 

officeChart.PrimaryCategoryAxis.OverflowBinValue = 5; 
officeChart.PrimaryCategoryAxis.UnderflowBinValue = 1; 

//格式化帕累托线      
officeChart.Series[0].ParetoLineFormat.LineProperties.Color = System.Drawing.Color.Blue; 

//间隙宽度设置
officeChart.Series[0].DataFormat.Options.GapWidth = 6; 

//设置图表标题
officeChart.ChartTitle = "Expenses"; 

//隐藏图例
officeChart.HasLegend = false; 
workbook.SaveToFile("Pareto_chart.xlsx");

                  

工作簿工作簿 = new Workbook(); 
workbook.LoadFromFile("Histogram_sample.xlsx"); 
var sheet = workbook.Worksheets[0]; 
var officeChart = sheet.Charts.Add(); 
//设置图表类型为直方图       
officeChart.ChartType = ExcelChartType.Histogram; 

//在工作表中设置数据范围   
officeChart.DataRange = sheet["A1:A15"]; 

//类别轴bin设置        
officeChart.PrimaryCategoryAxis.BinWidth = 8; 

//间隙宽度设置
officeChart.Series[0].DataFormat.Options.GapWidth = 6; 

//设置图表标题和轴标题
officeChart.ChartTitle = "Height Data"; 
officeChart.PrimaryValueAxis.Title = "学生人数";
officeChart.PrimaryCategoryAxis.Title = "高度"; 

//隐藏图例
officeChart.HasLegend = false; 
workbook.SaveToFile("Histogram_chart.xlsx");

                                         


工作簿工作簿 = new Workbook(); 

workbook.LoadFromFile("Boxandwhisker_sample.xlsx"); 
var sheet = workbook.Worksheets[0]; 
var officeChart = sheet.Charts.Add(); 
//设置图表标题
officeChart.ChartTitle = "Yearly Vehicle Sales"; 

//设置图表类型为Box and Whisker 
officeChart.ChartType = ExcelChartType.BoxAndWhisker; 

//在工作表中设置数据范围
officeChart.DataRange = sheet["A1:E17"]; 

//第一个系列的盒子和胡须设置
var seriesA = officeChart.Series[0]; 
seriesA.DataFormat.ShowInnerPoints = false; 
seriesA.DataFormat.ShowOutlierPoints = true; 
seriesA.DataFormat.ShowMeanMarkers = true; 
seriesA.DataFormat.ShowMeanLine = false;
seriesA.DataFormat.QuartileCalculationType = ExcelQuartileCalculation.ExclusiveMedian; 

//第二个系列的盒子和胡须设置   
var seriesB = officeChart.Series[1]; 
seriesB.DataFormat.ShowInnerPoints = false; 
seriesB.DataFormat.ShowOutlierPoints = true; 
seriesB.DataFormat.ShowMeanMarkers = true; 
seriesB.DataFormat.ShowMeanLine = false; 
seriesB.DataFormat.QuartileCalculationType = ExcelQuartileCalculation.InclusiveMedian; 

//第三个系列的盒子和胡须设置   
var seriesC = officeChart.Series[2]; 
seriesC.DataFormat.ShowInnerPoints = false; 
seriesC.DataFormat.ShowOutlierPoints = true; 
seriesC.DataFormat.ShowMeanMarkers = true;
seriesC.DataFormat.ShowMeanLine = false; 
seriesC.DataFormat.QuartileCalculationType = ExcelQuartileCalculation.ExclusiveMedian; 

workbook.SaveToFile("Boxandwhisker_chart.xlsx");

工作簿工作簿 = new Workbook(); 

workbook.LoadFromFile("treemap_sample.xlsx"); 
var sheet = workbook.Worksheets[0]; 
var officeChart = sheet.Charts.Add(); 
//设置图表类型为TreeMap 
officeChart.ChartType = ExcelChartType.TreeMap; 

//在工作表中设置数据范围
officeChart.DataRange = sheet["A2:C11"]; 

//设置图表标题
officeChart.ChartTitle = "Area by countries"; 

//设置
Treemap标签选项officeChart.Series[0].DataFormat.TreeMapLabelOption = ExcelTreeMapLabelOption.Banner; 

//格式化数据标签      
officeChart.Series[0].DataPoints.DefaultDataPoint.DataLabels.Size = 8; 

workbook.SaveToFile("treemap_chart.xlsx");

工作簿工作簿 = new Workbook(); 

workbook.LoadFromFile("Sunburst_sample.xlsx"); 
var sheet = workbook.Worksheets[0]; 
var officeChart = sheet.Charts.Add(); 
//设置图表类型为Sunburst 
officeChart.ChartType = ExcelChartType.SunBurst; 

//在工作表中设置数据范围
officeChart.DataRange = sheet["A1:D16"]; 

//设置图表标题
officeChart.ChartTitle = "Sales by Annual"; 

//格式化数据标签      
officeChart.Series[0].DataPoints.DefaultDataPoint.DataLabels.Size = 8; 

//隐藏图例
officeChart.HasLegend = false; 

workbook.SaveToFile("Sunburst_chart.xlsx");

工作簿工作簿 = new Workbook(); 

workbook.LoadFromFile("Funnel_sample.xlsx"); 
var sheet = workbook.Worksheets[0]; 
var officeChart = sheet.Charts.Add(); 
//设置图表类型为漏斗
officeChart.ChartType = ExcelChartType.Funnel; 

//在工作表中设置数据范围
officeChart.DataRange = sheet.Range["A1:B6"]; 

//设置图表标题
officeChart.ChartTitle = "Funnel"; 

//格式化图例和数据标签选项
officeChart.HasLegend = false; 
officeChart.Series[0].DataPoints.DefaultDataPoint.DataLabels.HasValue = true; 
officeChart.Series[0].DataPoints.DefaultDataPoint.DataLabels.Size = 8; 

workbook.SaveToFile("Funnel_chart.xlsx");