سلام
اول باید توو Refrence هاتون حتما Microsoft.Excel رو اضافه کنید
اینم کدش
privatevoid button1_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.
Application xlApp;
Microsoft.Office.Interop.Excel.
Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.
Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp =
new Microsoft.Office.Interop.Excel.Application();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Microsoft.Office.Interop.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++)
{
DataGridViewCell cell = dataGridView1[j, i];
xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
}
}
xlWorkBook.SaveAs(
"csharp.net-informations.xls", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(
true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet); releaseObject(xlWorkBook);
releaseObject(xlApp);
MessageBox.Show("Excel file created , you can find the file c:\\csharp.net-informations.xls");
}
privatevoid releaseObject(object obj)
{
try
{
System.Runtime.InteropServices.
Marshal.ReleaseComObject(obj);
obj =
null;
}
catch (Exception ex)
{
obj =
null;
MessageBox.Show("Exception Occured while releasing object " + ex.ToString());
}
finally
{
GC.Collect();
}
}
تبدیل به اکسل میکنه و در my Document ذخیره میشه