Automatically Fill Word Documents With Data Using R | Step-by-Step Tutorial

Поділитися
Вставка
  • Опубліковано 27 лис 2024

КОМЕНТАРІ • 16

  • @rappa753
    @rappa753  Місяць тому +1

    Thank you for watching my latest video. ♥
    If you enjoyed this video, I'm sure you're also going to love my Data Cleaning Master Class. Clean your data and find insights much faster at data-cleaning.albert-rapp.de/

    • @nithin.m2675
      @nithin.m2675 Місяць тому

      hi albert. nice video. Do you think we can use this in quarto? i mean use YAML parameters for replacement words like date?

  • @ambhat3953
    @ambhat3953 Місяць тому +4

    Need to try this, I always copy pasted the charts to word doc

    • @rappa753
      @rappa753  Місяць тому +3

      Let me know how it goes 😊 copy and paste is still a quick method for one-offs. But for repeated documents this will become tedious quite fast.

  • @sanderellphillip
    @sanderellphillip Місяць тому

    Great video! I wonder what would be the benefit of using this package to make a Word doc as opposed to using Quarto and rendering as a Word doc?

    • @rappa753
      @rappa753  Місяць тому +1

      More granular customization possibilities. With Quarto you have to go through pandoc which has limited Word processing features. But if you find that for your use case, Quarto has all that you need, then you can just as easily use that :)

  • @DM-py7pj
    @DM-py7pj Місяць тому +2

    Please do a qmd to PowerPoint, using custom PowerPoint template. Include the setting up PowerPoint and qmd parts. Company/custom styling etc.

    • @rappa753
      @rappa753  Місяць тому +1

      I find the Quarto to PowerPoint documentation hard to decipher. But I'll show you how to create pptx files with custom templates using the {officer} package soon :)

  • @JollyRoger183
    @JollyRoger183 Місяць тому +2

    Unrealted question but how do you set up RStudio in a way to get these red-yellow-green squares that visualize the intendations?

    • @rappa753
      @rappa753  Місяць тому +1

      It's the rainbow indent setting. I've described them at ua-cam.com/video/XHT1m-LKTVY/v-deo.html

  • @reem19681
    @reem19681 Місяць тому

    Excellent, Is it possible to share the code?

  • @enocharthur4322
    @enocharthur4322 Місяць тому +1

    We need more tutorials on the officeR Package. Very limited tutorials on youtube

    • @rappa753
      @rappa753  26 днів тому +1

      Agreed. A Powerpoint tutorial is also on its way 🥳

  • @ferrocen
    @ferrocen Місяць тому

    Thanks for this tutorial ❤
    Do you think it would be possible to use a template and the replacement functions to create a serial letter? I think „map“ could work, but then I will have a file for each letter.
    I already tried it with knittr and quarto but failed 😂
    Thanks again 👍🏻

    • @rappa753
      @rappa753  Місяць тому +1

      Not quite sure I understand the question correctly. You don't want to have separate files per letter? All letters in one Word doc on separate pages?

    • @ferrocen
      @ferrocen Місяць тому

      @@rappa753yes exactly.
      Like when you use the serial letter function in Word. At the moment I prepare my data with R, export it as csv and then use it with the serial letter function in Word. Now I thought that it would be nice to do everthing in R 😊