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