Mehmet Fatih

Mehmet Fatih

  • 744
  • 941
  • 42.4k

Getting all the excel sheet names

Apr 4 2024 7:27 AM

After selecting the excel file with OpenFileDialog, I want to see the worksheet names and select the worksheet page I want. How can we fix these codes according to my request?

private void button2_Click(object sender, EventArgs e)
{
    try
    {
        System.Threading.Thread.Sleep(1000);

        // Dosya seçme penceresi açmak için
        OpenFileDialog file = new OpenFileDialog
        {
            Filter = "Excel Dosyasi |*.xls;*.xlsx"
        };
        file.ShowDialog();

        string tamYol = file.FileName;
        string baglantiAdresi = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + tamYol + ";Extended Properties='Excel 12.0;IMEX=1;'";
        OleDbConnection baglanti = new OleDbConnection(baglantiAdresi);

        OleDbCommand komut = new OleDbCommand("Select * From [" + "Sayfa1" + "$]", baglanti);
        baglanti.Open();
        OleDbDataAdapter da = new OleDbDataAdapter(komut);
        DataTable data = new DataTable();
        da.Fill(data);
        dataGridView1.DataSource = data;
        data.Dispose();
        baglanti.Close();
        komut.Parameters.Clear();
    }
    catch (Exception ex)
    {
        // Hata alirsak ekrana bastiriyoruz.
        MessageBox.Show("Dosya Seçilmedi!Hata :" + ex.Message);
    }

}

 


Answers (2)