Hello all,
I'm having trouble to find a good way to make Export&Import option to my project for Excel without using the microsoft interop. Because when i use interop is slow and in task manager excel always work after this , and make not good use. And i found out that there were ClosedXML that is way better option.

Here is my code when form is loaded what fill up in datagridview

Code:
Using con As New OleDbConnection(ServerStatus)
            Using cmd As New OleDbCommand("SELECT * FROM Connectors order by ID", con)
                cmd.Connection = con
                cmd.CommandType = CommandType.Text
                Using sda As New OleDbDataAdapter(cmd)
                    Using dta As New DataTable()
                        sda.Fill(dta)
                        DataGridView1.DataSource = Nothing
                        'Set AutoGenerateColumns False
                        DataGridView1.AutoGenerateColumns = False
                        DataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill
                        'DataDisplay.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize
                        'DataDisplay.SelectionMode = DataGridViewSelectionMode.FullRowSelect
                        'DataDisplay.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells
                        DataGridView1.AllowUserToResizeColumns = False
                        DataGridView1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize
                        DataGridView1.AllowUserToResizeRows = False
                        'DataDisplay.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing
                        'DataDisplay.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells
                        DataGridView1.AutoResizeColumns()


                        'Set Columns Count
                        DataGridView1.ColumnCount = 6

                        'Add Columns
                        DataGridView1.Columns(0).Name = "ID"
                        DataGridView1.Columns(0).HeaderText = "ID"
                        DataGridView1.Columns(0).DataPropertyName = "ID"

                        DataGridView1.Columns(1).Name = "cName"
                        DataGridView1.Columns(1).HeaderText = "Name"
                        DataGridView1.Columns(1).DataPropertyName = "cName"

                        DataGridView1.Columns(2).Name = "cYazaki"
                        DataGridView1.Columns(2).HeaderText = "Yazaki"
                        DataGridView1.Columns(2).DataPropertyName = "cYazaki"

                        DataGridView1.Columns(3).Name = "cSupplier"
                        DataGridView1.Columns(3).HeaderText = "Supplier"
                        DataGridView1.Columns(3).DataPropertyName = "cSupplier"

                        DataGridView1.Columns(4).Name = "cStore"
                        DataGridView1.Columns(4).HeaderText = "Store"
                        DataGridView1.Columns(4).DataPropertyName = "cStore"

                        DataGridView1.Columns(5).Name = "cCount"
                        DataGridView1.Columns(5).HeaderText = "Count"
                        DataGridView1.Columns(5).DataPropertyName = "cCount"

                        'Add the Button Column.
                        Dim buttonColumn As DataGridViewButtonColumn = New DataGridViewButtonColumn()
                        buttonColumn.Name = "cDelete"
                        buttonColumn.HeaderText = "Delete"
                        buttonColumn.Text = "Delete"
                        buttonColumn.FlatStyle = FlatStyle.Flat
                        buttonColumn.CellTemplate.Style.BackColor = System.Drawing.Color.White
                        buttonColumn.UseColumnTextForButtonValue = True
                        DataGridView1.Columns.Insert(6, buttonColumn)
                        'End

                        'txtName.Text = dta.Rows(0).Item(1).ToString
                        'txtYazaki.Text = dta.Rows(0).Item(2).ToString
                        'txtSupp.Text = dta.Rows(0).Item(3).ToString
                        'txtStore.Text = dta.Rows(0).Item(4).ToString
                        'txtCount.Text = dta.Rows(0).Item(5).ToString
                        'txtID.Text = dta.Rows(0).Item(0).ToString

                        DataGridView1.DataSource = dta

                    End Using
                End Using
            End Using
        End Using
As you see here i have a custom button created inside the datagridview, but i do not want when make Export to be saved this also in the file (without it).
I have been looking for guide on internet but nowhere found anything that may help me, thats why i try to create topic here if someone can assist me to make it.
I hope someone can assist me with creating this.
Thanks