M_objexcel = new excel. Application ();
M_objexcel.visible = true;
Excel. Workbook m_objbook = m_objexcel.application.workbooks.add (filewrite );
M_objbook = m_objexcel.workbooks.add (missing. value );
Excel. worksheet m_objsheet = (Excel. worksheet) (m_objbook.worksheets [1]);
M_objrange = m_objsheet.get_range ("A5", type. Missing );
// Two-dimensional array for storing report data
Object [,] objdate = new object [rownum, 9];
.......................
.......................
M_objrange = m_objsheet.get_range ("A5", missing. value );
M_objrange = m_objrange.get_resize (rownum, 9 );
// Horizontal alignment-right alignment
M_objrange.horizontalalignment = excel. xlhalign. xlhalignright;
// Text format
M_objrange.numberformat = "@";
M_objrange.value2 = objdate;
// Save and cast execl Resources
M_objbook.saved = true;
M_objexcel.displayalerts = false;
M_objsheet. _ saves (filewrite, missing. Value, missing. value,
Missing. Value, missing. value );
M_objbook.close (false, missing. Value, missing. value );
If (m_objexcel! = NULL)
{
M_objexcel.workbooks.close ();
M_objexcel.quit ();
System. runtime. interopservices. Marshal. releasecomobject (m_objexcel );
System. gc. Collect ();
}
If (m_objsheet! = NULL)
{
System. runtime. interopservices. Marshal. releasecomobject (m_objsheet );
System. gc. Collect ();
}
GC. Collect ();
This write can pass the vs2008 Test