0

I use NPOI 2.0.1 beta to import excel(xlsx) data to GridView .
Firstly , using this link , convert xlsx Worksheet format to xls Worksheet .
But , at the following line , it's show me error .

 HSSFWorkbook workbook = new HSSFWorkbook();
 MemoryStream memoryStream = new MemoryStream();
 HSSFSheet sheet = workbook.CreateSheet("Sheet1");
 HSSFRow headerRow = sheet.CreateRow(0);

And here is a screen-shoot ,

enter image description here

How can I fix it ?
Or is there a better way ? Thanks In Advance :)

zey
  • 5,939
  • 14
  • 56
  • 110

1 Answers1

1

In NPOI 2.0, you should use ISheet and IWorkbook interface.

ISheet sheet = workbook.CreateSheet("Sheet1");

Tony Qu
  • 676
  • 8
  • 14