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); } } } }

How to bind combobox using excel column in c#?

Answers (4)