本文介绍了项目详细信息页面中的Excel Web Access的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

在Project Server 2010中,我想在项目详细信息页面上使用Excel Web Access Web部件来显示包含有关项目的补充信息的电子表格。 每个项目的项目站点在其项目文档库中包含一个固定
名称的.xlsx文件。


我希望能够去项目中心,选择一个项目,并打开此项目详细信息页面。 然后,我想看一下该项目中包含数据的电子表格副本。 为了实现这一点,我相信我需要将bb参数传递给Excel Web Access Web部件 - 或者使用相对URL - 以便Excel Web Access URL根据其所属的项目进行调整。


我已经完成了少量的网络部件连接试验,但我不想让用户从过滤网页部件中选择项目名称来指定哪个项目是要显示的电子表格。


有关使用此常规框架或某种不同方法实现此目的的任何建议吗? 我的高级要求是存储和呈现不适合企业自定义字段的每个项目的信息。


谢谢,


Lee Vande Voort


解决方案

In Project Server 2010, I would like to use the Excel Web Access web part on a Project Detail Page to display a spreadsheet containing supplementary information about the project.  The project site for each project contains an .xlsx file of a fixed name within its Project Documents library.

I would like to be able to go to Project Center, choose one project, and open this Project Detail Page.  I would then like to see the copy of the spreadsheet that has data in it for this project.  To accomplish this I beleive I would need to pass a URL parameter to the Excel Web Access web part -- or perhaps use a relative URL -- so the Excel Web Access URL adjusts based on what project this pertains to.

I have done a small amount of experimenting with web part connections, but I'd rather not make the user select the name of the project from a filtering web part just to specify which project's spreadsheet to display.

Any suggestions for ways to accomplish this, either using this general framework or some different approach?  My high level requirement is to store and present information about each project that does not fit neatly into Enterprise Custom Fields.

Thanks,

Lee Vande Voort

解决方案


这篇关于项目详细信息页面中的Excel Web Access的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-26 01:45
查看更多