这是R代码
library("XML")
library("methods")
xmldataframe <- xmlToDataFrame("C://Users//Administrator//OneDrive//work_data//数据//ABC导出数据//人员表.xml")
print(xmldataframe)
下面是xml数据结构
<ss:Row>
<ss:Cell ss:StyleID="s27"><Data ss:Type="String">ID</Data></ss:Cell>
<ss:Cell ss:StyleID="s27"><Data ss:Type="String">iBuiId</Data></ss:Cell>
<ss:Cell ss:StyleID="s27"><Data ss:Type="String">iCount</Data></ss:Cell>
<ss:Cell ss:StyleID="s27"><Data ss:Type="String">iGivCount</Data></ss:Cell>
<ss:Cell ss:StyleID="s27"><Data ss:Type="String">iYouComInfoId</Data></ss:Cell>
</ss:Row>
<ss:Row>
<ss:Cell><Data ss:Type="Number">31</Data></ss:Cell>
<ss:Cell><Data ss:Type="Number">290</Data></ss:Cell>
<ss:Cell><Data ss:Type="Number">10000</Data></ss:Cell>
<ss:Cell><Data ss:Type="Number">100</Data></ss:Cell>
<ss:Cell><Data ss:Type="Number">26</Data></ss:Cell>
</ss:Row>
library("XML")
library("methods")
xmldataframe <- xmlToDataFrame("C://Users//Administrator//OneDrive//work_data//数据//ABC导出数据//人员表.xml")
print(xmldataframe)
下面是xml数据结构
<ss:Row>
<ss:Cell ss:StyleID="s27"><Data ss:Type="String">ID</Data></ss:Cell>
<ss:Cell ss:StyleID="s27"><Data ss:Type="String">iBuiId</Data></ss:Cell>
<ss:Cell ss:StyleID="s27"><Data ss:Type="String">iCount</Data></ss:Cell>
<ss:Cell ss:StyleID="s27"><Data ss:Type="String">iGivCount</Data></ss:Cell>
<ss:Cell ss:StyleID="s27"><Data ss:Type="String">iYouComInfoId</Data></ss:Cell>
</ss:Row>
<ss:Row>
<ss:Cell><Data ss:Type="Number">31</Data></ss:Cell>
<ss:Cell><Data ss:Type="Number">290</Data></ss:Cell>
<ss:Cell><Data ss:Type="Number">10000</Data></ss:Cell>
<ss:Cell><Data ss:Type="Number">100</Data></ss:Cell>
<ss:Cell><Data ss:Type="Number">26</Data></ss:Cell>
</ss:Row>