private void import1_Click(object sender, EventArgs e)
        {
            // Create Object
            OpenFileDialog fopen = new OpenFileDialog();
            // Show ass
            fopen.Filter = "Excel(.xlsx)|*.xlsx";
            fopen.FilterIndex = 1;
            fopen.RestoreDirectory = true;
            fopen.Multiselect = false;
            fopen.Title = "Import File";
            fopen.ShowDialog();
            //xu ly
            if (fopen.FileName != "")
            {
                lblPath.Text = fopen.FileName;
                // Create Object
                Excel.Application app = new Excel.Application();
                //Open Excel
                Excel.Workbook wb = app.Workbooks.Open(fopen.FileName);
                try
                {
                    // mo sheet
                    Excel._Worksheet sheet = wb.Sheets[1];
                    Excel.Range range = sheet.UsedRange;
                    // doc du lieu
                    int rows = range.Rows.Count;
                    int cols = range.Columns.Count;
                    for (int c = 1; c <= cols; c++)
                    {
                        string columnname = range.Cells[1, c].value.ToString();
                        ColumnHeader col = new ColumnHeader();
                        col.Text = columnname;
                        col.Width = 120;
                        listProfile.Columns.Add(col);

                    }
                    for (int i = 2; i <= rows; i++)
                    {
                        ListViewItem item = new ListViewItem();
                        for (int j = 0; j <= cols; j++)
                        {
                            item.SubItems.Add(range.Cells[i, j].Value.ToString());
                            listProfile.Items.Add(item);
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Thong Bao", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    
                }



            }
            else
            {
            }
        }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59