Alternative for Spire.XLS to Read XLS file in C#

Question

Hi, Can anyone please suggest a good library for reading XLS file in C# like Spire.XLS and that is Free and no license required for use of that library?

Guest User · Answer

Check out: https://www.nuget.org/packages/NPOI/

Guest User · Answer

IIRC there should be a LastRowIndex property. I don't have NPOI installed at the moment, so cannot check. I am not entirely sure.

Nikunj Satasiya · Answer

Hi pritaeas, Do you know how we can identify wather the worksheet is blank or not using the NPOI library? I have a search on google about the same but didn't get any helpful resources. Can you please help me?

Nikunj Satasiya · Answer

Thanks pritaeas and Rajanikant Hawaldar for your valuable answer, Actually I think I should go with NPOI library, it's free and easy to implement compared to spreadsheet light library. And pritaeas, I got a solution for error that I have asked about to you, I have used class XSSFWorkebook instead of HSSFWorkebook for Write data in the workbook from Xls document. Thanks for your support,

Guest User · Answer

I have never seen this before. I did find a post about it though: https://stackoverflow.com/questions/34291338/cannot-find-central-directory-error/43155116

Rajanikant Hawaldar · Answer

Hi Nikunj Satasiya. Please check this. http://spreadsheetlight.com/ https://stackoverflow.com/questions/151005/how-do-i-create-an-excel-xls-and-xlsx-file-in-c-sharp-without-installing-mic

Nikunj Satasiya · Answer

Hi Pritaeas, when I trying to Write data in workbook from xls document. it shows this error Have you any idea about it?

Guest User · Answer

This is the website linked from the previous URL: https://github.com/tonyqus/npoi (it states it's totally free) Here's an introduction on usage from another blog: http://www.independent-software.com/introduction-to-npoi.html

Nikunj Satasiya · Answer

Hi Pritaeas, as you suggested NPOI library then it is free ? or need to purchase licence version for this library? Or have you any good resource or reference link for sample example for use of this library?