CODEWITHSUNDEEP
c#.netlinqlinq-to-excel
Sike12
Sike12

Reputation: 1262

Converting LinqToExcel.RowNoHeader type into string

I have been using LinqToExcel Library Lately and i came across this issue.

here is the code 

  var excel = new ExcelQueryFactory(fileName);
  var dataList = (from c in excel.WorksheetRangeNoHeader("A1", "A4", "Test Worksheet")
                select c).ToList();

This dataList Collection Will have something like "Cat","Dog" ,"Fish" and "Goat"

Now All i want to do is assign Fish to a variable as an string by doing something like this

string temp=dataList[2];

However when i run the code i get the value of temp as "LinqToExcel.RowNoHeader". Anyone got idea on how to extract the actual value Fish into the variable temp.

Thanks in Advance

Upvotes: 1

Views: 1393

Answers (1)

Sike12
Sike12

Reputation: 1262

Cracked it ! I was referring to the whole row rather than the first cell of each row. Therefore i needed C[0] in order to get the items.

 var excel = new ExcelQueryFactory(fileName);
 var dataList = (from c in excel.WorksheetRangeNoHeader("A1", "A4", "Test Worksheet")
            select c[0]).ToList();

And the extraction code will be 

var temp=Convert.ToString(dataList[2]);

Upvotes: 1

Related Questions