Re: [R] XLSX package + Excel creation question

2013-09-04 Thread Zsurzsa Laszlo
Thank you for the reply, I wount post any other link anymore. I did not know it's not allowed. - - László-András Zsurzsa,- - Msc. Infromatics, Technical University Mu

Re: [R] XLSX package + Excel creation question

2013-09-04 Thread Keith Jewell
I'll skip over the courtesy implications of double posting/pointing to stackoverflow. The stackoverflow thread makes it look as if you need to learn more Excel. Do you really not know what an Excel template is? It sounds as if you want what Excel calls "conditional formatting" which you can

Re: [R] XLSX package + Excel creation question

2013-09-04 Thread Zsurzsa Laszlo
http://stackoverflow.com/questions/18511249/excel-cell-coloring-using-xlsx This is the initial post on stackoverflow. Please look at this maybe I'm clearer here. Thank you in advance, - - László-András Zsurzsa,

Re: [R] XLSX package + Excel creation question

2013-08-30 Thread jim holtman
You can also look at the XLConnect package. Jim Holtman Data Munger Guru What is the problem that you are trying to solve? Tell me what you want to do, not how you want to do it. On Thu, Aug 29, 2013 at 9:40 AM, Zsurzsa Laszlo wrote: > I understand you response but it does not solve the problem

Re: [R] XLSX package + Excel creation question

2013-08-29 Thread Zsurzsa Laszlo
I understand you response but it does not solve the problem. I'am aware that one can simply color every cell in an excel file by using his own algorithm. The question was if I can write my data to a *single* cells and use different formatting for every piece of data. -

Re: [R] XLSX package + Excel creation question

2013-08-29 Thread Rainer Hurling
Am 29.08.2013 15:03 (UTC+1) schrieb Zsurzsa Laszlo: > 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. Ba

Re: [R] XLSX package + Excel creation question

2013-08-29 Thread Zsurzsa Laszlo
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. --

Re: [R] XLSX package + Excel creation question

2013-08-29 Thread Rainer Hurling
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 demonstra

[R] XLSX package + Excel creation question

2013-08-29 Thread 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. 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

Re: [R] xlsx package

2010-08-03 Thread array chip
inal Message From: array chip To: r-help@r-project.org Sent: Tue, August 3, 2010 4:41:50 PM Subject: [R] xlsx package HI, I was trying to install xlsx package for reading in Excel 2007 files. The installation went smoothly. But when I tried to load the library, I got the following error me

[R] xlsx package

2010-08-03 Thread array chip
HI, I was trying to install xlsx package for reading in Excel 2007 files. The installation went smoothly. But when I tried to load the library, I got the following error message: > library(xlsx) Loading required package: xlsxjars Loading required package: rJava Error : .onLoad failed in loadName