How to Import Excel to Datagrid without OleDB?

Question

Hello, my application is 64bit native, therefore the examples on how to import an excel file to a gridview, are useless, due to the OleDB drivers been 32bit only... is there a way around, on how to import an excel file to a datagrid without using the OleDB connection?

Answer 1

Here's an SO thread on work arounds for 64-bit OleDB. As I said in that thread, the answer is not very satisfying at the moment.

Answer 2

SpreadsheetGear for .NET will do it and supports 64 bit .NET 2.0+.

You can see live ASP.NET (C# & VB) samples here, DataGrid samples here and download a free trial here if you want to try it yourself.

Disclaimer: I own SpreadsheetGear LLC

Answer 3

Many third party components(commercial) have this feature:

ActiveXLS

Aspose cell

GemBox.Spreadsheet

SmartXLS