Microsoft Excel macros

Edit online

IBM Engineering Lifecycle Optimization - Publishing updates Microsoft Excel fields automatically during document-style report generation. You are not required to manually use a macro or update any of the fields that you added.

A Microsoft Excel .xltm file, which contains the following macros, is located in PUB_install_dir/utils/excel/RPE.xltm.

Table 1. Microsoft Excel macros provided with PUB
Macro Name	Description
AddPieChart	Adds a Pie chart.
setChartPosition	Sets the position for the chart.
DeleteSheetsWithNoRows	Deletes the sheets that contain tables without any rows.