read .xlsx without Excel and OLEDB

Question

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.

What does "read" actually mean? What are you trying to do with the file? Extract data? Read document properties? Any modifications? Display or print? — Dirk Vollmar, Nov 05 '10 at 13:13

score 4 · Answer 1 · answered Nov 05 '10 at 13:19

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.

score 3 · Accepted Answer · edited Jan 29 '11 at 15:08

3

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

edited Jan 29 '11 at 15:08

Kev

118,037
53
300
385

answered Nov 05 '10 at 14:52

Sunlog

269
1
3
13

This Library Doesn´t work under Medium-Trust according to http://exceldatareader.codeplex.com/discussions/205317 – Lelis718 Dec 22 '11 at 13:31
Beware this library... I used it until I found some bugs parsing more advanced formats (hyperlinked emails). – hross Jun 28 '12 at 17:59
Excellent class.. really easy to use. – Mike Gledhill Jun 24 '14 at 10:32

score 2 · Answer 3 · answered Nov 05 '10 at 13:52

2

Koogra can read .xlsx files.

answered Nov 05 '10 at 13:52

stuartd

70,509
14
132
163

I did a lot of searching for similar and I found Koogra to be the most reliable, free solution that handles .xls and .xlsx and doesn't require any install/dependencies. – hross Jun 28 '12 at 17:58

score 0 · Answer 4 · answered Sep 05 '12 at 11:54

0

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

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

answered Sep 05 '12 at 11:54

whitestream

691
1
7
14

score 0 · Answer 5 · answered Nov 05 '10 at 13:10

0

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

answered Nov 05 '10 at 13:10

Adrian Fâciu

12,414
3
53
68

unfortunately I need Xlsx-Files noct Xls – Sunlog Nov 05 '10 at 13:14

score 0 · Answer 6 · edited May 23 '17 at 11:50

0

This question looks to be similar to this one no?

Have you checked NPOI ?

Best

edited May 23 '17 at 11:50

Community

1
1

answered Nov 05 '10 at 13:12

Vagaus

4,174
20
31

1

http://npoi.codeplex.com/workitem/6108 - this is the bug tracker item for XLSX support in NPOI. No support for the format requested would make it a non-starter. – 48klocs Nov 05 '10 at 13:37

score 0 · Answer 7 · answered Nov 05 '10 at 13:12

0

We use NPOI successfully in our projects.

answered Nov 05 '10 at 13:12

Bas Danen

311
1
10

score 0 · Answer 8 · answered Nov 05 '10 at 13:15

0

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

Here's one

Here's another

answered Nov 05 '10 at 13:15

rgunawan

314
1
6

read .xlsx without Excel and OLEDB

8 Answers8

Linked