CODEWITHSUNDEEP
.netexcel
Yongwei Xing
Yongwei Xing

Reputation: 13441

Parse the Excel file using C#

I want to use the C# to parse Excel file, like get data from it.

I Google it on net, find most of them use Microsoft.Jet.OLEDB.4.0. This program would run a x64 Windows 2008 server. But the Jet engine is not available for x64 and no longer used. Is there any way to do it?

Best Regards,

Upvotes: 2

Views: 2890

Answers (3)

Ken
Ken

Reputation: 2944

There's a C# conversion of JExcelApi floating around somewhere that works.

Upvotes: 0

AMissico
AMissico

Reputation: 21684

Search for BIFF8. This is the format for Excel 97-2003.

"Excel Data Reader - Read Excel files in .NET" at http://www.codeplex.com/ExcelDataReader

"Create Excel Workbook (BIFF8) without having Excel Installed (Updated)" at http://www.freevbcode.com/ShowCode.Asp?ID=6887

.NET Managed Reader for Microsoft® Excel at http://xport.mvps.org/Default.aspx

Upvotes: 0

Joe Erickson
Joe Erickson

Reputation: 7217

SpreadsheetGear for .NET is an Excel compatible spreadsheet component for .NET which works with 32 bit and with 64 bit applications (one of the great features of .NET is building one executable which works fine with both). With SpreadsheetGear you can load Excel workbooks, get underlying the data of a cell (number, text, etc...), get formatted text of a cell, recalculate, etc...

You can find live ASP.NET samples here and download the free trial here if you want to try it yourself.

Disclaimer: I own SpreadsheetGear LLC

Upvotes: 1

Related Questions