public void SetUp() { var sheetConverter = new ExcelToCode.ExcelToCode(new CodeNameToExcelNameConverter(ANY_STRING)); workbook = Workbook(@"TestExcelFiles\Leading Trailing Spaces .xlsx"); generatedCode = sheetConverter.GenerateCSharpTestCode(NO_USINGS, workbook.GetPage(0), ANY_ROOT_NAMESPACE, ANY_WORKBOOKNAME).Code; }
ITabularPage Worksheet(string specificationName) { string specificationFriendlyName = namer.CodeSpecificationClassNameToExcelName(specificationName); if (workbook.GetPageNames().Contains(specificationFriendlyName)) { return(workbook.GetPage(specificationFriendlyName)); } else { var worksheet = workbook.AddPageBefore(0); worksheet.Name = specificationFriendlyName; return(worksheet); } }
void OutputWorkbook(ITabularBook workbook) { var workBookName = Path.GetFileNameWithoutExtension(workbook.Filename); for (int i = 0; i < workbook.NumberOfPages; i++) { var sheet = workbook.GetPage(i); if (IsTestSheet(sheet)) { var cSharpCode = OutputWorkSheet(workBookName, sheet); var projectRelativePath = Path.Combine(workBookName, sheet.Name + ".cs"); AddFile(cSharpCode, projectRelativePath); } } }