ITabularBook OpenWorkbook(Stream stream, string filename, ITabularLibrary excel)
{
var workbook = excel.OpenBook(stream);
workbook.Filename = filename;
return(workbook);
}
public ExcelTestOutputWriterBase(
ITabularLibrary excel,
ICodeNameToExcelNameConverter namer,
string excelFolder)
{
this.excel = excel ?? throw new ArgumentNullException(nameof(excel));
this.namer = namer ?? throw new ArgumentNullException(nameof(namer));
this.excelFolder = excelFolder ?? throw new ArgumentNullException(nameof(excelFolder));
}
public ExcelTestOutputWriter(
ITabularLibrary excel,
ICodeNameToExcelNameConverter namer,
string excelFolder)
: base(
excel,
namer,
excelFolder)
{
}
public ExcelUnRoundTrippableTestOutputWriter(
ITabularLibrary excel,
ICodeNameToExcelNameConverter namer,
string excelFolder,
IEnumerable <string> issuesPreventingRoundTrip)
: base(
excel,
namer,
excelFolder)
{
this.issuesPreventingRoundTrip = issuesPreventingRoundTrip;
}
public ExcelTestOutputWriterBase(ITabularLibrary excel, ICodeNameToExcelNameConverter namer)
{
if (excel == null)
{
throw new ArgumentNullException(nameof(excel));
}
if (namer == null)
{
throw new ArgumentNullException(nameof(namer));
}
_excel = excel;
_namer = namer;
}
public FileSystemGenerateCSharpFromExcel(
ILogger logger,
string projectRootFolder,
string projectRootNamespace,
string excelTestsFolderName,
IEnumerable <string> usings,
IEnumerable <string> assembliesUnderTest,
string assertionClassPrefix,
ITabularLibrary excel)
{
this.logger = logger;
this.projectRootFolder = projectRootFolder;
this.projectRootNamespace = projectRootNamespace;
this.excelTestsFolderName = excelTestsFolderName;
this.usings = usings;
this.assembliesUnderTest = assembliesUnderTest;
this.assertionClassPrefix = assertionClassPrefix;
this.excel = excel;
}
private static void OutputWorkbook(
string specificationFolder,
string projectRootNamespace,
IEnumerable <string> usings,
string assertionClassPrefix,
ITabularLibrary excel,
XElement compileItemGroupNode,
string excelFileName)
{
using (var workbookFile = GetExcelFileStream(excelFileName))
{
using (var workbook = excel.OpenBook(workbookFile))
{
var workBookName = Path.GetFileNameWithoutExtension(excelFileName);
for (int i = 0; i < workbook.NumberOfPages; i++)
{
if (IsTestSheet(workbook.GetPage(i)))
{
compileItemGroupNode.Add(MakeFileElement(compileItemGroupNode.Name.Namespace.NamespaceName, "Compile", OutputWorkSheet(specificationFolder, usings, assertionClassPrefix, workBookName, workbook.GetPage(i), projectRootNamespace)));
}
}
}
}
}
public static void Create(
string specificationFolder,
string specificationProject,
string projectRootNamespace,
IEnumerable <string> usings,
string assertionClassPrefix,
ITabularLibrary excel)
{
var projectFilePath = Path.Combine(specificationFolder, specificationProject);
var project = OpenProjectFile(projectFilePath);
var compileItemGroupNode = GetItemGroupForCompileNodes(project);
var excelItemGroupNode = GetItemGroupForExcelNodes(project);
string excelFolder = Path.Combine(specificationFolder, "ExcelTests");
foreach (var excelFileName in ListValidSpecificationSpreadsheets(excelFolder))
{
excelItemGroupNode.Add(MakeFileElement(project.Root.Name.Namespace.NamespaceName, "None", Path.Combine("ExcelTests", Path.GetFileName(excelFileName))));
OutputWorkbook(specificationFolder, projectRootNamespace, usings, assertionClassPrefix, excel, compileItemGroupNode, excelFileName);
}
SaveProjectFile(projectFilePath, project);
}
