I am trying to update excel sheet using a 2 dimensional array , getting an error Exception from HRESULT: 0x800A03EC.
I am using the below code to update excel sheet :
public static void WriteToExcel(Object[,] ObjDVLData2)
{
Excel.Application objApp;
Excel._Workbook objBook;
Excel.Workbooks objBooks;
Excel.Sheets objSheets;
Excel._Worksheet objSheet;
Excel.Range range;
objApp = (Excel.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");
objApp.Visible = true;
objBooks = objApp.Workbooks;
objBook = objBooks[1];
objBook.Unprotect();
objSheets = objBook.Worksheets;
objSheet = (Excel._Worksheet)objSheets.get_Item(4);
range = objSheet.get_Range("F14:F754");
range.set_Value(Missing.Value, ObjDVLData2);
}
error :
{"Exception from HRESULT: 0x800A03EC"}
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.set_Value(Object RangeValueDataType, Object value)
at UpdateExcel.WriteToExcel(Object[,] ObjDVLData2) in D:\Projects\Excel Addin\BDS\BDSAddin\ExcelUtilities\UpdateExcel.cs:line 31
at DVLData.getValue_DVL2(String data_source, String ENTITY_ID, String ENTITY_ID_TYPE, String AcctBasis_Conf, String AcctStand_DataStage, String scurrency, String PERIOD_NAME, String PERIOD_TYPE, String PERIOD_END_DATE, Range rMnemonics, String STATEMENT_TYPE) in D:\Projects\Excel Addin\BDS\BDSUtilities\BDSUtilities\DVLData.cs:line 114
What I have tried:
I have tried parsing through each cell to assign values after making sure that sheet is not protected. tried Range.Value and Range.Value2 to assign the array values.