private static IExcelImporter CreateExcelImporter()
{
var cellCoordinateParser = new CellCoordinateParser();
var cellValueParser = new CellValueParser();
var cellParser = new CellParser(cellCoordinateParser, cellValueParser);
var excelImporter = new ExcelImporter(cellParser);
return(excelImporter);
}
public void GetCellValueHandlesAllValues(ColumnValueType valueType)
{
Assert.DoesNotThrow(() =>
{
var cellType = GetCellType(valueType);
var cell = CreateCellMock(cellType);
CellValueParser.GetCellValue(cell, valueType);
});
}
private ExcelDataSet CreateDataSet()
{
var cellCoordinateParser = new CellCoordinateParser();
var cellValueParser = new CellValueParser();
var cellParser = new CellParser(cellCoordinateParser, cellValueParser);
var importer = new ExcelImporter(cellParser);
var dataSet = importer.GetCellValues(@"data.xlsx");
return(dataSet);
}
public void GetCellValueHandles_Double_Dot()
{
Assert.DoesNotThrow(() =>
{
var cell = CreateCellMock(CellType.String, "0.1");
var value = CellValueParser.GetCellValue(cell, ColumnValueType.Double);
Assert.True(value is double);
Assert.AreEqual(0.1d, (double)value);
});
}
public void TestMethod1()
{
var cellCoordinateParser = new CellCoordinateParser();
var cellValueParser = new CellValueParser();
var cellParser = new CellParser(cellCoordinateParser, cellValueParser);
var importer = new ExcelImporter(cellParser);
var result = importer.GetCellValues(@"data.xlsx");
Assert.AreEqual(15, result.TrialDataRows.Count);
Assert.AreEqual("Vpn", result.TrialDataRows[0].Values[0]);
}
public static string GetValue(this CellType cell, WorkbookPart workbookPart)
{
var parser = new CellValueParser(cell, workbookPart);
return(parser.GetValue());
}
