[R] XLSX package + Excel creation question

Rainer Hurling rhurlin at gwdg.de
Thu Aug 29 14:55:51 CEST 2013


Am 29.08.2013 12:08 (UTC+1) schrieb Zsurzsa Laszlo:
> Dear R users,
> 
> I have a question about the xlsx package. It's possible to create excel
> files and color cells and etc.

yes, with package xlsx you can colourize you data sheets, even the
fonts. See for example ?CellStyle .

A good demonstration of the capabilities is on
http://tradeblotter.wordpress.com/2013/05/02/writing-from-r-to-excel-with-xlsx/

> 
> My question would be that is it possible to color only some part of the
> data hold in a cell. Let's assume I've got the following data :
> 167,153,120,100 and I want to color to red everything that is bigger then
> 120. How can I achive this using R.
> 
> Example file setup with a few lines in attachment. (SEL_MASS column can be
> used for example)

Attachment missing ...

HTH,
Rainer

> 
> Thank you in advance,
> -------------------------------------------------------------------------------------
> - László-András Zsurzsa,                                                -
> - Msc. Infromatics, Technical University Munich, Germany -
> - Scientific Employee, TUM                                             -
> -------------------------------------------------------------------------------------



More information about the R-help mailing list