Hi Robin, i use this code for export from datagrig Using workbook As XLWorkbook = New XLWorkbook workbook.Worksheets.Add(Me.DataGridView1.DataSource, "NameOfSheetInExcel") workbook.SaveAs(sfd.FileName) End Using
I am using Visual studio 2022 I have this Using workbook As XLWorkbook = New XLWorkbook workbook.Worksheets.Add(Me.DataGridView1.DataSource, "NameOfSheetInExcel") workbook.SaveAs(sfd.FileName) and it says workbook is not defined. and and it does not know what XLWorkbook is. It suggests to change to ExcelWorkbook but that still does not work. I do have Imports Excel Interloop. Please help
Hi I am seeing "Error" in Exception.. I am trying to save table.. ************************************************** Using sfd As SaveFileDialog = New SaveFileDialog() With {.Filter = "Excel Workbook|*.xlsx"} If sfd.ShowDialog() = DialogResult.OK Then Try Using table As XLWorkbook = New XLWorkbook() table.SaveAs(sfd.FileName) End Using MessageBox.Show("Successfully Exported") Catch ex As Exception MessageBox.Show("Error") End Try End If