I'm displaying table data into excel using excel function.
DataTable dtResult = GetValuesFromDB();
object[,] objResult = GetCommaSepratedValuesFromDataTable(dtResult)
return XlCall.Excel (XlCall.xlUDF,"Resize",objResult)
It's displaying data into excel cells with formulas applied for all the cells.
I want to edit the value of one of the column and then resubmit/update the data. But When I'm trying to edit the Cell, it's showing me a message as "You cannot change part of an array."
If I copy all the cell and do Paste Special with Values & then try to change the value, it works fine. But i don't want to do that exercise.