使用MPXJ库在MS Project中默认显示“工时”和“ID”列的教程

import net.sf.mpxj.Duration;
import net.sf.mpxj.ProjectFile;
import net.sf.mpxj.Task;
import net.sf.mpxj.TaskType;
import net.sf.mpxj.Resource;
import net.sf.mpxj.ResourceAssignment;
import net.sf.mpxj.TimeUnit;

import java.util.Objects;
import java.util.Date;

// 假设 _project 是一个 ProjectFile 实例，extractedRow 包含从Excel读取的数据
// 假设 contract, element, workpackage, task 都是 Task 实例
// 假设 id 是一个递增的整数
// 假设 LookUp.Mpp_Conversion_Element_OutlineLevel() 等方法返回大纲级别

public class MpxjDataPopulationExample {

    private ProjectFile _project; // 假设已初始化
    private YourDataReader _filereader; // 假设已初始化
    private int id = 1; // 示例ID

    public void populateProjectData(ExtractedRow extractedRow, ProjectFile contract, Task element, Task workpackage, Task task, Date startingDate) {
        if (!extractedRow.getElement().isEmpty()) {
            element = contract.addTask();
            element.setName(extractedRow.getElement());
            element.setStart(startingDate);
            element.setOutlineLevel(LookUp.Mpp_Conversion_Element_OutlineLevel());
            element.setID(id++); // 设置ID
        } else if (!extractedRow.getWorkpackage().isEmpty()) {
            workpackage = Objects.requireNonNull(element).addTask();
            workpackage.setName(extractedRow.getWorkpackage());
            workpackage.setOutlineLevel(LookUp.Mpp_Conversion_Workpackage_OutlineLevel());
            workpackage.setID(id++); // 设置ID
        } else if (!extractedRow.getTask().isEmpty()) {
            task = Objects.requireNonNull(workpackage).addTask();
            task.setName(extractedRow.getTask());
            task.setType(TaskType.FIXED_WORK);
            task.setOutlineLevel(LookUp.Mpp_Conversion_Task_OutlineLevel());
            task.setWork(Duration.getInstance(extractedRow.getEstimatedTime(), TimeUnit.HOURS)); // 设置工时
            task.setDuration(Duration.getInstance(extractedRow.getEstimatedTime() / 8, TimeUnit.DAYS)); // 设置持续时间
            task.setRemainingWork(Duration.getInstance(extractedRow.getEstimatedTime(), TimeUnit.HOURS)); // 设置剩余工时
            task.setID(id++); // 设置ID

            if (!extractedRow.getRole().isEmpty()) {
                for (Resource resource : _project.getResources()) {
                    if (resource.getName().equals(_filereader.get_mapper().getMapping(extractedRow.getRole()))) {
                        ResourceAssignment assn = Objects.requireNonNull(task).addResourceAssignment(resource);
                        assn.setStart(task.getStart());
                        assn.setWork(Duration.getInstance(extractedRow.getEstimatedTime(), TimeUnit.HOURS)); // 分配的工时
                    }
                }
            }
        }
    }

    // 假设 ExtractedRow, YourDataReader, LookUp 类已定义
    // ...
}

import net.sf.mpxj.ProjectFile;
import net.sf.mpxj.writer.ProjectWriter;
import net.sf.mpxj.writer.ProjectWriterUtility;

import java.io.File;

public class MpxjXmlGeneration {

    public static void generateXmlFile(ProjectFile project, String outputPath) throws Exception {
        // ... 假设 project 已经通过 MPXJ 填充了所有任务、资源和工时数据 ...

        // 获取MSPDI写入器
        ProjectWriter writer = ProjectWriterUtility.get  Instance().getWriter(outputPath);
        writer.write(project, new File(outputPath));
        System.out.println("MPXJ XML文件已成功生成到: " + outputPath);
    }
}