Re: [R] Excel export into R

From: Alberto Monteiro <>
Date: Thu, 06 Mar 2008 09:37:16 -0200

Keizer_71 wrote:
> I have this in excel
> Control
> 543_BU
> 123_AT
> 432_CU
> I want to be able to import to R so that it will read like this
> c<-c("543_BU","123_AT","432_CU")
> output:
> [1] "543_BU" "123_AT" "432_CU"
> This is just a short version. I have about 200000 rows and i need a simpler
> way instead of typing each one.
It would be nice if you could give a reproducible example, like giving the xls spreadshit as a xml file, so that it makes it easy to reproduce the example.

For example, I had some trouble with read.xls, but I could figure out (by rtfming) what the problem was. But if I hadn't solved the problem, I would have asked here, by composing a reproducible example. The unsent message would have been like this:

Take this xml file, convert to test.xls (using Excel) and read in R using x <- read.xls("test.xls")

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"  xmlns:html="">  <Worksheet ss:Name="Plan1">
  <Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="3" x:FullColumns="1"    x:FullRows="1">
    <Cell><Data ss:Type="String">roman</Data></Cell>
    <Cell><Data ss:Type="String">greek</Data></Cell>
    <Cell><Data ss:Type="String">height</Data></Cell>
    <Cell><Data ss:Type="String">Marte</Data></Cell>
    <Cell><Data ss:Type="String">Ares</Data></Cell>
    <Cell><Data ss:Type="Number">1.9</Data></Cell>
    <Cell><Data ss:Type="String">Venus</Data></Cell>
    <Cell><Data ss:Type="String">Aphrodite</Data></Cell>
    <Cell><Data ss:Type="Number">1.6</Data></Cell>

I want to have a list of the planet names in roman, but x[,1] is not an array of strings, and cat(x[,1]) gives an error. --- end of fictional message ---

FWIW, the reply to this message is:
y <- as.matrix(x)

Alberto Monteiro mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Thu 06 Mar 2008 - 11:39:31 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 06 Mar 2008 - 12:30:19 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.

list of date sections of archive