jjpps/NeatExcel

Excel Reader Dll

NeatExcel

How To Write

Excel excel = new Excel();
DataTable table = new DataTable();
table.Columns.Add("Dosage", typeof(int));
table.Columns.Add("Drug", typeof(string));
table.Columns.Add("Patient", typeof(string));
table.Columns.Add("Date", typeof(DateTime));

// Here we add five DataRows.
table.Rows.Add(25, "Indocin", "David", DateTime.Now);
table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);
table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);
table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);
table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);

DataSet ds = new DataSet();
ds.Tables.Add(table);
excel.WriteXLSX(ds, $"{path}\\fileName.xlsx");

How To Read

Excel excel = new Excel();
var excelLoaded = excel.LoadXLS(path);
foreach (DataRow dr in excelLoaded.Tables[1].Rows)
{
   Console.WriteLine(dr["columnName"].ToString());
}