开发者

read .xlsx without Excel and OLEDB

开发者 https://www.devze.com 2023-01-23 21:26 出处:网络
Is there any chance to read .xlsx files in C# without having Excel installed on the client, and with no OLEDB connection ava开发者_如何学Cilable?

Is there any chance to read .xlsx files in C# without having Excel installed on the client, and with no OLEDB connection ava开发者_如何学Cilable?

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


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.


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


Koogra can read .xlsx files.


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


This question looks to be similar to this one no?

Have you checked NPOI ?

Best


We use NPOI successfully in our projects.


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

Here's one

Here's another


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

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

0

精彩评论

暂无评论...
验证码 换一张
取 消