Deleting elements from array

Question

I am trying to delete a range of elements like first top 10 elements and the last element from an object array but i am getting the following error. Please suggest how to solve the problem. please note that there is a duplicity of data in my element's so using dictionary data type is not suitable for me

Also, please suggest how to add "₹" symbol in the end of the element.

Answer 1

@ankit goel , Welcome to Microsoft Q&A, you could try to convert object[,] to List<object[]> to remove some elements from list.

Here is a code example you could refer to.

               Console.OutputEncoding = System.Text.Encoding.Unicode;  
                var valueArray = (object[,])range1.get_Value(Excel.XlRangeValueDataType.xlRangeValueDefault);  
                List<object[]> list = new List<object[]>();  
                for (int i = 1; i <= valueArray.GetLength(0); i++)  
                {  
                    list.Add(new object[] { valueArray[i, 1], valueArray[i, 2] + "₹" });  
                }  
                list.RemoveAt(list.Count - 1);  
                list.RemoveRange(0, 10);  
                foreach (var item in list)  
                {  
                    Console.WriteLine(item[0] + "----" + item[1]);  
                }  
                wkb.Close();  
                excel.Quit();  

I removed first top 10 elements and the last element.

My excel and tested result:

Best Regards,
Jack

Answer 2

C# arrays do not have a slice(). You use the copy(). This requires allocating a new array the size you want, then copy from the old.

var a1 = new int[] {1,2,3,4,5};    
    
// remove first two elements (no bounds checking)    
var a2 = new int[a1.Length -2];    
Array.Copy(a1, 2, a2, 0, a2.Length);    
a1 = a2;    
    

you could also write an slice array extension:

public static class ArrayExtensions  
{  
	public static T[] Slice<T> (this T[] a, int start, int end)   
	{  
		var c = new T[end - start + 1];  
		Array.Copy(a, start, c, 0, c.Length);  
		return c;  
	}  
}