MPP files are digital documents designed for organizing, tracking, and managing projects. MPP files encompass vital information such as tasks, resources, assignments, timelines, budgets, and other project-related data. In certain cases, we may need to export project data from MPP to Excel. Converting an MPP file to Excel is an easy way to share project data with stakeholders who may not have access to Microsoft Project. We can easily export project data from MPP files to Excel spreadsheets (XLSX) programmatically in Python. In this article, we will learn how to convert MPP to Excel in Python.
This article covers the following topics:
- Python MPP to Excel Converter
- Convert MPP to Excel
- Customize MPP to XLSX Conversion
- Convert MPP to Excel Online
Python MPP to Excel Converter
For MPP to Excel conversion, we will use the Aspose.Tasks for Python library. It provides a comprehensive set of features to seamlessly create, process, and convert MS Project (MPP) files.
Please either download the package or install the API from PyPI using the following pip command in the console:
pip install aspose-tasks
Convert MPP to Excel in Python
MPP to Excel conversion using Aspose.Tasks for Python is straightforward. Simply load the MPP file and save it in XLSX format at the desired location. Please follow the steps below to convert an MPP to Excel in Python.
- Load the MPP file using an instance of the Project class.
- Call the save() method with the output XLSX file path and SaveFileFormat as arguments.
The following code sample shows how to convert MPP to Excel using Python.
Customize MPP to XLSX Conversion
In addition to converting an MPP file to Excel, we can also utilize various settings to customize the output. To accomplish this, the API offers the XlsxOptions class, which permits us to specify additional options for rendering project data in XLSX format. Please follow the steps below to specify XLSX save options:
- Load the MPP file using the Project class.
- Create an instance of the XlsxOptions class.
- Set various options such as page_size, resource_view, assignment_View, presentation_format, etc.
- Finally, call the save() method to save it as XLSX. It takes the output file path and XlsxOptions as arguments.
The following code sample shows how to convert MPP to XLSX with advanced options using Python.
Convert MPP to Excel Online
If you want to convert MPP to Excel online, use our high-quality and free MPP to Excel converter, which is developed using Aspose.Tasks library.
Read the complete tutorial on converting MPP to Excel online using our free converter.
Get a Free License
You can get a free temporary license to try the library without evaluation limitations.
Explore MPP to Excel Converter
Check out the following resources to learn more about converting MPP files into Excel or other supported formats and exploring Aspose.Tasks:
Conclusion
In this article, we learned how to convert MPP to Excel in Python. Furthermore, we have seen how to export MS Project data from an MPP file to Excel and customize the options programmatically. MPP to Excel conversion can be an efficient way to share your project data with others who don’t have access to Microsoft Project. The step-by-step guide and code samples demonstrate how easy it is to perform MPP to XLSX conversion using our Python library. In case of any ambiguity, please contact us on our free support forum.