OWC控件显示EXCEL透视表??新手上路请多多指教,非常感谢!!! 我现在要用OWC控件显示EXCEL透视表,不知道从哪下手,请高手指教!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 给你个例子,是ADO+OWC的,应该大同小异,希望对你有帮助.ReDim arrClass(rdsRecords.RecordCount)ReDim arrCR(rdsRecords.RecordCount)ReDim arrLoss(rdsRecords.RecordCount)rdsRecords.MoveFirst k = 1 Do While Not rdsRecords.EOF arrClass(k) = rdsRecords.Fields("测试类型").Value arrCR(k) = Format(rdsRecords.Fields("接通率").Value, "###.000") arrLoss(k) = 1 - Format(arrCR(k), "###.00") k = k + 1 rdsRecords.MoveNext Loop rdsRecords.MoveFirst' Process The OfficeChart (2D-Bar)With ChartSpace1 .Clear .Charts.Add .Charts(0).Type = chChartTypeColumnStacked .Charts(0).SeriesCollection.Add .Charts(0).SeriesCollection(0).DataLabelsCollection.Add .Charts(0).Axes(chAxisPositionLeft).Scaling.Maximum = 1 For j = 1 To UBound(arrClass) .Charts(0).SeriesCollection(0).Caption = "接通率" .Charts(0).SeriesCollection(0).SetData chDimCategories, chDataLiteral, arrClass .Charts(0).SeriesCollection(0).SetData chDimValues, chDataLiteral, arrCR .Charts(0).SeriesCollection(0).DataLabelsCollection(0).HasValue = True .Charts(0).SeriesCollection(0).DataLabelsCollection(0).NumberFormat = "##0.00%" Next .Charts(0).HasLegend = True .Charts(0).HasTitle = True .Charts(0).Title.Caption = "接通率" .Charts(0).Title.Font.Size = 14 .Charts(0).Title.Font.Underline = True .Charts(0).Axes(chAxisPositionLeft).NumberFormat = "#00.00%" .Charts(0).Axes(chAxisPositionLeft).Font.Size = 10 .Charts(0).Axes(chAxisPositionBottom).Font.Size = 10 .Charts(0).Legend.Font.Size = 9 .Charts(0).Axes(chAxisPositionLeft).MajorUnit = 0.1End With' End Process控件的其他属性和方法请查看控件的帮助文件. 关于获取输入框句柄问题 请帮忙解决WinXP与Win98双系统的启动难题?(在线等待) ****关于VB的问题,请教各位!!**** 如何合成多幅GIF动画 控件小问题,高分求助 贪吃蛇 的思路 及原码 谢谢 字符集小问题??? 下面的C语言程序转为VB该怎么写啊? 如何定义一个全局的动态的二维数组? 疑难问题征解 数据库筛选查询问题! 用VB如何实现在内存中开辟一个存储大量数据的空间?
ReDim arrCR(rdsRecords.RecordCount)
ReDim arrLoss(rdsRecords.RecordCount)
rdsRecords.MoveFirst
k = 1
Do While Not rdsRecords.EOF
arrClass(k) = rdsRecords.Fields("测试类型").Value
arrCR(k) = Format(rdsRecords.Fields("接通率").Value, "###.000")
arrLoss(k) = 1 - Format(arrCR(k), "###.00")
k = k + 1
rdsRecords.MoveNext
Loop
rdsRecords.MoveFirst' Process The OfficeChart (2D-Bar)
With ChartSpace1
.Clear
.Charts.Add
.Charts(0).Type = chChartTypeColumnStacked
.Charts(0).SeriesCollection.Add
.Charts(0).SeriesCollection(0).DataLabelsCollection.Add
.Charts(0).Axes(chAxisPositionLeft).Scaling.Maximum = 1
For j = 1 To UBound(arrClass)
.Charts(0).SeriesCollection(0).Caption = "接通率"
.Charts(0).SeriesCollection(0).SetData chDimCategories, chDataLiteral, arrClass
.Charts(0).SeriesCollection(0).SetData chDimValues, chDataLiteral, arrCR
.Charts(0).SeriesCollection(0).DataLabelsCollection(0).HasValue = True
.Charts(0).SeriesCollection(0).DataLabelsCollection(0).NumberFormat = "##0.00%"
Next
.Charts(0).HasLegend = True
.Charts(0).HasTitle = True
.Charts(0).Title.Caption = "接通率"
.Charts(0).Title.Font.Size = 14
.Charts(0).Title.Font.Underline = True
.Charts(0).Axes(chAxisPositionLeft).NumberFormat = "#00.00%"
.Charts(0).Axes(chAxisPositionLeft).Font.Size = 10
.Charts(0).Axes(chAxisPositionBottom).Font.Size = 10
.Charts(0).Legend.Font.Size = 9
.Charts(0).Axes(chAxisPositionLeft).MajorUnit = 0.1
End With
' End Process控件的其他属性和方法请查看控件的帮助文件.