public Tuple <Excel.Excel.Application, Excel.Excel.Workbook, Excel.Excel.Worksheet, Excel.Excel.Worksheet, Excel.Excel.Worksheet> opendatasource()
{
xlApp = new Excel.Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(strExcelFilePath
, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheetFirst = (Excel.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
xlWorkSheetSecond = (Excel.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(2);
xlWorkSheetThird = (Excel.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(3);
return(Tuple.Create(xlApp, xlWorkBook, xlWorkSheetFirst, xlWorkSheetSecond, xlWorkSheetThird));
}
public void TC01()
{
CostCalculation cc = new CostCalculation();
cc.opendatasource();
Tuple <Excel.Excel.Application, Excel.Excel.Workbook, Excel.Excel.Worksheet,
Excel.Excel.Worksheet, Excel.Excel.Worksheet> getData = cc.opendatasource();
xlApp = getData.Item1;
xlWorkBook = getData.Item2;
xlWorkSheetFirst = getData.Item3;
xlWorkSheetSecond = getData.Item4;
xlWorkSheetThird = getData.Item5;
}
