I would like to just insert a few rows within my excel file. I'm currently able to add text anywhere within the file but for some reason when I try and add extra lines it craps out. I'm going to dump some data and I have to be able to insert extra lines because below the data I already have text that I need to keep.
/***********************************************************************************************************/
Microsoft.Office.Interop.Excel.
Range m_objRange;Microsoft.Office.Interop.Excel.Range m_objSheet;
m_objRange = m_objSheet.get_Range("5:9", m_objOpt);
ERROR ON THIS ROW:
m_objRange.EntireRow.Insert(XlInsertShiftDirection.xlShiftDown, System.Type.Missing);
/***********************************************************************************************************/
ERROR:
System.Reflection.TargetParameterCountException was unhandled by user code
Message="Number of parameters specified does not match the expected number."
Source="mscorlib"
StackTrace:
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.Insert(Object Shift, Object CopyOrigin)
at QualityTracking.User.GenerateExcel.DumpToExcel(_Worksheet m_objSheet, Boolean dumpHeader) in C:\PDCApps\QualityTracking\QualityTracking\User\GenerateExcel.aspx.cs:line 174
at QualityTracking.User.GenerateExcel.btnExportToExcel_Click(Object sender, EventArgs e) in C:\PDCApps\QualityTracking\QualityTracking\User\GenerateExcel.aspx.cs:line 54
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)