Comment on page
Export to PDF & Excel
Inforiver allows you to export the table/matrix as either PDF or Excel. The industry-leading export capability delivers the following:
- Export with formatting, category/value structure and notes
- Export table/matrix along with scaled number formatting
- Export calculated rows, columns, and edited cells
- End-users in the reading view can customize export options
- Export to Excel with expand/collapse capability
- Export to multiple Excel worksheets based on category values
- Pagination & page-break support for Export to PDF
You can find the export option under the 'Export' tab of the toolbar. There are two sections: 'Export to PDF' & 'Export to Excel'. Let's take a look one by one.
Export options
Export to PDF/Excel is supported only in Power BI Service.
The first step in exporting as a PDF file is configuring the page setup.
The page setup section provides options to customize the page size, orientation, margin etc. Click 'Page Setup', and a window opens as shown.
Page setup
a) When the number of rows/columns doesn't fit on a single page, you can define the order in which the rows/columns are exported using the 'Content order' option.
Let's consider the below example. Based on the page scaling, only 8 columns and 20 rows can be accommodated on a single page.
When the 'Row first' option is chosen, the remaining rows for the first 8 columns are displayed on the second page. The third and fourth-page contents are highlighted in the image.
Row-first export
When the 'Column first' option is chosen, the remaining columns for the first 20 rows are displayed on the second page. The third and fourth-page contents are highlighted in the image.
Column-first export
b) Select the 'Page size' from the drop-down - Available sizes are Letter, A3, A4, A5 and Legal.
c) You can select either Landscape or Portrait as page 'Orientation'.
d) You can scale the page manually by percentages or automatically scale to fit all columns in a single page using the 'Scaling' option.
e) You can apply a Narrow, Normal or Wide 'Margin' as per the requirement.
f) You can select 'Font' style from the available options in the dropdown. Custom fonts can also be used when exporting.
If the data is customized with different fonts, the font chosen in the Settings panel is used for PDF export.
g) You can 'Show header and footer' either only on the First Page or on Every Page
h) You can select the 'Include footnotes' option to export the footnotes along with the table/matrix
i) You can set the 'Footnote position' as
- Last Page: Footnotes get printed on the last page.
- Dynamic: Based on the available space, footnotes get printed either on the same page where they are added or on the last page.
j) Click on 'Update' to save your page setup selection. Click on 'Reset' to reset all your selections.
Once the page setup is complete, you need to choose whether the entire matrix needs to be exported or just selected columns.
a) You can export all the rows and columns by clicking 'Entire Matrix'. Click on 'PDF Report' to export the file in PDF format.
Export entire matrix PDF
c) A pop-up appears as shown. The PDF file can be either saved to the computer or it can be sent by email. To save the document, choose 'Save to Computer', and click on the 'Click to export' option.
Pop up
e) A pop-up appears showing a warning, click 'Download'.
Download popup
f) The entire matrix gets exported as shown.
Entire matrix PDF
If you need to export only selected columns of your report, click 'Selected Columns' as highlighted in the below image.
Export selected columns
The selected columns 'Quarter, Q1, Q2' are downloaded as shown.
Selected columns PDF
Export to PDF does not support image columns.
You can export your report as an Excel file by clicking on the 'Export report' dropdown as shown in the below image.
When there are row/column hierarchies, there are three ways to export: 'Fully Expanded', 'With Expand/Collapse', and 'Current State'.
Export report
Note that 'Page setup' is not applicable for export to Excel.
Let's look at the three options one by one.
You can export the visual with all rows fully expanded by choosing the 'Fully Expanded' option. In the Inforiver visual, you can see that 'East' and Pacific -> Beverages are collapsed.
Fully expanded option
In the exported Excel, you can see that 'East' and Pacific -> Beverages are fully expanded.
Fully expanded excel report
To export as Excel with expand/collapse-enabled row hierarchies, select the 'With Expand/collapse' option.
With expand/collapse option
The downloaded Excel shows the same expand/collapse state as in the report and also has the expand/collapse buttons.
Excel report with expand/collapse
Export to Excel retains the expand/collapse state only for row hierarchy and not for column hierarchy.
To export the current expand/collapse state without an option to expand/collapse in the Excel file, you can select the 'Current state' option.
Current state option
The downloaded Excel shows the same expand/collapse state as in the report.
Current state report
Export to Excel does not support images and charts. Only basic icons that are available in excel, rating, and data bars are supported.
You can copy the data from your Inforiver visual including the calculated row, columns, edits, and notes (if there are any). The copied data can be easily pasted into an Excel sheet.
The keyboard shortcut for the copy to clipboard option is 'Ctrl+C+L'
Copy to clipboard
The above data has been copied and pasted in an Excel sheet and it gets displayed as shown in the below image.
Pasted data in Excel
Last modified 24d ago