Importing from Excel to PowerPoint

Help
1

I am trying to import data from Excel to PowerPoint, however, I need to only import 25 lines of data per slide instead of the whole worksheet at once. How can I do this?
How can I break up the data in the automation?

1 Like
2

Hi @TasneemA

Welcome to UiPath Community
Fine

  1. While reading the excel file with read range activity we can set the range we want till 25 like this “A1:E25” if there are columns from A to E
  2. Now we be getting the output as a datatable and name it out_dt
  3. use output datatable activity to convert the datatable into a text format and get the output as a string type variable named out_text and write it a text file using write text activity and save it in a folder with a file name
  4. Now use this component to write into a power point you want

https://go.uipath.com/component/edit-powerpoint-slide

Kindly try this and let know buddy @TasneemA
Hope this would help you
Cheers @TasneemA

3

Thank you very much! I’ll try this and see how it goes

4

Fine @TasneemA

5

Thanks again. This worked marvelously, however, it doesn’t keep the columns or the spaces. Is there any way to remedy this?

6

Can i have a view on that as a screenshot if possible
Cheers @TasneemA

7

Sure

image
image1920Ă—1080 269 KB

8

Hi, I could’nt reach the url. https://go.uipath.com/component/edit-powerpoint-slide