I have a excel with 10000 records, My requirement is to do following using LINQ. Please help me in this. Suggest only faster way (LINQ), for each data row will be very slow.
Q1 : I want to add a column name Header4 with value AAAAAA0123456 , BBBBBB1234567 etc. I want to achieve using LINQ.
Q2: I want convert Header2 values to Number (while reading from excel it is in String format). I want to achieve using LINQ.