可枢转的CurrentPage问题 [英] Pivottable CurrentPage Qestion

查看:89
本文介绍了可枢转的CurrentPage问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

有人可以告诉我为什么在vba中可以使用以下代码在vb.net中没有获得价值吗?感谢您的帮助.

Can someone tell me why I'm not getting a value in vb.net with the following code when  it works in vba. Your help is appreciated.

Dim objField As PivotField            For i = 0 To chart.Conditions.Count - 1                sTemp = chart.Conditions(i).Title                objField = pt.PageFields(sTemp)                If String.IsNullOrEmpty(sConditionTitles) Then                    sConditionTitles = sTemp & "=" & objField.CurrentPage.ToString                Else                    sConditionTitles = sConditionTitles & ";" & sTemp & "=" & objField.CurrentPage.ToString                End If            Next

谢谢


卫斯理

Thanks,


wesley

推荐答案

什么是可旋转页面"?它与Microsoft Word或Microsoft Accel一起使用吗?图表与它有什么关系?您是否在表单上使用图表控件"?还是此图表是Microsoft Office应用程序中的图表?

What is a "pivotable page"? Is it something used with Microsoft Word or Microsoft Accel? And what do charts have to do with it? Are you using the Chart Control on a form? Or is this Chart a Chart from a Microsoft Office application?

如果您需要了解如何使用VB.Net自动执行Microsoft Office应用程序,那么我建议您使用 MSDN搜索引擎,也许可以像下面的链接一样进行搜索.

If you need to know how to automate Microsoft Office applications with VB.Net then I suggest you search for assistance using the MSDN Search Engine and maybe do a search like the below link did.

自动执行Microsoft Office 2010 Visual Studio VB.Net MSDN


这篇关于可枢转的CurrentPage问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