Konvertieren Sie Projektdaten in C ++ in Excel

Dieser Artikel zeigt, wie Projektdaten mit Aspose.Tasks für C ++ im XLSX -Format gespeichert werden.

Die Projekt Klasse enthält die Speichernmethode, mit der ein Projekt in verschiedenen Formaten speichert wird. Mit der Speichermethode können Sie Projektaufgaben, Ressourcen und Zuordnungen sparen, um Arbeitsblätter mit dem SaveFileFirformat -Enumerationstyp in das XLSX -Format zu trennen.

Um ein Projekt auf XLSX zu speichern:

Laden Sie eine Microsoft -Projektdatei.
Speichern Sie das Projekt in XLSX mit SaveFileFormat.xlsx.

ein Projekt als xlsx speichern

Die folgenden Codezeilen zeigen, wie dies mit C ++ erreicht werden kann.

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

Examples-CPP-ConvertingProjectData-SaveProjectAsXLSX-SaveProjectAsXLSX.cpp hosted with ❤ by GitHub

Using XlsxOptions

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

 1// Read the input Project file
 2System::SharedPtr<Project> project = System::MakeObject<Project>(dataDir + u"CreateProject2.mpp");
 3    
 4System::SharedPtr<XlsxOptions> options = System::MakeObject<XlsxOptions>();
 5    
 6// Add desired Gantt Chart columns
 7System::SharedPtr<GanttChartColumn> col = System::MakeObject<GanttChartColumn>(u"WBS", 100, &UsingXlsxOptions::_anonymous_method_0);
 8options->get_View()->get_Columns()->Add(col);
 9    
10// Add desired resource view columns
11System::SharedPtr<ResourceViewColumn> rscCol = System::MakeObject<ResourceViewColumn>(u"Cost center", 100, &UsingXlsxOptions::_anonymous_method_1);
12options->get_ResourceView()->get_Columns()->Add(rscCol);
13    
14// Add desired assignment view columns
15System::SharedPtr<AssignmentViewColumn> assnCol = System::MakeObject<AssignmentViewColumn>(u"Notes", 200, &UsingXlsxOptions::_anonymous_method_2);
16options->get_AssignmentView()->get_Columns()->Add(assnCol);
17    
18project->Save(dataDir + u"UsingXlsxOptions_out.xlsx", options);

Examples-CPP-ConvertingProjectData-UsingXlsxOptions-UsingXlsxOptions.cpp hosted with ❤ by GitHub

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.

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

Examples-CPP-ConvertingProjectData-SaveProjectDataToSpreadsheet2003XML-SaveProjectDataToSpreadsheet2003XML.cpp hosted with ❤ by GitHub

Using Spreadsheet2003SaveOptions

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

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

Examples-CPP-ConvertingProjectData-UsingSpreadsheet2003SaveOptions-UsingSpreadsheet2003SaveOptions.cpp hosted with ❤ by GitHub

Projektdaten konvertieren Konvertieren Sie Projektdaten in C ++ in HTML