Displaying 3 results from an estimated 3 matches for "rexcelxml".
2011 Aug 10
1
Reading XML files masquerading as XL files
R version 2.13.1
OS X (or Windows)
Colleagues,
I received a number of files with a .xls extension. These files open in XL and, by all appearances, are XL files. However, it appears to me that the files are actually XML:
> readLines(dir()[16])[1:10]
[1] "<?xml version=\"1.0\"?>"
[2] "<Workbook
2010 Oct 18
2
Randomly shuffle an array 1000 times
Dear List,
I have a table i have read into R:
Name Yes/No
John 0
Frank 1
Ann 0
James 1
Alex 1
etc - 800 different times.
What i want to do is shuffle yes/no and randomly re-assign them to the name.
I have used sample() and permute(), however there is no way to do this 1000 times. Furthermore, i want to copy the data into a excel spreadsheet in the same order as the data was input so i can
2009 Jul 09
2
How to Populate List
...ain; charset=ISO-8859-1; format=flowed
I did some preliminary work on xslx (and docx and pptx) files
some time ago and will hopefully finish things off by the
end of summer. We can read these with a combination
of the Rcompression and XML package.
I have put versions of two packages (ROOXML and RExcelXML)
at
http://www.omegahat.org/Prerelease/
(ROOXML_0.1-0.tar.gz and RExcelXML_0.1-0.tar.gz)
There are no guarantees about how they work at this point, but
the basic structures are there. I'd be happy to hear about any problems
and to try to add functionality. Given the framework, it should
b...