DescriptionThis sample demonstrates how to extract data from an Excel file using ExcelWriter and import it to a PowerPoint presentation using PowerPointWriter.
Our Excel file contains employee data from the AdventureWorks database.
Our template presentation has a table with columns corresponding to the data in our Excel file.
The code below uses ExcelApplication to extract the data from the Excel spreadsheet into a DataTable. This code is also used in the ExcelWriter sample, Excel to DataTable Sample. It then passes the presentation to PowerPointTemplate and binds the data. The code uses MaxRowsPerSlide to ensure the data fits neatly in the presentation. See Fitting Data on to Multiple Slides for more information.
The resulting output shows all the data from the Excel spreadsheet in a PowerPoint presentation table.