CODEWITHSUNDEEP
c#asp.netexcelnpoi
zey
zey

Reputation: 6103

Cannot convert workbook to sheet in NPOI

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

Upvotes: 0

Views: 716

Answers (1)

Tony Qu
Tony Qu

Reputation: 776

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

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

Upvotes: 1

Related Questions