开发者

Speed Up OpenXML retrieving values

开发者 https://www.devze.com 2023-01-10 06:44 出处:网络
I am using the example from http://msdn.microsoft.com/en-us/library/bb332058(v=office.12).aspx to retrieve values from an excel file.I am retrieving about 1500 values, and it is very slow.

I am using the example from http://msdn.microsoft.com/en-us/library/bb332058(v=office.12).aspx to retrieve values from an excel file. I am retrieving about 1500 values, and it is very slow.

My question does anyone know a better way to retrieve values quickly out of an excel file?

One thing that did save about 6 seconds was not opening the file every time a v开发者_开发百科alue was needed but just keep the file open throughout the process. But even doing this it is still taking about 22 seconds for it to complete.


We used http://code.google.com/p/pugixml/ to read in the XML and access the data. Very fast!

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号