as an alternative to the component you can query a spreadsheet as a "classic" datasource like Sql Server. Create a connection string pointing to the path of your file and use the Microsoft.jet.oledb.4.0 provider (it is not available on x64 os, in that case you will have to use third party component to establish the connection). Once this is done you can run sql statements over your .xls .
Here you can find some useful infos : hhttp://www.davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx
发布评论
评论（5）
它不是开源的，但我通常使用 Open XML SDK 2.0 由 Microsoft 执行此类工作。
It's not open source, but I usually find myself using the Open XML SDK 2.0 from Microsoft to perform this type of work.
作为该组件的替代方案，您可以将电子表格作为“经典”数据源（如 Sql Server）进行查询。创建一个指向文件路径的连接字符串并使用 Microsoft.jet.oledb.4.0 提供程序（它在 x64 操作系统上不可用，在这种情况下，您将必须使用第三方组件来建立连接）。完成此操作后，您可以在 .xls 上运行 sql 语句。
在这里您可以找到一些有用的信息：hhttp://www.davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx
as an alternative to the component you can query a spreadsheet as a "classic" datasource like Sql Server. Create a connection string pointing to the path of your file and use the Microsoft.jet.oledb.4.0 provider (it is not available on x64 os, in that case you will have to use third party component to establish the connection). Once this is done you can run sql statements over your .xls .
Here you can find some useful infos : hhttp://www.davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx
Aspose.Cells 是一个处理 Excel 文件的好库。
但是，它不是开源的。
我还没有找到一个好的开源库。
Aspose.Cells is a good library for handling Excel files.
However, it is not open source.
I have yet to find a good library that is open source for this.
看看 EPPlus：Codeplex。
请注意，它仅适用于 .xlsx，这是一个问题吗？或者它可以工作吗？
Take a look at EPPlus: Codeplex.
Note that it only works with .xlsx, is that a problem, or could it work?
我正在使用此代码读取 excel 文件（.xls 二进制） http://www.codeproject .com/KB/office/Excel_DataReader.aspx
I am using this code for reading excel file(.xls binary) http://www.codeproject.com/KB/office/Excel_DataReader.aspx