openxlsx is not solving my problem either. It is corrupting my xlsx file. I have a large data.frame, which I want to export to an existing xlsx file, without formatting that existing file. With XLconnect there is an option "setStyleAction(wb,XLC$"STYLE_ACTION.NONE")" which does it so. I am looking for a similar codeline for xlsx package which will enable me to save my data.frame in my existing file without formatting my xlsx file.
Thanks, On Tue, Sep 27, 2016 at 3:39 AM, jim holtman <jholt...@gmail.com> wrote: > 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. > > ______________________________________________ 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.
