Please help me include another index to my current Array. I want to fetch the URL of my first excel sheet's hyper linked column text in every row.
I have the code already in place to fetch all the string values, I just want to inlcude the URL in another index of my array.
Please help me modify the below code as per the requirement.
Array[] MyValues = new Array[lastRow+1];
for (int index1 = 0; index1 <= lastRow; index1++)
{
MyValues[index1] = workSheet.get_Range("A" +
(index1+1).ToString(), result + (index1+1).ToString()).Cells.Value;
}
for (int i = 1; i <= lastColumnCount; i++)
{
if (!lstColumns.Any(l => l.Equals(Convert.ToString(MyValues[0].GetValue(1, i)))))
lstColumns.Add(Convert.ToString(MyValues[0].GetValue(1, i)));
}
Structure of my excel is somewhat like this.
|Incident No. |Description | Open Date |
|50002147 |Xyz | 02/02/1999 |
|50002145 |ZXC | 02/03/2000 |
All the incident numbers are hyperlinked.
