protected override void DoRun(IShellContext context)
{
string file = context.ResolveFile(context.Replace(File), ResolveFileMode.Input);
var model = ExcelModel.OpenFile(file);
model.DataFormat = DataFormat;
context.SetVariable(GetExcelVariableName(context), model);
}
public void ExcelFileAnalyseTest()
{
var model = ExcelModel.OpenFile("ExportImportFormats/Combined.xlsx");
Assert.True(new[] { "Album", "Artist" }.SequenceEqual(model.GetSheetNames()));
}