I use the "openxlsx" package to handle spreadsheets.
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 Mon, Sep 26, 2016 at 5:56 PM, Christofer Bogaso < bogaso.christo...@gmail.com> wrote: > Hi again, > > 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 <sezenism...@gmail.com> > wrote: > > I think, this is what you are looking for: > > > > http://stackoverflow.com/questions/11228942/write-from- > r-into-template-in-excel-while-preserving-formatting > > > > On 11 Jul 2016, at 03:43, Christofer Bogaso <bogaso.christo...@gmail.com > > > > wrote: > > > > 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 : > > > > http://stackoverflow.com/questions/32632137/using- > write-xlsx-in-r-how-to-write-in-a-specific-row-or-column-in-excel-file > > > > 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. > > > > Thanks, > > > > ______________________________________________ > > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > > 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. > > > > > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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. > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
