Summary: [R] How to represent pure linefeeds chr(10) under R for Windows

Gabor Grothendieck ggrothendieck at
Fri Nov 7 14:04:18 CET 2003

While I don't disagree with what you say, the purpose of this 
is to interface to Excel which is even less free (you
have to pay for Excel but not for dataload) so 
perhaps the status of the glue used between R and Excel 
is not as important.  

>From an expediency viewpoint, I found that dataload solves
a wide variety of interfacing problems easily, typically 
in a single line of code, using a single tool and consistent 
syntax.  I can translate easily among .rda, .xls, .csv, .txt 
and numerous other formats.  

Date: Fri, 7 Nov 2003 10:32:44 +0100 
From: Martin Maechler <maechler at>
To: <ggrothendieck at> 
Cc: <joehl at>, <r-help at> 
Subject: Re: Summary: [R] How to represent pure linefeeds chr(10) under R for Windows 

>>>>> "Gabor" == Gabor Grothendieck <ggrothendieck at>
>>>>> on Thu, 6 Nov 2003 15:33:04 -0500 (EST) writes:

Gabor> Its also possible to avoid these intricacies by not
Gabor> using an intermediate text representation, i.e. csv,
Gabor> in the first place.

Gabor> The following R code uses the free dataload utility
Gabor> (Google search for Baird dataload utility) to create
Gabor> an .xls file from data frame, x:

Gabor> save(x,file="x.rda") 
Gabor> system("dataload x.rda x.xls/u")

Gabor> At this point you can read x.xls into Excel.

Note that this has two "problems" IMO, which Jens' R-only
solution does not have:

1) dataload is *not* free software in the sense of the 
Free Software Foundation (which has existed for a much
longer time than MS windows!):
It's only "free" as in "free beer", not "free" as in "free speech" .
For more, read the "Free as in Freedom" main link on

2) dataload is only available as *binary* on *some* platforms,
as opposed to R which is available to everyone working with
it :-)

Martin Maechler <maechler at>
Seminar fuer Statistik, ETH-Zentrum LEO C16     Leonhardstr. 27
ETH (Federal Inst. Technology)     8092 Zurich     SWITZERLAND
phone: x-41-1-632-3408          fax: ...-1228               <><

More information about the R-help mailing list