Extract data from multiple tabs in excel and paste each tab in PPT with same format

Question

Hi,

I am looking to create a deck in PPT. Data are all available in pdf or excel.

1st and 2nd slide from PDF page and rest all (somewhere 20 to 22 slides) from different tabs in an excel.

Can we do this in Alteryx moving data from each tab of excel to PPT keeping format same, even image is fine.

Only issue is we need to extract particular range and not entire sheet.

For example one in attached,

1st sheet has data but i need to pull data only from range i.e E6 to O55 which will keep changing if we have more data.

Those data need to be pasted in PPT as image or data whatever is convenient but it should cover entire page of PPT

Attached excel and PPT file

In short I just want to copy paste contents / format from excel to new slid of PPT

Multiple spreadsheet into PPT.xlsx

deck multiple.pptx

ShaileshDevadiga · Answer

@mceleavey  - I totally agree excel is bad source , hence trying to find main source and built same in Alteryx and then convert to ppt.

mceleavey · Answer

Hi @ShaileshDevadiga ,

In this case don't select the range and simply remove the null rows/columns using the Data Cleansing tool (or others depending on the format of your data.

Excel is a really bad data source, so try to get it standardised, but you should be able to automatically handle it in Alteryx.

M.

ShaileshDevadiga · Answer

Thank You @mceleavey 
I will explore the below option and render tool to have correct format.
Only issue is the range keep on changing depending on availability of data. In that case I need to define range every time and also this steps need to follow like 20 tabs .