支持在將 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");