vbscript ms owc 封代碼

2020-07-26 11:54:17

字體：大中小

來源：轉載

供稿：網友

復制代碼代碼如下:

''owc.vbs 
class owc 
private o 
'傳入物件 
public property set set_obj(o_id) 
set o=o_id 
end property 
'畫圖矩形圖 
'chart_bgcolor_圖表的背景顏色 
'chartCaption_圖表的標題 
'chartCaption_fontColor_圖表標題顏色 
'Interior_Color_矩形內的填充顏色 
'Caption_名稱 
'categories_名稱數組 
'values_值數組串 
public sub bar(chart_bgcolor_,chartCaption_,chartCaption_fontColor_,Interior_Color_,Caption_,categories_,values_) 
o.Clear 
set cht = o.Charts.Add 
set c = o.Constants 
cht.Type = c.chChartTypeColumnClustered 
'設背景色或是填充 
o.Charts(0).PlotArea.Interior.SetSolid chart_bgcolor_ 

'加上圖表的標題 
o.HasChartSpaceTitle = True 
set cst=o.ChartSpaceTitle 
cst.Caption = chartCaption_ 
cst.Font.Color = chartCaption_fontColor_ 
cst.Font.Italic = False 
cst.Font.Name = "Arial" 
cst.Font.Size = 12 
cst.Font.Underline = c.owcUnderlineStyleSingle 

'添加數據 
cht.SetData c.chDimCategories, c.chDataLiteral, categories_ 
cht.SeriesCollection(0).SetData c.chDimValues, c.chDataLiteral, values_ 
'直條的背景色進行設定 
set sc=o.Charts(0).SeriesCollection(0) 
sc.Interior.Color=Interior_Color_ 

'直條上的顯示設置 
sc.Caption=Caption_ 
set dl = cht.SeriesCollection(0).DataLabelsCollection.Add 
dl.HasValue = True 
dl.HasPercentage = False 
dl.Font.Size = 9 
dl.Font.Color = "red" 
dl.Position = c.chLegendPositionRight 
dl.NumberFormat = "00.00%" 
'左邊百分比的屬性設置 
Set cta = cht.Axes(c.chAxisPositionLeft) 
cta.Font.Size = 9 
cta.NumberFormat = "0.0%" 
cta.MajorUnit = 0.1 
end sub 
'多系列矩形圖 
'chart_bgColor_圖表的背景顏色 
'chartCaption_圖表的標題 
'chartCaption_fontColor_圖表標題顏色 
'color_顏色數組 
'caption_名稱數組 
'categories_名稱數組 
'values_值數組 
public sub serBar(chart_bgColor_,chartCaption_,chartCaption_fontColor_,color_,caption_,categories_,values_) 
o.Clear 
o.Charts.Add 
Set c = o.Constants 
'圖表的類型 
o.Charts(0).type=c.chChartTypeColumnClustered 
'給繪圖區加背景色 
o.Charts(0).PlotArea.Interior.SetSolid chart_bgColor_ 
''加上圖表的標題 
o.HasChartSpaceTitle = True 
o.ChartSpaceTitle.Caption = chartCaption_ 
'標題的屬性 
o.ChartSpaceTitle.Font.Color = chartCaption_fontColor_ 
o.ChartSpaceTitle.Font.Italic = False 
o.ChartSpaceTitle.Font.Name = "Arial" 
o.ChartSpaceTitle.Font.Size = 12 
o.ChartSpaceTitle.Font.Underline = c.owcUnderlineStyleSingle 
'用循環來新增SeriesCollection以及里面的內容 
for i=0 to ubound(caption_) 
valuetemp="" 
for j = i*(ubound(categories_)+1) to (i+1)*(ubound(categories_)+1)-1 
valuetemp = valuetemp & "," & values_(j) 
next 
valuearr = split(mid(valuetemp,2),",") 
o.Charts(0).SeriesCollection.Add 
o.Charts(0).SeriesCollection(i).Caption = caption_(i) 
o.Charts(0).SeriesCollection(i).Interior.Color = color_(i) 
o.Charts(0).SeriesCollection(i).SetData c.chDimCategories, c.chDataLiteral, categories_ 
o.Charts(0).SeriesCollection(i).SetData c.chDimValues, c.chDataLiteral, valuearr 
set dl = o.Charts(0).SeriesCollection(i).DataLabelsCollection.Add 
dl.HasValue = True 
dl.HasPercentage = False 
dl.Font.Size = 9 
dl.Font.Color = "red" 
dl.Position = c.chLegendPositionRight 
dl.NumberFormat = "00.00%" 
next 
''圖例的設定 
o.Charts(0).HasLegend = True 
o.Charts(0).Legend.Font.Size = 9 
o.Charts(0).Legend.Position = c.chLegendPositionBottom 
''左邊百分比的屬性設置 
Set cta = o.Charts(0).Axes(c.chAxisPositionLeft) 
cta.Font.Size = 9 
cta.NumberFormat = "0.00%" 
cta.MajorUnit = 0.1 
end sub 
'畫圓餅圖 
'chart_bgColor_繪圖區加背景色 
'chartCaption_圖表的標題 
'chartCaption_fontColor_圖表標題顏色 
public sub Pie(chart_bgColor_,chartCaption_,chartCaption_fontColor_,Caption_,categories_,values_) 
o.Clear 
Set cht = o.Charts.Add 
Set c = o.Constants 
cht.Type = c.chChartTypePie3d 
'給繪圖區加背景色 
o.Charts(0).PlotArea.Interior.SetSolid chart_bgColor_ 
cht.ExtrudeAngle = 90 
cht.ChartDepth = 169 
cht.AspectRatio = 120 
cht.Rotation =180 
cht.Inclination=70 

