C# Read Excel File - EOProlbems!

sooo simple and genius!!
explanations:
http://code.google.com/p/linqtoexcel/
http://code.google.com/p/linqtoexcel/wiki/UsingLinqToExcel
download:http://code.google.com/p/linqtoexcel/downloads/list
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 + "   ");
      Console.WriteLine();
}


Update:
another thing i've been told of by Yon1973
http://www.rssbus.com/kb/help/RXR1-A/pg_usage.rst
use it with ADO

Update 2:
another reader for xls and other
http://npoi.codeplex.com/

Comments

Popular posts from this blog

c# Service Play Sound with NAudio example by Moshe

JS/JQ simulate Enter event

SOLVED The item could not be indexed successfully because the item failed in the indexing subsystem