How to read file using NPOI

Question

I found NPOI is very good to write Excel files with C#.

But I want to open, read and modify Excel files in C#.

How can I do this?

Answer 1

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. :)