First of all thank you for the quick resposen. I know I can color and set up every cell. I will take a look again * CellStyle* but is it possbile for example to write an array to a single cell that has different colors for some data. Basically the color depends on the data.
------------------------------------------------------------------------------------- - László-András Zsurzsa, - - Msc. Infromatics, Technical University Munich, Germany - - Scientific Employee, TUM - ------------------------------------------------------------------------------------- On Thu, Aug 29, 2013 at 2:55 PM, Rainer Hurling <[email protected]> wrote: > 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 - > > > ------------------------------------------------------------------------------------- > [[alternative HTML version deleted]]
______________________________________________ [email protected] mailing list 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.
