Reputation: 269

read .xlsx without Excel and OLEDB

Is there any chance to read .xlsx files in C# without having Excel installed on the client, and with no OLEDB connection available?

The application is a Winforms project written in VS2005 C# .NET Framework 2.0.

Upvotes: 9

Answers (8)

whitestream

Reputation: 691

NPOI's latest version support both xsl and xslx. Download it from

NPOI 2.0 and use NPOI.XSSF.UserModel.XSSFWorkbook fro xlsx.

Upvotes: 0

Sunlog

Reputation: 269

I decided to use the the Excel Data Reader on CodePlex.

Upvotes: 3

stuartd

Reputation: 73243

Koogra can read .xlsx files.

Upvotes: 2

marc_s

Reputation: 754408

How about this one here:

EPPlus-Create advanced Excel 2007 spreadsheets on the server

EPPlus is a .net library that reads and writes Excel 2007 files using the Open Office Xml format (xlsx). EPPlus supports ranges, cell styling, charts, pictures, shapes, named ranges, autofilters and a lot of other stuff.

Upvotes: 4

rgunawan

Reputation: 314

There might be some 3rd party components that can help you.

Here's one

Here's another

Upvotes: 0

Bas Danen

Reputation: 311

We use NPOI successfully in our projects.

Upvotes: 0

Vagaus

Reputation: 4215

This question looks to be similar to this one no?

Have you checked NPOI ?

Best

Upvotes: 0

Adrian Fâciu

Reputation: 12552

Have a look at excellibrary. For now it supports only xls, but xlsx support is planned for the future.

Upvotes: 0

read .xlsx without Excel and OLEDB

Answers (8)

Related Questions