Gembox电子表格:为什么将Excel保存到PDF PIECHART中不能显示在Excel中
此代码导出饼图
//Pie Chart
var pieChart = worksheet.Charts.Add(ChartType.Pie, "A27", "G45");
pieChart.SelectData(worksheet.Cells.GetSubrange("G2:G6"), true, true);
pieChart.DataLabels.LabelContainsValue = true;
pieChart.DataLabels.LabelContainsPercentage = true;
pieChart.DataLabels.ShowLeaderLines = true;
pieChart.DataLabels.Separator = ", ";
pieChart.Legend.IsVisible = true;
pieChart.Legend.Position = ChartLegendPosition.Bottom;
var printOptions = worksheet.PrintOptions;
printOptions.FitWorksheetWidthToPages = 1;
printOptions.FitWorksheetHeightToPages = 1;
workbook.Save(ms, SaveOptions.PdfDefault);`enter code here`
This Code export Pie Chart
//Pie Chart
var pieChart = worksheet.Charts.Add(ChartType.Pie, "A27", "G45");
pieChart.SelectData(worksheet.Cells.GetSubrange("G2:G6"), true, true);
pieChart.DataLabels.LabelContainsValue = true;
pieChart.DataLabels.LabelContainsPercentage = true;
pieChart.DataLabels.ShowLeaderLines = true;
pieChart.DataLabels.Separator = ", ";
pieChart.Legend.IsVisible = true;
pieChart.Legend.Position = ChartLegendPosition.Bottom;
var printOptions = worksheet.PrintOptions;
printOptions.FitWorksheetWidthToPages = 1;
printOptions.FitWorksheetHeightToPages = 1;
workbook.Save(ms, SaveOptions.PdfDefault);`enter code here`
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论