Datagridview data is displayed in Excel

# Region datagridview data is displayed in Excel
/// <Summary>
/// Open Excel and export the data in the datagridview control to excel
/// </Summary>
/// <Param name = "dgv"> datagridview object </param>
/// <Param name = "isshowexcle"> whether to display the Excel page </param>
/// <Remarks>
/// Add com "Microsoft Excel 11.0 Object Library"
///
/// </Remarks>
/// <Returns> </returns>
Public bool datagridviewshowtoexcel (datagridview dgv, bool isshowexcle)
{
If (dgv. Rows. Count = 0)
Return false;
// Create an Excel Object
Excel. Application Excel = new excel. Application ();
Excel. application. workbooks. Add (true );
Excel. Visible = isshowexcle;
// Generate the field name
For (INT I = 0; I <dgv. columncount; I ++)
{
Excel. cells [1, I + 1] = dgv. Columns [I]. headertext;
}
// Fill in data
For (INT I = 0; I <dgv. rowcount-1; I ++)
{
For (Int J = 0; j <dgv. columncount; j ++)
{
If (dgv [J, I]. valuetype = typeof (string ))
{
Excel. cells [I + 2, J + 1] = "'" + dgv [J, I]. value. tostring ();
}
Else
{
Excel. cells [I + 2, J + 1] = dgv [J, I]. value. tostring ();
}
}
}
Return true;
}
# Endregion