有没有办法将包含标头的完整XML模式下载到Google表格工作表中?
我希望将在线XML页面中的所有元素(包括标题)导入Google表格。
XML页面如下所示:
<staff>
<admin>
<first-name>Patrice</first-name>
<family-name>Withers</family-name>
<year-started>2006</year-started>
<starting-salary>30,500</starting-salary>
<current-salary>34,000</current-salary>
</admin>
<admin>
<first-name>Shelly</first-name>
<family-name>Lancer</family-name>
<year-started>2015</year-started>
<starting-salary>32,500</starting-salary>
<current-salary>33,500</current-salary>
</admin>
</staff>
<students>
<full-time>
<first-name>Henry</first-name>
<family-name>Nunes</family-name>
<status>Freshman</status>
<current-tuition>2,400</current-tuition>
<last-year-tuition>2,200</last-year-tuition>
</full-time>
<part-time>
<first-name>Leslie</first-name>
<family-name>Franks</family-name>
<status>Senior</status>
<current-tuition>2,300</current-tuition>
<last-year-tuition>2,100</last-year-tuition>
</part-time>
</students>
我正在尝试让Google表格下载完整的XML页面(包括元素标题),并显示它,最好像上面那样在缩进列中显示,或者在单列中显示如下:
<staff>
<admin>
<first-name>Patrice</first-name>
<family-name>Withers</family-name>
<year-started>2006</year-started>
<starting-salary>30,500</starting-salary>
<current-salary>34,000</current-salary>
</admin>
<admin>
<first-name>Shelly</first-name>
<family-name>Lancer</family-name>
<year-started>2015</year-started>
<starting-salary>32,500</starting-salary>
<current-salary>33,500</current-salary>
</admin>
</staff>
<students>
<full-time>
<first-name>Henry</first-name>
<family-name>Nunes</family-name>
<status>Freshman</status>
<current-tuition>2,400</current-tuition>
<last-year-tuition>2,200</last-year-tuition>
</full-time>
<part-time>
<first-name>Leslie</first-name>
<family-name>Franks</family-name>
<status>Senior</status>
<current-tuition>2,300</current-tuition>
<last-year-tuition>2,100</last-year-tuition>
</students>
IMPORTDATA
建议另一个用户使用类似的问题,但是失败,因为一些XML数据带有逗号,类似于上面的示例输出。
如果可以从身份验证凭据后面废弃您的网址,则可以尝试:
=ARRAYFORMULA(TRIM(TRANSPOSE(QUERY(TRANSPOSE(
ARRAY_CONSTRAIN(IMPORTDATA("url_here"), 5000, 20)),,999^99))))
您也可以尝试:
=IMPORTXML("url_here", "//*")
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句