如何将Excel工作表导入Microsoft Project？ [英] How to Import Excel Worksheet into Microsoft Project?

问题描述

我想将以下Microsoft Excel工作表导入Microsoft Project（2010）：

本质上，工作表在列A中有任务和子任务，列B中的启动日期和列C中的完成日期您看到的条件突出显示是基于开始和结束日期。没有宏，只有公式，所以电子表格保存为一般的Excel工作簿。

我尝试在Project中打开工作簿。它正确找到源工作表名称，但它不识别任何要映射的字段。见下图：

我可以做些什么来解决这个问题？我以前从未使用过Project，但是我想能够导入主要里程碑和子任务，以及各自的开始和完成日期。非常感谢任何帮助。

解决方案

我试过了一下：

向导的初步设置：

• 新地图


• 作为新项目


• 任务，资源，作业：全部
  选择


• 导入包含标题

工作表名称：Sheet1 ...默认情况下：OK。

虽然Sheet1重命名为：

＃2 MacroPlan ：不行

2 MacroPlan：不行

MacroPlan：OK

＃2_MacroPlan：不行

2_MacroPlan code>：OK

因此：使用_而不是空格，不要使用＃可能还有其他奇怪的符号（没有测试更多）。

I want to import the following Microsoft Excel worksheet into Microsoft Project (2010):

Essentially, the worksheet has tasks and subtasks in column A, Start Dates in column B, and Finish Dates in column C. The conditional highlighting you see is based off the start and finish dates. There are no macros, only formulas, so the spreadsheet is saved as a normal Excel workbook.

I tried to open the workbook in Project. It correctly finds the source worksheet name, but it doesn't recognize any fields to map to. See the picture below:

What can I do to resolve this? I've never used Project before, but I would like to be able to import the "Key Milestones" and "Subtasks", along with their respective "Start" and "Finish" dates. Any help is much appreciated.

解决方案

I gave a try:

Wizard's preliminary settings:

• New map
• As a new project
• Tasks, Resources, Assignments: all selected
• Import includes headers

Sheet names: "Sheet1"... as by default: OK.

While "Sheet1" renamed to:

"#2 MacroPlan": Not OK
"2 MacroPlan": Not OK
"MacroPlan": OK
"#2_MacroPlan": Not OK
"2_MacroPlan": OK

Hence: Use "_" instead of space, don't use "#"and probably other odd symbols (didn't test more).

这篇关于如何将Excel工作表导入Microsoft Project？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！