[R] Writing data onto xlsx file without cell formatting

[Spencer Graves]

I don't know if "openxlsx" will solve Christofer's problem, but it 
solved a problem I encountered recently reading a large data set:


       read.xls{gdata} read 20734 obs. of 141966 rows and stopped 
without warning.  read.xls{fImport} and read_excel{readxl} both read 
65536 rows.  I couldn't get xls.reader{ProjectTemplate} to work.


       read.xlsx{openxlsx} read the file I wanted to read.


       Spencer Graves


On 9/26/2016 5:09 PM, jim holtman 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.christofer at 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 <sezenismail at 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.christofer at 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 at 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 at 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 at 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.