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
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
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,
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
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.
-
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
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.
--
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
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
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
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
11 matches
Mail list logo