从Excel表导出数据到XML文件

I am dealing with a large number of records. I have around 5,50,000 records in an excel sheet. I need to export that data in an XML file. I tried using the inbuilt functions in Excel but it has a limitation. A max of only 65,000 records can be exported into XML file using Excel. Can you please suggest something on how can this be done?

我正在处理大量的记录。我在excel表格中有大约550,000条记录。我需要将这些数据导出到一个XML文件中。我尝试在Excel中使用内置函数，但它有一定的局限性。最多只有65,000条记录可以使用Excel导出到XML文件中。你能建议一下怎么做吗?

Thanks.

谢谢。

1 个解决方案

#1

1. Make sure your file is saved in the XLSX format.
2. 确保您的文件保存为XLSX格式。
3. In File Explorer, right click the XLSX file > Unzip.
4. 在文件资源管理器中，右击XLSX文件>解压。
5. Browse unzipped contents, you should see an XML file with your data. In my version of Excel, the data is in the \xl\worksheets folder.
6. 浏览未压缩的内容，应该会看到带有数据的XML文件。在我的Excel版本中，数据在\xl\工作表文件夹中。