问题描述
我需要读取包含8列的.xls文件,列号为1320905829的第1列是密钥,它与此密钥有相关记录。就像我有一个
大的excel文件,它是16MB,其中有近226000条记录。为了避免任何内存泄漏,在VB.net中处理大型.xls文件的最佳方法是什么。是否有任何人有任何示例代码来处理此建议或任何建议。
有没有人认为将excel文件读入数据表是最好的开始方式。随着文件的增长,处理这种情况的最佳方法是什么。有时候文件
也可能超过16MB。这取决于。
主要目的是稍后将密钥id与.txt文件中的相关记录进行比较。
Hi,
I need to read .xls file which has 8 columns and column 1 which has id number like 1320905829 is the key and it has related records to this key. Like that I have a
big excel file which is 16MB and almost 226000 records in it. To avoid any memory leaks what is the best way to handle reading a large .xls file in VB.net. Does any one has any sample code to deal this or any suggestions.
Does anyone think reading the excel file into datatables is the best way to start. As the file grows what is the best way to handle this situation. some times the file
can be more than 16MB too. It depends.
The main purpose is to compare the key id with related records in a .txt file later on.
推荐答案
这篇关于在VB.Net中读取一个大的.xls文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!