Exporting spreadsheet data

If you are logged into a project as the top-level user, you can export spreadsheet data to other external files for use in other programs. This might be useful if you need to provide reports to colleagues who do not use Asta Powerproject themselves. The formats you can export to are:

HTML.
CSV.

You can also output the current spreadsheet and bar chart to the Clipboard or to a WMF or EMF graphic file. You can then paste the Clipboard data or import the graphic file into another application such as a word processor for inclusion in a project report.

Only the areas of a project to which you have access are exported.

Exporting to HTML

HTML is the format used for publishing documents on the internet, intranets and extranets. For example, if you want to publish monthly progress reports on your company's intranet, you could export a project to HTML then link the HTML report into the intranet.

When you export to HTML, the spreadsheet information is converted to an HTML table and you can choose whether or not to convert the bar chart to a graphic for inclusion in the HTML file. If the current view contains any expanded tasks and you export the current branch or the whole project, in the HTML file these tasks are linked so that clicking them displays the HTML file for the subordinate tasks (summary tasks and hammocks do not expand into separate HTML files). You must be logged into a project as the top-level user to export to a HTML file.

To export the current view, branch or whole project to HTML:

Click the File tab, click Import/Export, then click Export to HTML. The Export to HTML dialog appears.
Click Browse. The Save As dialog appears.
Select the location and enter a file name for the HTML file then click Save to return to the Export to HTML dialog. Alternatively, you can type a file location, name and extension directly into the File field.
From the Export Scope group, choose whether to export the current view, the current branch or the whole project.
From the Export Options group, select the Include bar chart in export check box to include a graphic of the bar chart in the HTML file. If you select this option, choose whether to export the bar chart in BMP or JPEG format. JPEG files usually take up less disk space but BMP files produce better quality images.
Select the Export without HTML tags check box if you want to export the view without the <HTML> and </HTML> tags. This is useful if you want to integrate the HTML file with other HTML files (or Web pages) because it avoids having multiple <HTML> tags in the file.
If you would like to add any header or footer information to the exported page, select the appropriate check box and enter the information that you want to include in the Include header or Include footer field. Right-clicking in the Include header or Include footer field invokes a list of fields that you can insert into the header or footer of the HTML page. For example, if you are exporting several charts, you could include the Chart Name field to display the chart name with the bar chart. If you have a preprepared HTML file that you want to use as the header or footer, drag and drop the HTML file from Windows® Explorer into the Include header or Include footer field to use that file's HTML as the header or footer.
Click OK to create the HTML file.

You can view the HTML file in a Web browser (such as Microsoft Internet Explorer®) or in another application that can read HTML files.

Exporting to CSV

Comma Separated Variable (CSV) files can be used by applications such as spreadsheets.

Exporting to a CSV file saves the spreadsheet information for the current view; you will need to export any subcharts and summary groups separately. You must be logged into a project as the top-level user to export to a CSV file.

To export the current view to a CSV file:

Click the File tab, click Import/Export, then click Export to CSV. The Export dialog appears.
Enter a new file name if required.
Click Save.

You can now open the file in another application that can read CSV files.

Using report writers

If your company uses a standard report writing program, you can use Asta Powerproject's OLE automation to integrate the two systems.

Using Asta Powerproject's OLE automation, you could read data from an Asta Powerproject project and write it into Microsoft Excel® to create a standard report. For example, if you need to produce a monthly progress report, you could write a macro to extract the names of all tasks being worked on that month and their duration percentage complete, then write that information into a spreadsheet and format the report in your company's house style.

Macros are not available in Asta Powerproject SaaS.