private void ProgressBarBackground_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e)
{
for (int i = 1; i <= 100; i++)
{
Thread.Sleep(50);
ProgressBarBackground.ReportProgress(i);
}
}
private void lvExportBtn_Click(object sender, EventArgs e)
{
SaveFileDialog lvsaveFileDialog = new SaveFileDialog();
lvsaveFileDialog.Filter = "excel files (*.xlsx)|*.xlsx";
lvsaveFileDialog.FilterIndex = 2;
lvsaveFileDialog.RestoreDirectory = true;
lvsaveFileDialog.OverwritePrompt = true;
string lvfileName = "";
if (lvsaveFileDialog.ShowDialog() == DialogResult.OK)
{
ProgressBarBackground.WorkerReportsProgress = true;
ProgressBarBackground.RunWorkerAsync();
lvfileName = lvsaveFileDialog.FileName;
progressBar.Visible = true;
DataTable lvDataTable = new DataTable();
//Adding the Columns.
foreach (DataGridViewColumn column in lvDataResultGrid.Columns)
{
lvDataTable.Columns.Add(column.HeaderText, column.ValueType);
}
//Adding the Rows.
foreach (DataGridViewRow row in lvDataResultGrid.Rows)
{
lvDataTable.Rows.Add();
foreach (DataGridViewCell cell in row.Cells)
{
lvDataTable.Rows[lvDataTable.Rows.Count - 1][cell.ColumnIndex] = cell.Value.ToString();
}
}
using (XLWorkbook lvWorkbook = new XLWorkbook())
{
try
{
lvWorkbook.Worksheets.Add(lvDataTable, "Customers");
lvWorkbook.Worksheet(1).Columns().AdjustToContents();
lvWorkbook.SaveAs(lvfileName);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
