public void TestGetRange()
{
MicrosoftExcel exInstance = new MicrosoftExcel();
Range myDate = exInstance.GetRangeFromActiveWorksheet("A5");
var rangeValue = myDate.Value;
Assert.AreEqual(10108, rangeValue);
exInstance.CloseInstance();
Marshal.FinalReleaseComObject(myDate);
}
public void TestOpenWorkbook()
{
MicrosoftExcel exInstance = new MicrosoftExcel(false);
exInstance.OpenWorkbook(@"S:\Market\ERCOT\FELPS\FELPS 2012 RFP\From Moffitt\MV90 Data_Floresville_2008.xlsx");
// Test opening multiple sheets at once
exInstance.OpenWorkbook(@"S:\Market\ERCOT\FELPS\FELPS 2012 RFP\From Moffitt\MV90 Data_Floresville_2009.xlsx");
exInstance.OpenWorkbook(@"S:\Market\ERCOT\FELPS\FELPS 2012 RFP\From Moffitt\MV90 Data_Floresville_2010.xlsx");
exInstance.CloseInstance();
}