Message-ID: <AFE086D0-1ED0-48A0-99B6-0403C0DAEB8C@dcn.davis.ca.us>
Date: 2020-10-24T01:36:52Z
From: Jeff Newmiller
Subject: Package recommendations for outputting table with cell formatting
In-Reply-To: <122FF10A-32A2-4665-8AD2-D3AC90402060@plessthan.com>
I would go straight to Word using flextable (table layout) and officer (Word-specific formatting) within an rmarkdown document (e.g. bookdown:: word_document2 to manage overall structure and generate captions). Officer without rmarkdown may be able to generate true Word captions with bookmarks to cross-reference, but it is more tedious to set up than rmarkdown.
On October 23, 2020 5:28:26 PM PDT, Dennis Fisher <fisher at plessthan.com> wrote:
>R 4.0.2
>OS X
>
>Colleagues
>
>I have the unfortunate need to create a large number of tables
>(destined for a Word document). I need to color cells depending on the
>contents, e.g., blue if the value is < 0.5, red if the value is > 1.5.
>
>If the output went initially to Excel, that would work; outputting
>directly to Word would be even better.
>I expect that several packages can accomplish this. I am looking for
>recommendations as to which package (or combination) of packages is
>best to accomplish this.
>
>Dennis
>
>Dennis Fisher MD
>P < (The "P Less Than" Company)
>Phone / Fax: 1-866-PLessThan (1-866-753-7784)
>www.PLessThan.com
>
>______________________________________________
>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.
--
Sent from my phone. Please excuse my brevity.