You have selected an existing Report Definition in System Browser > Reports or you have created a new Report Definition.
The new excel format is supported for Trend log reports. This generates an excel report output which consists of common DateTime column, for each series a single column is generated with header as trended object/custom text with its units, alias and its data as series value.
Click the Home tab.
Do one of the following step to insert a table. Ensure that you are not inserting the table in the header/footer section of the report definition:
Click Table and insert Trends table from drop-down list.
Right-click the report definition, select the Trends table type from the Insert Table option.
Drag the desired Trend View Definition from System Browser on the Report Definition. The Name filter of the inserted table is set to the dropped Trend View
The table is added to the report definition with its default columns.
Click Run and generate a Report summary.
Click Create and view excel .
A dialog box displays asking you to save a copy of the excel report on your machine.
You can also generate report output as follows:
Click the Settings tab, from the Report Output group box click Dialog Launcher .
The Report Output Definition dialog box displays.
Select File in the Destination types list. Select Excel in the Report format list.
Browse the local drive path and save the report.
You can also share the report through mail.
The Report output in new excel format appears as given in image below