How to bind combobox using excel column in c#?

Question

How to populated combo box using Excel column in c# please help...thanks in adv..

Leon D · Answer

You can use free spire.xls to read data in Excel column and then bind the data to combo box.   First, install free spire.xls via nuget (https://www.nuget.org/packages/FreeSpire.XLS/).   Second, refer to the below code. private   void  button1_Click( object  sender, EventArgs e)           {               Workbook workbook =  new  Workbook();                //Load Excel file                workbook.LoadFromFile( "input.xlsx" );                   //Get the first worksheet                Worksheet sheet = workbook.Worksheets[0];                   //Bind data in the first Excel column to combo box                 for  ( int  row = 1; row              {                   string  value = sheet.Range[row, 1].Value;                  comboBox1.Items.Add(value);               }           }    Excel file:     Combo box:

Pusting · Answer

Here is another example that you can try:  // Load Excel file.    var workbook = ExcelFile.Load( "input.xlsx" );      // Get first sheet.    var worksheet = workbook.Worksheets[0];   // Get first column.    var column = worksheet.Columns[0];      // Iterate through column's cells.    for  ( int  index = 0; index  {       var cell = column.Cells[index];        // Add cell's value to ComboBox.        comboBox1.Items.Add(cell.Value);    }   The code uses a free version of GemBox.Spreadsheet: https://www.gemboxsoftware.com/spreadsheet   You can also download it from NuGet: https://www.nuget.org/packages/GemBox.Spreadsheet/

Rajanikant Hawaldar · Answer

https://www.c-sharpcorner.com/blogs/retrieving-excel-data-and-binding-to-a-combobox-in-c-sharp1

Rajanikant Hawaldar · Answer

The following code snippet allows you to browser an excel file on your machine and get data from the Excel sheet and bind one column of the Excel sheet to a ComboBox control.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace Retrieving_excel_data_to_combobox
{
public partial class Form1 : Form
{
public OleDbConnection con;
public void pintu(string s)
{
con = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " + "data source='" + s + " '; " + "Extended Properties=Excel 8.0;");
}
public OleDbCommand com;
public DataSet ds;
public OleDbDataAdapter oledbda;
public DataTable dt;
public string str;
public Form1()
{
InitializeComponent();
}
private void btnbrowse_Click(object sender, EventArgs e)
{
OpenFileDialog openfiledialog1 = new OpenFileDialog();
openfiledialog1.ShowDialog();
openfiledialog1.Filter = "allfiles|*.xls";
TextBox1.Text = openfiledialog1.FileName;
}
private void Form1_Load(object sender, EventArgs e)
{
comboBox1.Text = "Please select";
}
private void btndisplay_Click(object sender, EventArgs e)
{
pintu(TextBox1.Text);
try
{
con.Open();
str = "select * from [sheet1$]";
com = new OleDbCommand(str, con);
ds = new DataSet();
oledbda = new OleDbDataAdapter(com);
oledbda.Fill(ds, "[sheet1$]");
con.Close();
DataGridView1.DataSource = ds;
DataGridView1.DataMember = "[sheet1$]";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
con.Open();
str = "select * from [sheet1$]";
com = new OleDbCommand(str, con);
oledbda = new OleDbDataAdapter(com);
ds = new DataSet();
oledbda.Fill(ds, "[sheet1$]");
con.Close();
dt = ds.Tables["[sheet1$]"];
int i = 0;
for (i = 0; i <= dt.Rows.Count -1; i++)
{
comboBox1.Items.Add(dt.Rows[i].ItemArray[0]);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}