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.
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.
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
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.
Koogra can read .xlsx files.
NPOI's latest version support both xsl and xslx. Download it from
NPOI 2.0 and use NPOI.XSSF.UserModel.XSSFWorkbook fro xlsx.
We use NPOI successfully in our projects.