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")); }