o.HasChartSpaceTitle = True 
o.ChartSpaceTitle.Caption = chartCaption_ 
o.ChartSpaceTitle.Font.Color = chartCaption_fontColor_ 
o.ChartSpaceTitle.Font.Name = "Arial" 
o.ChartSpaceTitle.Font.Size = 12 
o.ChartSpaceTitle.Font.Underline = c.owcUnderlineStyleSingle 

cht.HasLegend = True 
cht.Legend.Font.Size = 9 
cht.Legend.Position = c.chLegendPositionBottom 

cht.SetData c.chDimCategories, c.chDataLiteral, categories_ 
cht.SeriesCollection(0).SetData c.chDimValues, c.chDataLiteral, values_ 
set sc=o.Charts(0).SeriesCollection(0) 
sc.Caption=Caption_ 
Set dl = cht.SeriesCollection(0).DataLabelsCollection.Add 
dl.Separator = "：" 
dl.HasValue = false 
dl.HasSeriesName = false 
dl.HasCategoryName=true 
dl.HasPercentage = true 
dl.Font.Size = 9 
dl.Font.Color = "red" 
dl.NumberFormat = "00.00%" 
end sub 
'拆線圖 
'chart_bgColor_繪圖區加背景色 
'chartCaption_圖表的標題 
'chartCaption_fontColor_圖表標題顏色 
public sub line(chart_bgColor_,chartCaption_,chartCaption_fontColor_,Caption_,categories_,values_) 
o.Clear 
Set cht = o.Charts.Add 
Set c = o.Constants 
cht.Type = c.chChartTypeLineMarkers 
'給繪圖區加背景色 
o.Charts(0).PlotArea.Interior.SetSolid chart_bgColor_ 
o.HasChartSpaceTitle = True 
o.ChartSpaceTitle.Caption = chartCaption_ 
o.ChartSpaceTitle.Font.Color = chartCaption_fontColor_ 
o.ChartSpaceTitle.Font.Name = "Arial" 
o.ChartSpaceTitle.Font.Size = 12 
o.ChartSpaceTitle.Font.Underline = c.owcUnderlineStyleSingle 

cht.SetData c.chDimCategories, c.chDataLiteral, categories_ 
cht.SeriesCollection(0).SetData c.chDimValues, c.chDataLiteral, values_ 

set sc=o.Charts(0).SeriesCollection(0) 
sc.Caption=Caption_ 
Set dl = cht.SeriesCollection(0).DataLabelsCollection.Add 
dl.HasValue = True 
dl.HasPercentage = False 
dl.Font.Size = 9 
dl.Font.Color = "red" 

Set categoryAxis = cht.Axes(c.chAxisPositionBottom) 
categoryAxis.Font.Size = 9 

