项目详细信息页面中的Excel Web Access [英] Excel Web Access in Project Detail Page

问题描述

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

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

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

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

谢谢，

Lee Vande Voort

解决方案

看看我关于这个主题的一些博文，但基本上：

1）创建SQL查询以将数据作为Office数据连接提取到Excel中。 作为该连接的一部分，您需要将ProjectUID字段转换为Excel可以呈现的内容，因此您的SQL查询应该类似于CAST（P.ProjectUID
AS VARCHAR（36））AS ProjectUID。

2）在Excel图表中，确保它可以根据ProjectUID字段进行过滤。

3）将Excel图表推送到SharePoint时，请确保提升包含ProjectUID字段的单元格。

4）然后，在创建PDP时，添加查询字符串过滤器WebPart。 配置它以从URL中提取ProjUID参数。

5）添加Excel Webpart，并将Excel WebPart连接到查询字符串过滤器Webpart，以便它将ProjectUID传递到Excel文档。

听起来很多，但通过一些练习，它非常快速和简单。 这是一个例子：

http://azlav.umtblog.com/2012/07/03/creating-a-project-resource-list-in-a-pdp/

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

解决方案

Take a look at some of my blog posts on the topic, but essentially:

1) Create a SQL query to pull the data into Excel as an Office Data Connection.  As part of that connection, you need to convert the ProjectUID field into something that Excel can render, so your SQL query should look something like CAST(P.ProjectUID AS VARCHAR(36)) AS ProjectUID.

2) In your Excel chart, ensure that it can filter based on the ProjectUID field.

3) When pushing the Excel chart to SharePoint, ensure you promote the cell containing the ProjectUID field.

4) Then, when you make the PDP, add the Query String Filter WebPart.  Configure it to pull the ProjUID parameter from the URL.

5) Add your Excel Webpart, and connect the Excel WebPart to the Query String Filter Webpart so that it passed the ProjectUID into the Excel document.

Sounds like a lot, but with a bit of practice, it's pretty quick and easy.  Here's an example:

http://azlav.umtblog.com/2012/07/03/creating-a-project-resource-list-in-a-pdp/

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