Excel output to powerpoint with formating

I have to build a pack which we currently run a macro for which screen shots the data in the excel sheet and then pastes it into a power point, we were wondering if there is any way of alteryx doing this?

I have attached the excel sheet along with the power point output. Any help would be greatly appreciated or if there is an alternative way of doing this?

Thanks Dan

Excel Source.xlsx

Powerpont Output.pptx

screenprint.PNG

Reporting

Accepted answers

CharlieS

First the good news: you can use Alteryx reporting tools to output formatted tables to PowerPoint slides.

The bad news: using "Base Alteryx" (no R/Python/3rd party software, no Run Command, etc.), you will only be able to read the cell data from an Excel file and not a formatted image.

This means that you'll need to build these formatted table in Alteryx. I have done this in the attached example to show how this can be done. Once the tables are built, then you can render them to PowerPoint and they will be inserted to slides as images.

20200121-ReportTableExample.pptx

20200121-ReportTablePowerPoint.yxmd

All comments

CharlieS

First the good news: you can use Alteryx reporting tools to output formatted tables to PowerPoint slides.

The bad news: using "Base Alteryx" (no R/Python/3rd party software, no Run Command, etc.), you will only be able to read the cell data from an Excel file and not a formatted image.

20200121-ReportTableExample.pptx

20200121-ReportTablePowerPoint.yxmd

danjohnsonM

Is there a way to use run command? It is for a larger pack overall (1200 slides) so formatting would take a long time)

Any further help would be greatly appreciated

Regards Dan

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703