Comment convertir les fichiers du projet Microsoft au format CSV

Cet article fournit des instructions détaillées et des échantillons de code pour convertir les fichiers de projet Microsoft MPP au format CSV à l’aide d’Aspose.tasks pour .NET. Diverses options d’exportation telles que le filtrage, le tri, le codage, les paramètres de délimiteur et la visibilité de l’en-tête sont également démontrées.

Convertir les fichiers du projet MS en CSV

Il existe deux façons de convertir le format Microsoft Project au format CSV (valeurs séparés par les virgules): utilisez SaveFileFormat l’énumération ou la classe csvoptions.

Afin de convertir le fichier MS PROJET MPP en format CSV avec des paramètres par défaut en utilisant SaveFileFormat:

1. Créez une nouvelle instance de projet et chargez le fichier MPP.
2. Convertissez le projet en CSV à l’aide de la méthode Project.Save et spécifiez le SaveFileFormat.csv comme argument.

Project project = new Project("New Project.mpp");
project.Save("SaveProjectAsCSV_out.csv", SaveFileFormat.CSV);

To convert MPP files with a non-default settings the CsvOptions class can be used. The CsvOptions class allows specification of additional export parameters while rendering project pages to CSV.

1. Create a new project instance and load the MPP file.
2. Convert the project to CSV using the Project.Save method and pass the CsvOptions instance as the argument.

Presented below is .NET example showing how to change text delimiter using the options:

Project project = new Project("New Project.mpp");
CsvOptions options = new CsvOptions();
options.TextDelimiter = CsvTextDelimiter.Semicolon;
project.Save("UsingCsvOptions_out.csv", options);

How to change the view while convert MPP to CSV

By default the Gantt Chart view is used to decide what column headers will be exported. To change the view the DataCategory property can be used:

Project project = new Project("New Project.mpp");
CsvOptions options = new CsvOptions();
// to change what columns will be exported the DataCategory property can be used
// changing the data category from DataCategory.Tasks to DataCategory.Resources
options.DataCategory = DataCategory.Resources;
project.Save("CsvOptionsWithResourceView.csv", options);

How to sort tasks while converting to CSV

By using CsvOptions one can tune the export parameters e.g. control the view to export and/or filter exported tasks. Lets take a look at some of the options available.

For example, one can customize the sorting order of the tasks by assigning a custom comparer to the TasksComparer property. Presented below is the example where tasks sorted by name are exported reversed order:

Project project = new Project("New Project.mpp");
project.RootTask.Children.Add("Task");
CsvOptions options = new CsvOptions
{
    TasksComparer = new ReversedByNameTaskComparer()
};
project.Save("CsvOptionsWithReversedTasks.csv", options);

// ...

private sealed class ReversedByNameTaskComparer : IComparer<Task>
{
    public int Compare(Task x, Task y)
    {
        if (x == null)
        {
            throw new ArgumentNullException("x");
        }

        if (y == null)
        {
            throw new ArgumentNullException("y");
        }

        return -1 * string.Compare(x.Get(Tsk.Name), y.Get(Tsk.Name), StringComparison.Ordinal);
    }
}

How to Filter Tasks While Convert to CSV

In order to filter the exported tasks one can specify the task filter by assigning a custom condition to the TasksFilter property:

Project project = new Project("New Project.mpp");
CsvOptions options = new CsvOptions();
options.TasksFilter = new OutlineCodeFilter();
project.Save("CsvOptionsWithFilteredTasks.csv", options);

// ...

class OutlineCodeFilter : ICondition<Task>
{
    public bool Check(Task el)
    {
        var code1 = el.OutlineCodes.GetByFieldId((int)ExtendedAttributeTask.OutlineCode1);
        var code2 = el.OutlineCodes.GetByFieldId((int)ExtendedAttributeTask.OutlineCode2);
        return code1 != null && code2 != null;
    }
}

How to change delimiter while converting to CSV

CSV is a text format that uses text delimiters to split data fields. To change the text delimiter one can set the TextDelimiter property to one of the next values:

• Comma;
• Semicolon (the default delimiter);
• Space;
• Tab.

The available delimiters are defined in CsvTextDelimiter enumeration.

Presented below is the example in which data fields are being split by tab symbol:

Project project = new Project("New Project.mpp");
CsvOptions options = new CsvOptions();
// changing text delimiter to tabs
options.TextDelimiter = CsvTextDelimiter.Tab;
project.Save("CsvOptionsWithCustomDelimiter.csv", options);

How to change encoding while converting to CSV

By default CSV is being exported in Encoding.Default encoding. To change the encoding the Encoding property can be used:

Project project = new Project("New Project.mpp");
CsvOptions options = new CsvOptions();
// changing the text encoding
options.Encoding = Encoding.UTF8;
project.Save("CsvOptionsWithCustomEncoding.csv", options);

How to hide column headers while converting to CSV

By default column headers are being exported in CSV format. To suppress export of column headers the IncludeHeaders property can be used:

Project project = new Project("New Project.mpp");
CsvOptions options = new CsvOptions();
// suppress export of column headers
options.IncludeHeaders = false;
project.Save("CsvOptionsWithoutColumnHeaders.csv", options);

In summary, Aspose.Tasks for .NET provides a flexible and extensible API for exporting project data to CSV format. The CsvOptions class allows customization of output according to specific project requirements, such as task filtering, sorting, and text encoding.