Difference between revisions of "PowerPoint export"

(Setup)
(Slides)
Line 21: Line 21:
 
[[Image:powerpoint3.png]]
 
[[Image:powerpoint3.png]]
  
 +
====Other options===
 +
 +
Expand the slide to see additional options
 +
 +
[[Image:powerpoint4.png]]
 +
 +
# Use Slide Title - you can specify static text or a cell range to use as the slide's title, see templates for more information
 +
# Resize content to fit space - by default the cells will be inserted to match the size in Excel, you can change so they are resized to fit the slide space available and optionally retain the aspect ratio
  
 
===Templates===
 
===Templates===

Revision as of 09:14, 17 October 2017

New in Version 9.1 for enterprise version you can now setup a workbook to support exporting to a PowerPoint file, this can be done interactively or via scheduling and supports multi-sheet printing.

Setup

Before a workbook can be exported to PowerPoint it has to be setup to support that in the Excel Edition.

Excel

You can enable the export in Workbook Properties, under the PowerPoint tab:

Powerpoint1.png

Slides

Powerpoint2.png

For each slide that will be created in the presentation you need to pick the appropriate range in the workbook, the range can include charts and other XLCubed objects. The cell content and formatting will be added as text and any other items will be inserted as images.

You can re-order the slides by dragging the icon:

Powerpoint3.png

=Other options

Expand the slide to see additional options

Powerpoint4.png

  1. Use Slide Title - you can specify static text or a cell range to use as the slide's title, see templates for more information
  2. Resize content to fit space - by default the cells will be inserted to match the size in Excel, you can change so they are resized to fit the slide space available and optionally retain the aspect ratio

Templates

Web

Templates

Using

Scheduling

Multi-sheet