public void GetDataFromKoogra()
{
using (FileStream stream = File.Open(Path.Combine(_path, file), FileMode.Open, FileAccess.Read))
{
var workBook = new Koogra.Excel2007.Workbook(stream);
var sheets = workBook.GetWorksheets();
foreach (var worksheet in sheets)
{
for (var r = worksheet.CellMap.FirstRow; r <= worksheet.CellMap.LastRow; ++r)
{
var row = worksheet.GetRow(r);
for (var c = worksheet.CellMap.FirstCol; c <= worksheet.CellMap.LastCol; ++c)
{
Console.WriteLine(row.GetCell(c).Value);
Console.WriteLine(row.GetCell(c).GetFormattedValue());
}
}
}
}
}
public void GetDataFromKoogra()
{
using (FileStream stream = File.Open(Path.Combine(_path, file), FileMode.Open, FileAccess.Read))
{
var workBook = new Koogra.Excel2007.Workbook(stream);
var sheets = workBook.GetWorksheets();
foreach (var worksheet in sheets)
{
for (var r = worksheet.CellMap.FirstRow; r <= worksheet.CellMap.LastRow; ++r)
{
var row = worksheet.GetRow(r);
for (var c = worksheet.CellMap.FirstCol; c <= worksheet.CellMap.LastCol; ++c)
{
Console.WriteLine(row.GetCell(c).Value);
Console.WriteLine(row.GetCell(c).GetFormattedValue());
}
}
}
}
}
