| To: | s-news@lists.biostat.wustl.edu |
|---|---|
| Subject: | writing to Excel files |
| From: | Eric yang <yang_eric9@yahoo.com> |
| Date: | Wed, 7 Sep 2005 03:43:26 -0700 (PDT) |
| Domainkey-signature: | a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=CLY+a9Ztpb7ygXqZ9pzeKuXtx0NEiSnfsHEMlc4HCT14Qlic28TEEnQaqPBI/aAm34y7pLKEWteD08chQJSFCnd96gJaFthUwmbRMWQ6M2ZKBpLQDBV/JXwQCU9H79y8cvNQv9+wTGiv8GDsUEZexYV+nFnROw6xCnJ/GIwlq0A= ; |
|
Dear all,
I'm writing SPLUS objects to various sheets in Excel files. I'm using the commands call.ole.method to define the range and set.ole.property to write the data, i.e.
pRange <- call.ole.method(pSheet, "Range", target.ranges)
set.ole.property(pRange, list(Value=x)
where target.ranges are the range of cells to write the data x to.
Does anyone know how to change the colour of the data to be written to the Excel files and how to change the background colour of the cells as well?
Thanks in advance for any help.
Eric
Click here to donate to the Hurricane Katrina relief effort. |
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| ||
| Previous by Date: | cv.tree in a function, Odile |
|---|---|
| Next by Date: | Changing a read-only data frame to read/write, TzamouranisY |
| Previous by Thread: | cv.tree in a function, Odile |
| Next by Thread: | Changing a read-only data frame to read/write, TzamouranisY |
| Indexes: | [Date] [Thread] [Top] [All Lists] |