Зберегти БД в Excel

Додати бібліотеку з NuGet: ClosedXML  

WPF

            SqlConnection cn_connection = new SqlConnection(Properties.Settings.Default.cn);

            if (cn_connection.State != ConnectionState.Open)

            {

                cn_connection.Open();

            }

            DataTable table = new DataTable();

            string sqlExpression = "SELECT * FROM Table";

            SqlDataAdapter adapter = new SqlDataAdapter(sqlExpression, cn_connection);

            adapter.Fill(table);

            SaveFileDialog saveFileDialog = new SaveFileDialog();

            saveFileDialog.Filter = "Excel Workbook (*.xlsx)|*.xlsx";

            if (saveFileDialog.ShowDialog() == true)

            {

                using (XLWorkbook workbook = new XLWorkbook())

                {

                    workbook.Worksheets.Add(table, "Anketa");

                    workbook.SaveAs(saveFileDialog.FileName);

                }

                MessageBox.Show("Збережено " + saveFileDialog.FileName);

            }