How to export information to Excel/CSV using command?
Example for how to export to Excel a sample project from c:\my files folder with Project Plan 365:
ProjectPlan.exe /csv “c:\my files\sample.mpp”- this command will create sample.csv file in c:\my files folder.
For automation purposes, the following script sample can be used (exportCSV.bat):
@echo off
set PP=”C:\Program Files (x86)\Husatonic\ProjectPlan365\ProjectPlan.exe”
cmd /c “%PP% /csv %1”
if %ERRORLEVEL% neq 0 (
echo Export error for %1
) else (
echo Successfully exported %1
)
Usage: exportCSV.bat projectpath
PP variable should be set to actual application path – export result will be displayed on the screen. The exported file will be added to projectpath location.
It is available for Gantt Chart, Tracking Gantt and Task Sheet views. By using this option, the content of the list of tasks will be exported in a CSV format.Note: Using an automatic command can export projects to excel only in .CSV format.