应用图表Style

应用ChartStyle ()+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++wblele

设置当前图样式ID

参数:

返回时间 :

类型

布林安

实例

builder.CreateFile("xlsx")!varoWorksheetoWorksheet.GetRange("B1").SetValue(2014)!oWorksheet.GetRange("C1").SetValue(2015)!oWorksheet.GetRange("D1").SetValue(2016)!oWorksheet.GetRange("A2").SetValue("Projected Revenue")!oWorksheet.GetRange("A3").SetValue("Estimated Costs")!oWorksheet.GetRange("B2").SetValue(200)!oWorksheet.GetRange("B3").SetValue(250)!oWorksheet.GetRange("C2").SetValue(240)!oWorksheet.GetRange("C3").SetValue(260)!oWorksheet.GetRange("D2").SetValue(280)!oWorksheet.GetRange("D3").SetValue(280)!Varocart=oWorkshell.ettitle(金融概述,13)oChart.ApplyChartStyle(2)!varoFinll =api.CreateSolidFillsetSeriesFillVar.CreateStroke(0.5*36000,Api.CreateSolidFill(Api.CreateRGBColor(51515151)))setSeriesOutLinei.CreteRGBColor(255,111,61)setSeriesFillstroke = Api.Createstroke(0.5*36000,Api.CreateSolidFill(Api.CreateRGBColor(255,111,61)))setSeriesOutLinebuilder.SaveFile("xlsx", "ApplyChartStyle.xlsx")!builder.CloseFile();

结果文档