خرید بک لینک

Vote count: 0

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.

asked 27 secs ago

- - , .
.

برچسب: نویسنده: استخدام کار تاريخ: شنبه 26 تير 1395 ساعت: 16:18

صفحه بندی