下载PDF文件下载PDF文件
X
这篇文章的共同创作者是 Luigi Oppido. Luigi Oppido是美国加州圣克鲁斯县Pleasure Point Computers的所有者和经营者。他拥有超过25年的一般电脑维修、数据恢复、病毒扫除和升级经验。两年来,他还一直是加州中部KSCO电台《Computer Man Show!》的主持人。
这篇文章已经被读过21,815次。
本指南介绍如何在Windows或macOS上将XML文件导入Microsoft Excel工作簿。
步骤
- 打开Microsoft Excel。Excel位于Windows菜单的所有应用区域中的“Microsoft Office”分组下。
- 单击文件。它位于Excel的左上角。
- 如果使用的是Excel 2007,单击带有Microsoft Office徽标的圆形按钮。[1]
- 单击打开。随后会打开文件浏览器。
- 双击XML文件。根据文件的格式,可能需要更多步骤才能打开文件:
- 如果看到“导入XML”对话框,就表示此文件至少引用了一个XSLT样式表。选择打开该文件,不应用样式表以使用标准格式,或选择打开该文件,应用以下样式表以根据样式表编排数据格式。
- 如果看到“打开XML”对话框,选择作为只读Excel工作簿。
- 单击文件菜单。
- 单击另存为...。
- 导航至文件保存位置。
- 在“保存类型”下拉菜单中选择Excel工作簿。
- 单击保存。这样就能将XML数据保存为Excel文件。广告
参考
- ↑ https://support.office.com/en-us/article/Import-XML-data-6eca3906-d6c9-4f0d-b911-c736da817fa4#_showdevelopertab
- ↑ https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/import-xml/805f11b3-fead-4217-80fb-244e52c389e7
- ↑ https://www.techwalla.com/articles/how-to-convert-xml-to-csv-on-a-mac
这篇文章对你有帮助吗?
⚠️ Disclaimer:
Content from Wiki How 中文 language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
广告