Set categoryAxis = cht.Axes(c.chAxisPositionLeft) 
categoryAxis.Font.Size = 9 
end sub 
'多系列拆線圖 
'chart_bgColor_圖表的背景顏色 
'chartCaption_圖表的標題 
'chartCaption_fontColor_圖表標題顏色 
'color_顏色數組 
'caption_名稱數組 
'categories_名稱數組 
'values_值數組 
public sub serLine(chart_bgColor_,chartCaption_,chartCaption_fontColor_,color_,SeriesNames_,categories_,values_) 
o.Clear 
Set cht = o.Charts.Add 
Set c = o.Constants 
'設置圖表類型 
cht.Type = c.chChartTypeLineMarkers 
'給繪圖區加背景色 
o.Charts(0).PlotArea.Interior.Color=chart_bgColor_ 
'加上標題 
o.HasChartSpaceTitle = True 
o.ChartSpaceTitle.Caption = chartCaption_ 
o.ChartSpaceTitle.Font.Color = chartCaption_fontColor_ 
o.ChartSpaceTitle.Font.Name = "Arial" 
o.ChartSpaceTitle.Font.Size = 12 
''添加數據 
cht.SetData c.chDimSeriesNames, c.chDataLiteral, SeriesNames_ 
cht.SetData c.chDimCategories, c.chDataLiteral, Categories_ 

set categoryAxis = cht.Axes(c.chAxisPositionBottom) 
categoryAxis.Font.Size = 9 

Set categoryAxis = cht.Axes(c.chAxisPositionLeft) 
categoryAxis.Font.Size = 9 

for i = 0 to ubound(SeriesNames_) 
valuetemp = "" 
for j = i*(ubound(Categories_)+1) to (i+1)*(ubound(Categories_)+1)-1 
valuetemp = valuetemp & "," & values_(j) 
next 
valuearr = split(mid(valuetemp,2),",") 
cht.SeriesCollection(i).SetData c.chDimValues, c.chDataLiteral, valuearr 
cht.SeriesCollection(i).Line.Color = color_(i) 
cht.SeriesCollection(i).Line.Weight = c.owcLineWeightThin 
cht.SeriesCollection(i).Marker.Style = c.chMarkerStyleDiamond 
cht.SeriesCollection(i).Interior.Color = color_(i) 
Set dl = cht.SeriesCollection(i).DataLabelsCollection.Add 
dl.HasValue = true 
dl.HasPercentage = false 
dl.Font.Size = 9 
dl.font.color="red" 
next 
end sub 
'清除圖型 
public sub clear() 
o.Clear 
end sub 
end class 

使用測試代碼：

復制代碼代碼如下:

<html>
<head>
<title>vbscript owc class test</title>
<script language="vbscript" src="owc.vbs"></script>
<script language="vbscript">
sub window_onload()
set t = new owc

categories =Array("A2-1","A2-2","A2-3","A3-1","A3-2","A3-3"_
,"B2-1","B2-2","B2-3","B3-1","B3-2","B3-3"_
,"C2-1","C2-2","C3-1","C3-2","C3-3")
values = Array(0.813,0.689,0.800,0.833,0.681,0.864,0.743_
,0.894,0.822,0.874,0.746,0.908,0.850_
,0.728,0.731,0.734,0.624)
set t.set_obj=document.getElementById("cs1")
t.bar "#FFFFFF","報表標題","BLUE","#CCCC00","組別",categories,values

color=Array("#CCFFFF","#99CCFF","#00CCFF","#FF0000","#660066","#FF8080")
caption=Array("第1周","第2周","第3周","第4周")
categories=Array("A棟","B棟")
values=Array(0.6951,0.5798,0.7075,0.512,0.7907,0.7493,0.8691,0.7716)
set t.set_obj=document.getElementById("cs2")
t.serbar "#FFFFFF","2008年10月坑頭三廠各周各樓層達成率比較圖","red",color,caption,categories,values

categories=array("臺北","上海")
values = array(238760,912560.62)
set t.set_obj=document.getElementById("cs3")
t.Pie "#FFFFFF","銷售金額所国产激情自拍_国产9色视频_丁香花在线电影小说观看 _久久久久国产精品嫩草影院