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

Поділитися
Вставка
  • Опубліковано 24 січ 2025

КОМЕНТАРІ • 16

  • @rappa753
    @rappa753  3 місяці тому +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 3 місяці тому

      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 3 місяці тому +4

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

    • @rappa753
      @rappa753  3 місяці тому +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 3 місяці тому

    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  3 місяці тому +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 :)

  • @JollyRoger183
    @JollyRoger183 3 місяці тому +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  3 місяці тому +1

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

  • @DM-py7pj
    @DM-py7pj 3 місяці тому +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  3 місяці тому +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 :)

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

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

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

      Agreed. A Powerpoint tutorial is also on its way 🥳

  • @reem19681
    @reem19681 3 місяці тому

    Excellent, Is it possible to share the code?

  • @ferrocen
    @ferrocen 3 місяці тому

    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  3 місяці тому +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 3 місяці тому

      @@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 😊