How to read/convert Excel XML files to R/CSV?

vat0r

New Member
I have few hundred XML files. They are probably generated from/to Excel. I would like to read it to R or convert to CSV. Headers of all files look like this:\[code\]<?xml version="1.0" encoding="UTF-8"?><?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"><DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">\[/code\]I can always write parser, but would like to avoid doing it. I don't have Excel
 
Back
Top