I have created an excelsheet using interoperabilty.I need to add array in to the first position and all other column need to move
this is how i tried and not working.any way?
Excel.Range rng = xlWorkSheet.get_Range("A1", misValue); string[] result = File.ReadAllLines(path); rng.Value2 = result; rng.EntireColumn.Insert(Excel.XlInsertShiftDirection.xlShiftToRight, Excel.XlInsertFormatOrigin.xlFormatFromRightOrBelow);