public void GetSpecificRange()
{
MSExcel.Workbook wkBook = null;
MSExcel.Worksheet wkSheet = null;
using (RangeLoader loader = new RangeLoader())
{
string path = Path.GetDirectoryName(Assembly.GetCallingAssembly().Location);
wkBook = loader.OpenWorkbook(path + "\\Workbooks\\AttributeTestFile.xlsx");
wkSheet = loader.SelectWorksheet("Data");
MSExcel.Range range = loader.GetDataRange("A1:D2");
Assert.That(range != null, Is.True);
string cellValue = (string)(range.Cells[1, 1] as MSExcel.Range).Value;
Assert.That(cellValue.Contains("ID"));
}
wkBook.Close();
wkBook = null;
}
public static object LoadSampleFromRange([ExcelArgument(Description = "The range to be read in", Name = "Range")] object[,] data)
{
return(Run(() => RangeLoader.LoadSample(data)));
}
public static object LoadSampleFromRangeAsync([ExcelArgument(Description = "The range to be read in", Name = "Range")] object[,] data)
{
return(RunAsync(() => RangeLoader.LoadSample(data), "Lloyds.Async.Importer.LoadSampleFromRange"));
}
