mpp to xlsx

How to convert MS Project (MPP) to Excel using .NET REST API.

MS Project files (MPP) are widely used for managing complex project plans, timelines, resources, and tasks in a structured format. However, MPP files are proprietary and require specific software like Microsoft Project for viewing and editing. Therefore, by converting MPP to XLSX allows for broader accessibility, making it easier for stakeholders without MS Project to view, manipulate, and analyze project data using Excel’s advanced features.

MPP to Excel Conversion API

The Aspose.Tasks Cloud SDK for .NET simplifies the conversion of MS Project (MPP) files to Excel (XLSX) format with just a few lines of code. The .NET Cloud SDK offers high performance, accuracy, and flexibility, allowing you to easily integrate MPP-to-Excel conversion functionality into your applications without the need for additional software like MS Project.

To use the SDK in our project, first we need to search Aspose.Tasks-Cloud in the NuGet packages manager and click the Add Package button. This will add the SDK reference to your project. Secondly, obtain your client credentials from the cloud dashboard.

In case you do not have an existing account, simply create a free account by following the instructions specified in quick start guide.

Export MS Project to Excel in C# .NET

In this section, we are going to use the API to automate the extraction of project data, including tasks, resources, and timelines, and convert it into a structured Excel format.

Specified below are the details on how to perform MPP to Excel conversion using C# .NET.

TasksApi tasksApi = new TasksApi(clientSecret, clientID);

Create an object of TasksApi class while passing client credentials as input arguments.

var saveOptionsSerialized = "{ \"TextDelimiter\":\"Comma\", \"IncludeHeaders\":false,\"NonExistingTestProperty\":false," +
    "\"View\":{ \"Columns\":[{Type:\"GanttChartColumn\",\"Name\":\"TestColumn1\",\"Property\":\"Name\",\"Width\":120}," +
    "{Type:\"GanttChartColumn\",\"Name\":\"TestColumn2\",\"Property\":\"Duration\",\"Width\":120}]}}";

Create SaveOptions instance where we define custom properties for conversion operation.

tasksApi.PostTaskDocumentWithFormat(new PostTaskDocumentWithFormatRequest(){.....}

Call the API to begin the conversion operation. This method requires the name of the input MPP file and SaveOptions instance as arguments.

saveToDisk(finalResponse, resultant);

Finally, use the custom method to save the resultant workbook (returned as stream instance) to the local storage.

The input MPP file and the resultant Excel workbook generated in the above example can be downloaded from Home move plan.mpp and resultant.xlsx.

mpp to xlsx

A preview of MPP to Excel conversion.

Convert MPP to XLSX using cURL Commands

Converting MS Project (MPP) files to XLSX using Aspose.Tasks Cloud and cURL commands provide a streamlined, platform-independent approach. This method is especially beneficial for automation tasks, integration with web services, and when working in environments where REST API usage is preferred for its simplicity and efficiency.

The first step in this approach is to generate a JWT access token while executing the following command:

curl -v "https://api.aspose.cloud/connect/token" \
 -X POST \
 -d "grant_type=client_credentials&client_id=XXXXXX-XXXXXXX-XXXXXXX-be54-33012487e783&client_secret=XXXXXXXXXXXXXXXXXXXXXXXX" \
 -H "Content-Type: application/x-www-form-urlencoded" \
 -H "Accept: application/json"

Once we have the JWT token, please execute the following command to export the MS Project (MPP) file to XLSX format.

curl -v -X GET "https://api.aspose.cloud/v3.0/tasks/{inputFile}/format?format=xlsx&returnAsZipArchive=false" \
-H  "accept: multipart/form-data" \
-H  "authorization: Bearer <JWT Token>" \
-o resultant.xlsx

Replace inputFile with the name of input MS Project file already available in the Cloud storage and, replace accessToken with JWT access token generated above.

Free MPP to XLSX Converter

To witness the amazing capabilities of Aspose.Cloud REST APIs, you may consider trying our free MPP to XLSX Converter.

mpp to xlsx

How to convert MS Project (MPP) to Excel using .NET REST API.

Conclusion

In conclusion, converting MS Project (MPP) files to Excel format offers significant advantages in terms of accessibility, data analysis, and collaboration. We encourage you to try our Cloud APIs for a smooth and efficient conversion experience.

Whether using the powerful Aspose.Tasks Cloud SDK for .NET or utilizing cURL commands for direct API interactions, both methods simplify the conversion process and enable seamless integration with modern workflows.

We highly recommend visiting the following blogs: