title: Populating a listbox in c#
body: <p>I have a listbox and I manage to bind the Excel worksheet to the list box (after hours of researching on the Internet).</p>
  
  <p>Now I need to read the values from the sheet into the listbox, but unable to locate any suitable solution.</p>
  
  <p>This is what I have done so far:-</p>
  
  <pre><code>private void LoadExcelSheet(string path, int sheet){
     _Application excel = new Excel.Application();
     Workbook wb;
     Worksheet ws;
  
     int row = 0;
     int col = 0;
  
     wb = excel.Workbooks.Open(path);
     ws = wb.Worksheets[sheet];
  
     for (row = 1; row &lt; 10; row++){
        for (col = 1; col &lt; 6; col++){
           listBox1.Items.Add(ws.Cells[row, col].Value2);
        }
     }
   }
  //------------------ end of LoadExcelSheet---------------------------
  
   this only display 1 row with each item of data on top of each other eg:-
  
  aaaaaaaa
  bbbbbbbb 
  cccccccc
  dddddddd
  
  instead of: aaaaaaaa bbbbbbbb cccccccc dddddddd 
  </code></pre>
  
  <p>Thanks in advance.. </p>