static void Main(string[] args)
{
OfficeOpenXml.ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;
var options = new AssessmentOptions
{
Filename = @"E:\Users\Eric\Desktop\Juries\Theatre Juries New Student Fall 2019.xlsx",
CurrentSemester = null,
SheetName = "Sheet1",
StartColumn = "I",
LastColumn = "AP",
SkipColumns = new[] { "AH", "AI", "AJ" },
ValidateOnly = args.Contains("-v"),
NameMapSheetName = null
};
var index = args.IndexOf("-file");
if (index >= 0 && args.Length >= index + 2)
{
options.Filename = args[index + 1];
}
index = args.IndexOf("-semester");
if (index >= 0 && args.Length >= index + 2)
{
options.CurrentSemester = args[index + 1];
}
index = args.IndexOf("-sheet");
if (index >= 0 && args.Length >= index + 2)
{
options.SheetName = args[index + 1];
}
index = args.IndexOf("-start");
if (index >= 0 && args.Length >= index + 2)
{
options.StartColumn = args[index + 1];
}
index = args.IndexOf("-end");
if (index >= 0 && args.Length >= index + 2)
{
options.LastColumn = args[index + 1];
}
index = args.IndexOf("-skip");
if (index >= 0 && args.Length >= index + 2)
{
options.SkipColumns = args[index + 1].Split(',', StringSplitOptions.RemoveEmptyEntries);
}
index = args.IndexOf("-map");
if (index >= 0 && args.Length >= index + 2)
{
options.NameMapSheetName = args[index + 1];
}
var analyzer = new AssessmentAnalyzer(options);
analyzer.Execute();
Console.WriteLine("Finished.");
Console.ReadLine();
}
public AssessmentAnalyzer(AssessmentOptions options)
{
_options = options;
}
