如何读取/转换Excel XML文件到R / CSV? [英] How to read/convert Excel XML files to R/CSV?
问题描述
我有几百个XML文件。它们可能是从/到Excel生成的。我想读它到R或转换为CSV。所有文件的标题都如下所示:
<?xml version =1.0encoding =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: w3.org/TR/REC-html40\">
< DocumentProperties xmlns =urn:schemas-microsoft-com:office:office>
我可以随时写解析器,但是想避免这样做。我没有Excel
R Data Import / Export手册中有一个章节使用R安装的手册)从Excel电子表格中读取数据。如果上述XML文件是来自最新版本的Excel的保存的电子表格,那么其中一些工具应该很容易阅读。我可能会从RODBC包或XLConnect包开始。
如果这些不工作,那么XML包应该至少让编写解析器更容易。 / p>
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:
<?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">
I can always write parser, but would like to avoid doing it. I don't have Excel
There is a chapter in the "R Data Import/Export" manual (one of the free manuals that installs with R) on reading data from Excel spreadsheets. If the above XML file is a saved spreadsheet from recent versions of Excel then some of those tools should read them easily. I would probably start with either the RODBC package or the XLConnect package.
If those don't work then the XML package should at least make writing the parser much easier.
这篇关于如何读取/转换Excel XML文件到R / CSV?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!