[R] Writing data onto xlsx file without cell formatting
bogaso.christofer at gmail.com
Mon Sep 26 23:56:54 CEST 2016
I have been following above suggestion to export data from R to xlsx
file using XLconnect. However recently I am facing Java memory
allocation problem with large dataset (looks like a known issue with
this package) and therefore decided to move to using "xlsx" package.
Now I started facing that same problem of losing my existing formating
when I use xlsx package for data export. Can someone help me with some
pointer on how can I preserve the cell formating after exporting
data.frame to some existing xlsx file using "xlsx" package.
Thanks for your time.
On Mon, Jul 11, 2016 at 10:43 AM, Ismail SEZEN <sezenismail at gmail.com> wrote:
> I think, this is what you are looking for:
> On 11 Jul 2016, at 03:43, Christofer Bogaso <bogaso.christofer at gmail.com>
> Hi again,
> I am trying to write a data frame to an existing Excel file (xlsx)
> from row 5 and column 6 of the 1st Sheet. I was going through a
> previous instruction which is available here :
> However trouble is that it is modifying/removing formatting of all the
> affected cells. I have predefined formatting of those cells where data
> to be pasted, and I dont want to modify or remove that formatting.
> Any idea if I need to pass some additional argument.
> Appreciate your valuable feedback.
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help