Re: [R] Excel export into R

From: Alberto Monteiro <albmont_at_centroin.com.br>
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:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"  xmlns:html="http://www.w3.org/TR/REC-html40">  <Worksheet ss:Name="Plan1">
  <Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="3" x:FullColumns="1"    x:FullRows="1">
   <Row>
    <Cell><Data ss:Type="String">roman</Data></Cell>
    <Cell><Data ss:Type="String">greek</Data></Cell>
    <Cell><Data ss:Type="String">height</Data></Cell>
   </Row>
   <Row>
    <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>
   </Row>
   <Row>
    <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>
   </Row>
  </Table>
 </Worksheet>
</Workbook>

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)
cat(y[,1])

Alberto Monteiro



R-help_at_r-project.org mailing list
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. 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 https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive