Convert Project Data to Excel in C++

This article demonstrates how to save project data to XLSX format using Aspose.Tasks for C++.

The Project class exposes the Save method which is used to save a project in various formats. The Save method allows you to save project tasks, resources and assignments to separate worksheets to XLSX format using the SaveFileFormat enumeration type.

To save a project to XLSX:

1. Load a Microsoft Project file.
2. Save the project to XLSX using SaveFileFormat.XLSX.

Saving a Project as XLSX

The following lines of code demonstrate how to achieve this using C++.

// Read the input Project file
System::SharedPtr<Project> project = System::MakeObject<Project>(dataDir + u"CreateProject2.mpp");
    
// Save the Project as XLSX
project->Save(dataDir + u"SaveProjectAsXLSX_out.xlsx", Aspose::Tasks::Saving::SaveFileFormat::XLSX);

Using XlsxOptions

With XlsxOptions, you can modify how the project is exported.

// Read the input Project file
System::SharedPtr<Project> project = System::MakeObject<Project>(dataDir + u"CreateProject2.mpp");
    
System::SharedPtr<XlsxOptions> options = System::MakeObject<XlsxOptions>();
    
// Add desired Gantt Chart columns
System::SharedPtr<GanttChartColumn> col = System::MakeObject<GanttChartColumn>(u"WBS", 100, &UsingXlsxOptions::_anonymous_method_0);
options->get_View()->get_Columns()->Add(col);
    
// Add desired resource view columns
System::SharedPtr<ResourceViewColumn> rscCol = System::MakeObject<ResourceViewColumn>(u"Cost center", 100, &UsingXlsxOptions::_anonymous_method_1);
options->get_ResourceView()->get_Columns()->Add(rscCol);
    
// Add desired assignment view columns
System::SharedPtr<AssignmentViewColumn> assnCol = System::MakeObject<AssignmentViewColumn>(u"Notes", 200, &UsingXlsxOptions::_anonymous_method_2);
options->get_AssignmentView()->get_Columns()->Add(assnCol);
    
project->Save(dataDir + u"UsingXlsxOptions_out.xlsx", options);

Save Project Data to Spreadsheet2003 XML

There are two ways to save data to Spreadsheet2003 XML format: default, or using save options. Using the SaveFileFormat instance, the default view data is saved.

System::SharedPtr<Project> project = System::MakeObject<Project>(dataDir + u"CreateProject2.mpp");
project->Save(dataDir + u"SaveProjectDataToSpreadsheet2003XML_out.xml", Aspose::Tasks::Saving::SaveFileFormat::Spreadsheet2003);

Using Spreadsheet2003SaveOptions

Aspose.Tasks for C++ provides Spreadsheet2003SaveOptions for modifying the view data.

System::SharedPtr<Spreadsheet2003SaveOptions> options = System::MakeObject<Spreadsheet2003SaveOptions>();
System::SharedPtr<GanttChartColumn> col = System::MakeObject<GanttChartColumn>(u"WBS", 100, &UsingSpreadsheet2003SaveOptions::_anonymous_method_0);
options->get_View()->get_Columns()->Add(col);
    
System::SharedPtr<ResourceViewColumn> rscCol = System::MakeObject<ResourceViewColumn>(u"Cost center", 100, &UsingSpreadsheet2003SaveOptions::_anonymous_method_1);
options->get_ResourceView()->get_Columns()->Add(rscCol);
    
System::SharedPtr<AssignmentViewColumn> assnCol = System::MakeObject<AssignmentViewColumn>(u"Notes", 200, &UsingSpreadsheet2003SaveOptions::_anonymous_method_2);
options->get_AssignmentView()->get_Columns()->Add(assnCol);
    
project->Save(dataDir + u"UsingSpreadsheet2003SaveOptions_out.xml", options);