64 位上的 Excel ODBC - 再次
我担心这已经被打死了，但我仍然在努力解决在最近移植到 Server 2008 和 64 位的 ASP.NET 应用程序中读取 Excel 文件的问题。
我发现很多帖子都指出了 64 位 Microsoft 驱动程序的存在：
我担心的是，我也在阅读有关这些不打算“作为服务器端应用程序中 Jet OLEDB 提供程序的替代品”的警告，可能是出于线程安全的原因？这是一个服务器端应用程序，虽然 Excel 上传不会每天发生数百次，但它们将由客户完成。
我知道也有可用的商业图书馆，当我开始考虑它们时，我确实担心“修订追逐”，并且担心它们不会被它们搞垮（我们以前也发生过这种情况）。
那么，是否有一种线程安全、服务器安全的方式来读取 64 位的 Excel 文件呢？
在您建议使用 .CSV 之前，我很难让客户向我发送格式合理的 Excel 文件，更不用说要求他们导出为 .csv。
哦，还要添加另一个要求，我真的不想以 32 位运行整个应用程序。
I fear this has been beaten to death, but I'm still struggling with the problem of reading Excel files in my ASP.NET application that has recently been ported to Server 2008 and 64-bit.
Many posts I find point to the existence of 64-bit Microsoft drivers here:
My concern is the warnings I'm also reading about these not intended "As a replacement for the Jet OLEDB Provider in server-side applications" possibly for thread-safe reasons? This IS a server-side application and while Excel uploads aren't hundreds-of-times-a-day ocurrances, they will be done by customers.
I know there are also commercial libraries available and while I'm opening to considering them I do worry about the 'revision chase' and not getting burned by them going belly-up (it has happened to us before).
So, IS there a thread-safe, server-safe way to read Excel files in 64 bits?
And before you suggest .CSV, I have a hard enough time getting customers to send me reasonably-formatted Excel files, let alone asking them to export to a .csv.
Oh, and to add yet-another-requirement, I really don't want to run the whole application 32-bit.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可以连接到 Java 库，如下所示：
http://jexcelapi.sourceforge.net/
You may be able to hook into a Java library such as this:
http://jexcelapi.sourceforge.net/
我与这些人没有任何关系： SpreadsheetGear 但他们的工具完全解决了我的问题。极快的全服务器公式评估。非常酷。
I have no affiliation with these guys: SpreadsheetGear but their tool completely solved my problem. Wicked fast and server-wide formula evaluation. VERY cool.