Example #1
0
        protected void Initialise(
            string specificationNamespace,
            string specificationName)
        {
            workbook = Workbook(specificationNamespace);

            worksheet = Worksheet(specificationName);
        }
Example #2
0
        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;
        }
Example #3
0
        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);
                }
            }
        }