This is honestly the most useful and practical tutorial of officer out there, including the package's own documentation. Thanks so much for figuring out the inner workings with respect to Powerpoint, and for sharing that knowledge! 🙇🏻♂️
Thank you!!! Your video helped me a lot =)! Maybe the next level is to use all officer functions to create my own ppt from scratch. But your example was excellent.
Nice overview. I use officer to create reports for the board. You don't need to use placeholders. The officer package can place elements anywhere on a page.
@@Ljupcho The best thing about open source software is the freedom to do as you please. I prefer to write the template in code, rather than rely on a pptx file.
Thanks so much for this tutorial, super useful. Is there a way to add hyperlinks in the text boxes? I tried with the usual rmarkdown notation (blabla)[url] but i could not make it work.
Hi - great video! Super clear and helpful. I would like to export an editable power point chart from R (i.e. I want to be able to click into the underlying data, edit it like a power point chart). Do you know of any way of doing this? From what I can tell, exporting a ggplot will not be able to do this. Thanks
The easiest way to do it is to have a shape or text in Powerpoint that's linked to the shiny app, so that when it's clicked it opens the app in a browser. This works if the shiny app is local or on a server. To have it inside the actual Powerpoint it has to be on a server and you can use this plug-in appsource.microsoft.com/en-us/product/office/WA104295828 . Note: the url has to have a valid SSL certificate (https) or Powerpoint will block it. If you find another way let me know.
I checked today, you can set the option in the text placeholder but it will not work when filled in by officer i.e. text will overflow. However if you manually add any character the option is activated and it will reformat the text to fit the box. Hope it's clear.
Man!! love the video. thank you for this. i have this need that I need to print tables across pages, would this take it and adjust the length across pages????
@@Ljupcho tried full implementation but I am facing the below issue. the challenge is splitting tables automatically based on allotted space and size of content. Got any idea how to do it???
@@ahmed007Jaber I don't know your data so I can't be too specific. Do you have a variable number of columns? If so I'd set a limit of max columns, in combination with max column width per column for flextable. I think there are also some autowidth options that flextable provides so it structures the table in the most readable way.
Hello! In my presentation I will include a map that I generate in R. Do you know how to zoom in? That is, when I paste it normally, I cut the map image from the top and bottom in Power Point, I would like to find a homogeneous function in R. Someone knows?
Hi Gisela, yes the solution would be to save the map you want to include as a png image file, with the exact zoom that you need, and then insert that image into your presentation. If you would like the image to fit the placeholder you have defined in the presentation template, refer to 14:23 in the video. You can get the x and y sizes of every placeholder in inches, and then you can use these dimensions to define the map image size so it fits perfectly.
I used this function: external_img() with this instruction: ph_with(value=external_img(src=("C:/image.png")),location=ph_location_label(ph_label="locationppt")) with a bookmark in my ppt. I added a map image to my ppt either.
Hi the API endpoint for the names seems to be down, either temporarily or permanently. You can replace that function with search_stock, which has a shortname column. yfinance::search_stock("AAPL", keep_results = "top")
This is honestly the most useful and practical tutorial of officer out there, including the package's own documentation. Thanks so much for figuring out the inner workings with respect to Powerpoint, and for sharing that knowledge! 🙇🏻♂️
Thank you Nic!
Fantastic tutorial! Thanks a lot. I will incorporate it into my work and will try to tinker with multiple layouts and slides.
super prezetacija
Thanks mom xD
Thanks for taking time to help others! Great practical insights!
Glad it's useful, thanks!
Thank you!!! Your video helped me a lot =)! Maybe the next level is to use all officer functions to create my own ppt from scratch. But your example was excellent.
Great job thanks so much
Thank you, glad it's helpful
Awesome tutorial man. Thank you very much!
Very helpful! Thanks!
Very helpful and useful. Thanks! 👍
Great presentation. Thank you.
Nice overview. I use officer to create reports for the board. You don't need to use placeholders. The officer package can place elements anywhere on a page.
True, but I prefer this workflow
@@Ljupcho The best thing about open source software is the freedom to do as you please. I prefer to write the template in code, rather than rely on a pptx file.
@@PeterPrevos Exactly! 👍
This is great- very helpful. Thank you!
How can you change the alignment of the text in the box (top/middle/bottom) without using a placeholder?
This has been extremely helpful. Can you do a series on this?
Thanks so much for this tutorial, super useful. Is there a way to add hyperlinks in the text boxes? I tried with the usual rmarkdown notation (blabla)[url] but i could not make it work.
that's amazing! Can't wait to use it
Great presentation.
Hi - great video! Super clear and helpful.
I would like to export an editable power point chart from R (i.e. I want to be able to click into the underlying data, edit it like a power point chart). Do you know of any way of doing this? From what I can tell, exporting a ggplot will not be able to do this.
Thanks
It's possibile, check the package documentation
Can the PowerPoint integrate shiny to make the slides interactive when in presentations ?
The easiest way to do it is to have a shape or text in Powerpoint that's linked to the shiny app, so that when it's clicked it opens the app in a browser. This works if the shiny app is local or on a server. To have it inside the actual Powerpoint it has to be on a server and you can use this plug-in appsource.microsoft.com/en-us/product/office/WA104295828 . Note: the url has to have a valid SSL certificate (https) or Powerpoint will block it. If you find another way let me know.
Such an amazing tutorial! Thank you. The library(yfinance) ist not available anymore. Is there a workaround?
hi Raphael, glad it's useful! yfinance has to be installed from github as it's not on CRAN yet. remotes::install_github("ljupch0/yfinance")
Great video. Btw how to enable that beautiful dark theme of Rstudio?
I use rscodeio with small tweaks github.com/Ljupch0/rscodeio
Gracias!!!
Is it possible to apply the "Shrink text on overflow" functionality from the text options of the placeholder?
I think so but I'm not 100% sure.
I checked today, you can set the option in the text placeholder but it will not work when filled in by officer i.e. text will overflow. However if you manually add any character the option is activated and it will reformat the text to fit the box. Hope it's clear.
thank you !
Is there any way of doing this without using the masterslide? and just use a presentation that i've already made?
Not that I know of
Man!! love the video. thank you for this.
i have this need that I need to print tables across pages, would this take it and adjust the length across pages????
not sure
@@Ljupcho tried full implementation but I am facing the below issue.
the challenge is splitting tables automatically based on allotted space and size of content. Got any idea how to do it???
@@ahmed007Jaber Are you using the flextable package for the tables?
@@Ljupcho yes i am testing it with flextable
@@ahmed007Jaber I don't know your data so I can't be too specific. Do you have a variable number of columns? If so I'd set a limit of max columns, in combination with max column width per column for flextable. I think there are also some autowidth options that flextable provides so it structures the table in the most readable way.
Hello!
In my presentation I will include a map that I generate in R.
Do you know how to zoom in?
That is, when I paste it normally, I cut the map image from the top and bottom in Power Point, I would like to find a homogeneous function in R.
Someone knows?
Hi Gisela, yes the solution would be to save the map you want to include as a png image file, with the exact zoom that you need, and then insert that image into your presentation. If you would like the image to fit the placeholder you have defined in the presentation template, refer to 14:23 in the video. You can get the x and y sizes of every placeholder in inches, and then you can use these dimensions to define the map image size so it fits perfectly.
I used this function: external_img() with this instruction: ph_with(value=external_img(src=("C:/image.png")),location=ph_location_label(ph_label="locationppt")) with a bookmark in my ppt. I added a map image to my ppt either.
thank you for this, know why I am getting
company_name
Hi the API endpoint for the names seems to be down, either temporarily or permanently. You can replace that function with search_stock, which has a shortname column.
yfinance::search_stock("AAPL", keep_results = "top")