about LinqToExcel read data to a ListBox RSS

• • Reply
  

  super123

  Member

  81 Points

  179 Posts

  about LinqToExcel read data to a ListBox

  Jul 20, 2012 05:33 PM|LINK

  Hey there,

  I am trying to read from Excel(only one Column), and convert it to a List<string> , then return to a view .

                  var excel = new ExcelQueryFactory(path);
                  var test = from c in excel.Worksheet()
                             select c;
                  List<string> EmailList = test.ToList();
              return View();

  path is the full path of my excel file, then I got a error can not convert from rows to List,how can I do it?

  In addition, how to map my Column as "EmailList" header.

  Thanks,T

  • Moved by ignatandrei on Jul 21, 2012 07:28 AM
• • Reply
  

  ignatandrei

  All-Star

  134521 Points

  21576 Posts

  Moderator

  MVP

  Re: about LinqToExcel read data to a ListBox

  Jul 21, 2012 07:28 AM|LINK

  super123

  then I got a error can not convert from rows to List,how can I do it?

  speak with the developer of ExcelQueryFactory

  My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools