This project is read-only.

Append data after open/read excel

Mar 10, 2014 at 7:41 AM
I want to append some data after reading excel file. How to do this so I am able to append data.
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using NPOI.HSSF.UserModel;
using NPOI.HSSF.Util;
using NPOI.SS.UserModel;
using NPOI.SS.Util;
using NPOI.XSSF.UserModel;'

XSSFWorkbook wb;
            using (FileStream file = new FileStream(@"test.xlsx", FileMode.Open, FileAccess.ReadWrite))
                wb = new XSSFWorkbook(file);

                ISheet sheet = wb.GetSheet("Sheet1");                

                sheet.CreateRow(8).CreateCell(0).SetCellValue("testnew row cell value");
Data doesn't append!!!
Mar 13, 2014 at 9:06 PM
Don't understand what you want. NPOI supports opening template and add/modify cell data.
Marked as answer by tonyqus on 5/13/2014 at 4:57 PM