public void ExcelToCodeVisitsTableComplexProperties()
{
var visitRecorder = new GivenTablePropertyVisitRecorder();
// The GivenTablePropertyVisitRecorder outputs strings for the various visits encountered,
var expected = new List <string>
{
"Table [{ PropertyName: ComplexProperty of, EndRow: 10, EndColumn: 5, IsRoundTrippable: False, SubClassName: ComplexClass, StartRow: 7, FullSubClassName: SpecificationSpecificComplexClass, PropertiesStartColumn: 4, PropertiesEndColumn: 5, Headers: [ {[4, { PropertyName: ComplexProperty1 of, EndRow: 10, EndColumn: 4, IsRoundTrippable: True }]},{[5, { PropertyName: ComplexProperty2 of, EndRow: 10, EndColumn: 5, IsRoundTrippable: True }]} ] },{ PropertyName: SimpleProperty of, EndRow: 7, EndColumn: 6, IsRoundTrippable: True }]",
"RowDeclaration 0",
"Cell(0, 0)",
"ComplexProperty, ComplexClass",
"Cell(0, 0)",
"ComplexProperty1, \"ComplexProperty1Value1\", String",
"CellFinalisation",
"Cell(0, 1)",
"ComplexProperty2, \"ComplexProperty2Value1\", String",
"CellFinalisation",
"ComplexPropertyFinalisation",
"CellFinalisation",
"Cell(0, 2)",
"SimpleProperty, \"SimplePropertyValue1\", String",
"CellFinalisation",
"RowFinalisation",
"RowDeclaration 1",
"Cell(1, 0)",
"ComplexProperty, ComplexClass",
"Cell(1, 0)",
"ComplexProperty1, \"ComplexProperty1Value2\", String",
"CellFinalisation",
"Cell(1, 1)",
"ComplexProperty2, \"ComplexProperty2Value2\", String",
"CellFinalisation",
"ComplexPropertyFinalisation",
"CellFinalisation",
"Cell(1, 2)",
"SimpleProperty, \"SimplePropertyValue2\", String",
"CellFinalisation",
"RowFinalisation",
"TableFinalisation",
};
var sheetConverter = new ExcelToCode.ExcelToCode(new CodeNameToExcelNameConverter(ANY_STRING));
sheetConverter.log.AddVisitor(visitRecorder);
using (var workbook = Workbook(@"TestExcelFiles\VisitGivenTableProperties.xlsx"))
{
sheetConverter.GenerateCSharpTestCode(NO_USINGS, workbook.GetPage(1), ANY_ROOT_NAMESPACE, ANY_WORKBOOKNAME);
CollectionAssert.AreEqual(expected, visitRecorder.RecordedTableProperties);
}
}
public void ExcelToCodeVisitsTableSimpleProperties()
{
var visitRecorder = new GivenTablePropertyVisitRecorder();
// The GivenTablePropertyVisitRecorder outputs strings for the various visits encountered,
// The values aren't exactly the same as the ones in the spreadsheet, as they are formatted by both
// ExcelToCode and CodeNameToExcelNameConverter in to the strings that are used in the code.
// This is a shame, it would be good to make this more loosely coupled, so that we could use a
// test formatter, and make the assertions exactly the same as the excel.
var expected = new List <string>
{
"Table [{ PropertyName: SimpleProperty1 of, EndRow: 7, EndColumn: 4, IsRoundTrippable: True },{ PropertyName: SimpleProperty2 of, EndRow: 7, EndColumn: 5, IsRoundTrippable: True }]",
"RowDeclaration 0",
"Cell(0, 0)",
"SimpleProperty1, \"SimpleProperty1Value1\", String",
"CellFinalisation",
"Cell(0, 1)",
"SimpleProperty2, \"SimpleProperty2Value1\", String",
"CellFinalisation",
"RowFinalisation",
"RowDeclaration 1",
"Cell(1, 0)",
"SimpleProperty1, \"SimpleProperty1Value2\", String",
"CellFinalisation",
"Cell(1, 1)",
"SimpleProperty2, \"SimpleProperty2Value2\", String",
"CellFinalisation",
"RowFinalisation",
"TableFinalisation",
};
var sheetConverter = new ExcelToCode.ExcelToCode(new CodeNameToExcelNameConverter(ANY_STRING));
sheetConverter.AddVisitor(visitRecorder);
using (var workbook = Workbook(@"TestExcelFiles\VisitGivenTableProperties.xlsx"))
{
sheetConverter.GenerateCSharpTestCode(NO_USINGS, workbook.GetPage(0), ANY_ROOT_NAMESPACE, ANY_WORKBOOKNAME);
CollectionAssert.AreEqual(expected, visitRecorder.RecordedTableProperties);
}
}