Printing cell A1 from an excel sheet named 'Sheet1' of the workbook 'ExcelWorkbook.xlsx' using Koogra in .NET

with.cs

/*
 * Must have refrences the dlls:
 *    Net.SourceForge.Koogra.dll (here: http://www.antoinedahan.com/blog/ReadingExcelFilesWithKoogra/Net.SourceForge.Koogra.dll)
 *    Ionic.Utils.Zip.dll (here: http://www.antoinedahan.com/blog/ReadingExcelFilesWithKoogra/Ionic.Utils.Zip.dll)
 */

using Koogra = Net.SourceForge.Koogra;

//Grab the workbook
Koogra.IWorkbook workbook = Koogra.WorkbookFactory.GetExcel2007Reader("ExcelWorkbook.xlsx");

//Grab the worksheet
Net.SourceForge.Koogra.IWorksheet worksheet = workbook.Worksheets.GetWorksheetByName("Sheet1");

//Write the contents of cell A1 (at row index 0 and cell index 0)
Console.Write((string)(worksheet.Rows.GetRow(0).GetCell(0).GetFormattedValue()));