1
Answer

Export only one column from excel into datagrid view

darma teja

darma teja
12y
1.8k
1
Hi,

I wanted to export only one colum into datagridview

My code is here:

  OpenFileDialog fdlg = new OpenFileDialog();
            fdlg.Title = "select Excel file";
            fdlg.Filter = "Excel files | *.xls";
            fdlg.FilterIndex = 2;
            fdlg.RestoreDirectory = true;
            if (fdlg.ShowDialog() == DialogResult.OK)
            {
                string filename = fdlg.FileName;


                XLS.Application myapp = new XLS.Application();

                XLS.Workbook wb = myapp.Workbooks.Open(filename);

                XLS.Worksheet sheet = (XLS.Worksheet)wb.Worksheets.get_Item(1);
                

 I am getting problem here


Thanks

Darma
Answers (1)
Next Recommended Forum