Skip to content
Prev 319689 / 398502 Next

Writing a hyperlink to a csv file

Le 16/03/13 15:42, Jeff Newmiller a ?crit :
I confirm that an URL is not recognized as url if in .csv file.
The solution if to generate .xml file in R in XML pakage and read it in 
Excel.

The .xml file should be like:
<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet">
  <Worksheet ss:Name="TEST">
   <Table>
    <Row ss:Index="3">
     <Cell ss:Index="2" ss:HRef="http://www.google.com"><Data 
ss:Type="String">http://www.google.com</Data></Cell>
    </Row>
   </Table>
  </Worksheet>
</Workbook>

Sincerely
Marc