使用Open XML SDK解析和读取大型Excel文件 [英] Parsing and Reading Large Excel Files with the Open XML SDK

问题描述

Open XML SDK SAX类似方法

如果在开发Open XML解决方案时遇到性能和/或内存问题，则应考虑使用 OpenXmlReader 和 OpenXmlWriter .

Open XML SDK SAX-Like Approach

If you have performance and/or memory concerns when developing an Open XML solution then you should look into using the OpenXmlReader and OpenXmlWriter.

下面的方法将使用类似于SAX的方法读取工作表数据中包含的每一行的每个单元格值.

The method below will read every cell value for each row contained within the sheet data using the SAX-like approach.

请注意，以下代码适用于包含数字值的单元格.包含其他类型内容的单元格将需要不同类型的解决方案.

Note that code below works for cells that contain numeric values. Cells that contain other types of content will need a different type of solution.

静态 无效 ReadExcelFileSAX(字符串文件名)

static void ReadExcelFileSAX(string filename)

推荐答案

 谢谢您的发帖！我建议您将您的问题发布到论坛上

 Thank you for your post!  I would suggest please post your question in the forum

  Microsoft Office >

 Microsoft Office > Microsoft Office Forums > Microsoft Office Excel Forums

位于此处: http://social.answers.microsoft.com/Forums/zh-CN/category/officeexcel

 located here: http://social.answers.microsoft.com/Forums/en-US/category/officeexcel

 祝你有美好的一天！！！！！

 Have a great day!!!!!

这篇关于使用Open XML SDK解析和读取大型Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！