FAQCategory: Import/ExportHow to export information to Excel/CSV using command?

How to export information to Excel/CSV using command?

1 Answers

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.

Contact
Chat