npoi – Tarik Billa

MemoryStream seems be closed after NPOI workbook.write?

August 30, 2023 by Tarik

Update 1/3/2020: As Florian Dendorfer pointed out, there is an override added in October 2018 to prevent the stream from closing. Please try the overload first before using this workaround (and upvote Florian’s answer!) Leaving original answer for historical purposes. Another workaround to this issue…which doesn’t use multiple MemoryStream objects. Create a NpoiMemoryStream class that … Read more

How to read file using NPOI

January 15, 2023 by Tarik

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 … Read more