提取“资源使用”从MS Project到XML [英] Extract "Resource Usage" from MS Project to XML

问题描述

摘要：

Summary:

我需要帮助将MS Project资源使用数据提取到XML。

I need help extracting MS Project Resource Usage data to XML.

  ;

环境：

C＃/。NET，Project 2010,2007和20/03独立。

C#/.NET, Project 2010, 2007, and 20/03 standalone.

 

场景：

我需要一个可以从"资源使用"中提取信息的程序。将MS Project视图转换为XML（最终转换为Excel）。还有一个步骤，需要将资源名称映射到官方资源名称，但我还没有
。

I need a program that can extract the information from the "Resource Usage" view of MS Project into XML (and eventually into Excel). There is another step in between that needs to map resource names to official resource names but I'm not there yet.

 

资源使用情况视图：

显示与预计为每个"任务"工作的小时数相关联的每个工作人员（"资源"）。对于每个月。

Shows each worker ("Resource") associated with the hours they are projected to work for each "Task" for each Month.

 

问题：

我能够打开项目文件在C＃中。我能够访问各种事物（人名，总时数，任务等）。但是我很难找到工人和任务之间以及几个月之间保存映射的位置。我希望以下
：

I am able to open up the project file in C#. I'm able to access various things (People's names, their total hours, tasks, etc. etc.). But I'm having trouble finding where the mappings are saved between workers and tasks and months. I was hoping to go with the following:

1。通过每个工人：

foreach






 (MSProject.Resource resource in






 proj.Resources)

推荐答案

我强烈建议你在VBA中使用它然后转换为C＃。除非您使用的是VS 2010 VB.Net将是一个更快更容易的端口（命名和可选参数等）。

I strongly recommend you get this working in VBA then translate to C#. Unless you're using VS 2010 VB.Net will be a much faster and easier port (named and optional parameters etc.).

有关timescaledata方法的帮助，请阅读我的书中的章节在MSDN上：

For help on timescaledata method, read the chapter from my book on MSDN:

http://msdn.microsoft.com/en-us/library/ee355231(v = office.12）.aspx

http://msdn.microsoft.com/en-us/library/ee355231(v=office.12).aspx

Project 2010版本3月15日发货，MSProjectExperts.com

Project 2010 version shipping March 15 with MSProjectExperts.com

这篇关于提取“资源使用”从MS Project到XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！