private void Exportbutton_Click(object sender, EventArgs e)
{
SaveFileDialog SaveFile = new SaveFileDialog();
SaveFile.InitialDirectory = @"C:\";
SaveFile.RestoreDirectory = true;
SaveFile.Title = "Browse Text Files";
SaveFile.DefaultExt = ".xls";
SaveFile.Filter = "Excel Spreadsheet(*.xls)|*.xls|All files (*.*)|*.*";
SaveFile.FilterIndex = 2;
SaveFile.RestoreDirectory = true;
string filename="SpareList";
if (SaveFile.ShowDialog() == DialogResult.OK)
{
filename = SaveFile.FileName;
Thread thread = new Thread(new ThreadStart(WorkThreadFunction));
thread.Start();
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Range oRange = null;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
int i = 0;
int j = 0;
for (i = 0; i <= dataGridView1.RowCount - 1; i++)
{
for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)
{
if (i == 0)
{
xlWorkSheet.Cells[i + 1, j + 1] = dataGridView1.Columns[j].HeaderText.ToString();
}
else {
DataGridViewCell cell = dataGridView1[j, i-1];
xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
}
}
}
xlWorkBook.SaveAs(filename, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
thread.Abort();
MessageBox.Show("Excel file created , you can find the file" + filename);
}
else {
MessageBox.Show("Enter Valid File Name");
}
}