[R] Tables from Rmarkdown to Word Document - using huxtables

Ashim Kapoor @@h|mk@poor @end|ng |rom gm@||@com
Thu Dec 12 11:51:07 CET 2019


Hello once again,

for me,set_caption is not working as well. Here is my Rmd file :-

---
title: Testing Huxtables
author: Ashim Kapoor
output: word_document
---

```{r}
library(dplyr)
library(huxtable)

hx <- iris %>%
   group_by(Species) %>%
   summarise_if(is.numeric, mean) %>%
   as_hux() %>%
   add_colnames() %>%
   set_bold(1, , TRUE) %>%
   set_bottom_border(1, , 1) %>%
   set_width(0.3) %>%
   set_col_width(1:5, 1.5) %>%
   set_number_format(2) %>%
   set_caption("Table 1:")

hx
```

Thank you,
Ashim

On Thu, Dec 12, 2019 at 12:57 PM Ashim Kapoor <ashimkapoor using gmail.com> wrote:

>
>
> On Wed, Dec 11, 2019 at 9:11 PM Rui Barradas <ruipbarradas using sapo.pt> wrote:
>
>> Hello,
>>
>> This works for me:
>>
>>
>> library(dplyr)
>> library(huxtable)
>> library(flextable)
>> library(officer)
>>
>> hx <- iris %>%
>>    group_by(Species) %>%
>>    summarise_if(is.numeric, mean) %>%
>>    as_hux() %>%
>>    add_colnames() %>%
>>    set_bold(1, , TRUE) %>%
>>    set_bottom_border(1, , 1) %>%
>>    set_width(0.99) %>%
>>    set_col_width(1:5, 0.99) %>%
>>    set_number_format(2)
>>
>> hx
>>
>> quick_docx(hx, file = "test.docx")
>>
>>
> Does set_width work for you ? For me modifying the argument to set_width
> is NOT working.
>
>
>> There are ways of doing the same without pipes, those functions don't
>> have the prefix 'set_'. But I believe that what's important is function
>> ?quick_docx.
>>
>> Hope this helps,
>>
>> Rui Barradas
>>
>> Às 11:37 de 11/12/19, Ashim Kapoor escreveu:
>> > Dear All,
>> >
>> > I am reading this :-
>> >
>> > https://hughjonesd.github.io/huxtable/huxtable.html
>> >
>> > I quote from the above:
>> >
>> > If you want to create Word or Powerpoint documents, install the
>> flextable
>> > package <https://cran.r-project.org/package=flextable> from CRAN.
>> Huxtables
>> > can then be automatically printed in Word documents. Or you can convert
>> > them to flextable objects and include them in Word or Powerpoint
>> documents.
>> >
>> > My query is how do I do the former ? How do I do this --->  Huxtables
>> can
>> > then be automatically printed in Word documents.
>> >
>> > I do understand how to do this ---> Or you can convert them to flextable
>> > objects and include them in Word or Powerpoint documents.
>> >
>> > Thank you,
>> > Ashim
>> >
>> >       [[alternative HTML version deleted]]
>> >
>> > ______________________________________________
>> > R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> > https://stat.ethz.ch/mailman/listinfo/r-help
>> > PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> > and provide commented, minimal, self-contained, reproducible code.
>> >
>>
>

	[[alternative HTML version deleted]]



More information about the R-help mailing list