public void ThenICanReadExcelCellValuesOfDifferentFormat()
{
string cellValue = ExcelInteropHelper.ReadExcelCellText(1, 1);
Assert.AreEqual("A", cellValue);
// Using ColumnName
cellValue = ExcelInteropHelper.ReadExcelCellText(1, "A");
Assert.AreEqual("A", cellValue);
// Using blank ColumnName
cellValue = ExcelInteropHelper.ReadExcelCellText(1);
Assert.AreEqual("A", cellValue);
cellValue = ExcelInteropHelper.ReadExcelCellText(2, 1);
Assert.AreEqual("2.001", cellValue);
cellValue = ExcelInteropHelper.ReadExcelCellText(3, 1);
Assert.AreEqual("5", cellValue);
cellValue = ExcelInteropHelper.ReadExcelCellText(4, 1);
Assert.AreEqual("ABC", cellValue);
cellValue = ExcelInteropHelper.ReadExcelCellText(5, 1);
Assert.AreEqual("XYZ", cellValue);
// This is using formula
//cellValue = ExcelInteropHelper.ReadExcelCellText(6, 1);
//Assert.AreEqual("5", cellValue);
cellValue = ExcelInteropHelper.ReadExcelCellText(7, 1);
Assert.AreEqual("₹ 23.75", cellValue);
cellValue = ExcelInteropHelper.ReadExcelCellText(8, 1);
Assert.AreEqual("12/15/2019", cellValue);
cellValue = ExcelInteropHelper.ReadExcelCellText(9, 1);
Assert.AreEqual("December 15, 2019", cellValue);
cellValue = ExcelInteropHelper.ReadExcelCellText(10, 1);
Assert.AreEqual("8:52:48 AM", cellValue);
cellValue = ExcelInteropHelper.ReadExcelCellText(11, 1);
Assert.AreEqual("76.90%", cellValue);
cellValue = ExcelInteropHelper.ReadExcelCellText(12, 1);
Assert.AreEqual("", cellValue);
}