Ashim Kapoor
2019-Dec-11 11:37 UTC
[R] Tables from Rmarkdown to Word Document - using huxtables
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]]
Rui Barradas
2019-Dec-11 15:41 UTC
[R] Tables from Rmarkdown to Word Document - using huxtables
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") 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 at 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. >
Ashim Kapoor
2019-Dec-12 07:27 UTC
[R] Tables from Rmarkdown to Word Document - using huxtables
On Wed, Dec 11, 2019 at 9:11 PM Rui Barradas <ruipbarradas at 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 at 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]]