Re: [R] Package recommendations for outputting table with cell formatting

2020-10-23 Thread John Kane
This comes with no guarantee since i have only tried one or two packages mentioned but have a look at https://rfortherestofus.com/2019/11/how-to-make-beautiful-tables-in-r/";> R Tables. On Fri, 23 Oct 2020 at 20:28, Dennis Fisher wrote: > R 4.0.2 > OS X > > Colleagues > > I have the unfortunate

Re: [R] Package recommendations for outputting table with cell formatting

2020-10-23 Thread Jeff Newmiller
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 t

Re: [R] Package recommendations for outputting table with cell formatting

2020-10-23 Thread Dennis Fisher
Patrick Doing this in Excel is certainly an option. But I would like to learn how to do it in R. Dennis Dennis Fisher MD P < (The "P Less Than" Company) Phone / Fax: 1-866-PLessThan (1-866-753-7784) www.PLessThan.com > On Oct 23, 2020, at 6:15 PM, Patrick (Malone Quantitative) > wrote: >

Re: [R] Package recommendations for outputting table with cell formatting

2020-10-23 Thread Patrick (Malone Quantitative)
Will this need to be done many times? If not, it might be just as easy to apply conditional formatting to cells after they're already in Excel. On Fri, Oct 23, 2020 at 8:28 PM Dennis Fisher wrote: > > R 4.0.2 > OS X > > Colleagues > > I have the unfortunate need to create a large number of tables

[R] Package recommendations for outputting table with cell formatting

2020-10-23 Thread Dennis Fisher
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; outputt