Convert MPP to Excel using Java

Convert-MPP-to-Excel-using-Java.md

Learn how to convert MPP to Excel using Java: https://blog.aspose.com/2022/05/10/convert-mpp-to-excel-using-java/

The following topics are covered in this article:

1. Java API to Convert MPP to Excel
2. Convert MPP to Excel
3. Convert MPP to Excel with Advanced Options

Convert-MPP-to-Excel-using-Java_Convert.java

// This code example demonstrates how to convert MPP to XLSX.
// Load the input Project file
Project project = new Project("D:\\Files\\Tasks\\Project.mpp");

// Save the Project as XLSX
project.save("D:\\Files\\Tasks\\Project.xlsx", SaveFileFormat.Xlsx);

Convert-MPP-to-Excel-using-Java_Convert_with_Options.java

// This code example demonstrates how to convert MPP to XLSX with advanced options.
// Load the input Project file
Project project = new Project("D:\\Files\\Tasks\\Project.mpp");

// Initialize XlsxOptions class object
XlsxOptions options = new XlsxOptions();

// Set the Timescale value to months
options.setTimescale(Timescale.Months);

// Set Gantt chart view
options.setView(ProjectView.getDefaultGanttChartView());

// Set page size
options.setPageSize(PageSize.A3);

// Render project to a single page
options.setRenderToSinglePage(true);

// Set UTF8 encoding
options.setEncoding(Charset.forName("UTF8"));

// Set resource sheet view
options.setResourceView(ProjectView.getDefaultResourceSheetView());

// Set assignment view
options.setAssignmentView(ProjectView.getDefaultAssignmentView());

// Set presentation format as resource usage
options.setPresentationFormat(PresentationFormat.ResourceUsage);

// Save the Project as XLSX
project.save("D:\\Files\\Tasks\\ProjectWithOptions.xlsx", options);