public void IsWWTRangeTestNegative()
{
InteropExcel.Application excelApp = new InteropExcel.Application();
try
{
excelApp.Visible = false;
excelApp.Workbooks.Add();
InteropExcel.Workbook workbook = excelApp.ActiveWorkbook;
Name namedRange = workbook.Names.Add("TestNameOne", "A1", true);
bool expected = false;
bool actual = NameExtensions.IsWWTRange(namedRange);
Assert.AreEqual(expected, actual);
}
finally
{
excelApp.Close();
}
}
public void GetNamedRangeTest()
{
InteropExcel.Application excelApp = new InteropExcel.Application();
try
{
excelApp.Visible = false;
excelApp.Workbooks.Add();
InteropExcel.Workbook workbook = excelApp.ActiveWorkbook;
workbook.Names.Add("TestNameOne", "A1", false);
workbook.Names.Add("TestNameTwo", "A2", false);
Names namedCollection = workbook.Names;
string expected = "TestNameOne";
Name expectedName = workbook.Names.GetNamedRange("TestNameOne");
Name actualName;
actualName = NameExtensions.GetNamedRange(namedCollection, expected);
Assert.AreEqual(expectedName, actualName);
}
finally
{
excelApp.Close();
}
}
public static bool HasAnyArtist(this IHasArtist hasArtist, string artist)
{
return(NameExtensions.EqualsAny(hasArtist.AllArtists, artist));
}
