How to use the VLOOKUP function using NPOI c# ?

Question

Thanks in Advance....

Anish Kumar · Answer

Sorry i can't understand this code snippet. Can you explain this code how its work as VLOOKUP function?.

Bhuvanesh Mohankumar · Answer

may this be helpful sample. using NPOI.HSSF.UserModel; using NPOI.SS.UserModel; //..... private void button1_Click( object senderEventArgse) { HSSFWorkbookhssfwb; using (FileStreamfile= new FileStream(@ c:	est.xls FileMode.OpenFileAccess.Read)) { hssfwb= new HSSFWorkbook(file); } ISheetsheet=hssfwb.GetSheet( Arkusz1 ); for ( int row=0;row { if (sheet.GetRow(row)!= null ) //nulliswhentherowonlycontainsemptycells { MessageBox.Show( string .Format( Row{0}={1} rowsheet.GetRow(row).GetCell(0).StringCellValue)); } } } Mark as answer if helpful.