Thursday, May 24, 2012

C# Read Excel File - EOProlbems!

sooo simple and genius!!
most basic print:
var excel = new ExcelQueryFactory(@"F:\\MEMBER Book.xlsx");
var all = from c in excel.Worksheet()
               select c;
foreach (var row in all)
foreach (var cell in row)
            Console.Write(cell.Value + "   ");

another thing i've been told of by Yon1973
use it with ADO

Update 2:
another reader for xls and other

No comments:

Post a Comment