Export Mutiple DataGridView to Multiple Sheets in an Excel File ...

[nassimnastaran]

Hi all ! I want o export 2 datagridview in 2 sheets of An Excel File . some code for one DataGridView is Here :

...
Microsoft.Office.Interop.Excel.Worksheet mySheetInputData = null;
try
{
mySheetInputData = (Microsoft.Office.Interop.Excel.Worksheet)ExWorkBookInputData.Sheets["Sheet1"];

mySheetInputData = (Microsoft.Office.Interop.Excel.Worksheet)ExWorkBookInputData.ActiveSheet;
mySheetInputData.Name = "First Sheet";

// storing header part in Excel
for (int i = 1; i < dgv.Columns.Count + 1; i++)
{
mySheetInputData.Cells[1, i + 1] = dgv.Columns[i - 1].HeaderText;
}
for (int j = 1; j < dgv.Rows.Count + 1; j++)
{
mySheetInputData.Cells[j + 1, 1] = dgv.Rows[j - 1].HeaderCell.Value.ToString();
}
// storing Each row and column value to excel sheet

for (int i = 0; i < dgv.Rows.Count; i++)
{
    for (int j = 0; j < dgv.Columns.Count; j++)
    {
        mySheetInputData.Cells\[i + 2, j + 2\] = dgv.Rows\[i\].Cells\[j\].Value.ToString();
    }
}
//save the application
string fileNameInputData = String.Empty;
SaveFileDlgInputData.Filter = "Excel Files (\*.xlsx)|\*.xlsx";
SaveFileDlgInputData.FilterIndex = 2;
SaveFileDlgInputData.RestoreDirectory = true;

if (SaveFileDlgInputData.ShowDialog() == DialogResult.OK)
{
    fileNameInputData = SaveFileDlgInputData.FileName;
    ExWorkBookInputData.SaveAs(fileNameInputData, Type.Missing, Type.Missing,
        Type.Missing, Type.Missing, Type.Missing,
        Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive,
        Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

}
else
    return;
    ...

thanks for any help