How to read file using NPOI

by

Simple read example below: 

using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;

//.....

private void button1_Click(object sender, EventArgs e)
{
    HSSFWorkbook hssfwb;
    using (FileStream file = new FileStream(@"c:\test.xls", FileMode.Open, FileAccess.Read))
    {
        hssfwb= new HSSFWorkbook(file);
    }

    ISheet sheet = hssfwb.GetSheet("Arkusz1");
    for (int row = 0; row <= sheet.LastRowNum; row++)
    {
        if (sheet.GetRow(row) != null) //null is when the row only contains empty cells 
        {
            MessageBox.Show(string.Format("Row {0} = {1}", row, sheet.GetRow(row).GetCell(0).StringCellValue));
        }
    }
}

By the way: on NPOI website here in Download section there is example package – a pack of C# examples. Try it, if you haven’t yet. 🙂

More Related Contents:

  1. Reading Excel files from C#
  2. How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
  3. Reading excel file using OLEDB Data Provider
  4. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  5. How to open an Excel file in C#?
  6. C# create/modify/read .xlsx files
  7. EPPlus number format
  8. How to read data from excel file using c# [duplicate]
  9. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  10. How to make correct date format when writing data to Excel
  11. Importing Excel into a DataTable Quickly
  12. How to save workbook without showing save dialog with Excel interop?
  13. Why appending AutoFilter corrupts my excel file in this example?
  14. How to import all the Excel sheets to DataSet in C#
  15. Scientific notation when importing from Excel in .Net
  16. EPPlus – LoadFromCollection – Text converted to number
  17. As of today, what is the right way to work with COM objects? [duplicate]
  18. .Net Excel Interop Deleting a worksheet
  19. Difference between ObservableCollection and BindingList
  20. XML serialization of interface property
  21. String Concatenation using ‘+’ operator
  22. How to save a List on Settings.Default?
  23. Escape invalid XML characters in C#
  24. how to use XPath with XDocument?
  25. Travel through pixels in BMP
  26. memcpy function in c# [duplicate]
  27. .NET Core vs Mono
  28. Validating file types by regular expression
  29. ASP.NET Web API and [Serializable] class
  30. trying to convert rgb from a .net Color to a string such as “red” or “blue”

Leave a Comment