26-08-19 10:01 AM
Answered! Go to Answer.
26-08-19 12:02 PM
string strSummaryFileName = "E:\\VElement\\filterinputs\\v2 Headcount Summary (LnD)_with Staff Movement.xlsx";//Get the variable from BP string strFunctionalTitleFileNm = "E:\\VElement\\filterinputs\\Functional Title.xlsx";//Get the variable from BP string strTitleSheetName = "M2 Only";//Get the variable from BP string strFileExtension = ".xlsx"; DataTable dtHeadCountSummary = ReadHeadCountSheet(strSummaryFileName, strFileExtension); DataTable dtFormatedSummary = ChangeTheHeaderNm(dtHeadCountSummary); DataTable dtFunctionalTitle = ReadFunctionalTitle(strFunctionalTitleFileNm, strTitleSheetName, strFileExtension); DataTable dtReportData = FilterHeadCountSheet(dtFormatedSummary, dtFunctionalTitle);
class Program { public void doExcelStuff() { string strSummaryFileName = "E:\\VElement\\filterinputs\\v2 Headcount Summary (LnD)_with Staff Movement.xlsx";//Get the variable from BP string strFunctionalTitleFileNm = "E:\\VElement\\filterinputs\\Functional Title.xlsx";//Get the variable from BP string strTitleSheetName = "M2 Only";//Get the variable from BP string strFileExtension = ".xlsx"; DataTable dtHeadCountSummary = ReadHeadCountSheet(strSummaryFileName, strFileExtension); DataTable dtFormatedSummary = ChangeTheHeaderNm(dtHeadCountSummary); DataTable dtFunctionalTitle = ReadFunctionalTitle(strFunctionalTitleFileNm, strTitleSheetName, strFileExtension); DataTable dtReportData = FilterHeadCountSheet(dtFormatedSummary, dtFunctionalTitle); } }
Program program = new Program(); program.doExcelStuff();
public void doExcelStuff() { string strSummaryFileName = "E:\\VElement\\filterinputs\\v2 Headcount Summary (LnD)_with Staff Movement.xlsx";//Get the variable from BP string strFunctionalTitleFileNm = "E:\\VElement\\filterinputs\\Functional Title.xlsx";//Get the variable from BP string strTitleSheetName = "M2 Only";//Get the variable from BP string strFileExtension = ".xlsx"; DataTable dtHeadCountSummary = ReadHeadCountSheet(strSummaryFileName, strFileExtension); DataTable dtFormatedSummary = ChangeTheHeaderNm(dtHeadCountSummary); DataTable dtFunctionalTitle = ReadFunctionalTitle(strFunctionalTitleFileNm, strTitleSheetName, strFileExtension); DataTable dtReportData = FilterHeadCountSheet(dtFormatedSummary, dtFunctionalTitle); }
doExcelStuff();
26-08-19 12:02 PM
string strSummaryFileName = "E:\\VElement\\filterinputs\\v2 Headcount Summary (LnD)_with Staff Movement.xlsx";//Get the variable from BP string strFunctionalTitleFileNm = "E:\\VElement\\filterinputs\\Functional Title.xlsx";//Get the variable from BP string strTitleSheetName = "M2 Only";//Get the variable from BP string strFileExtension = ".xlsx"; DataTable dtHeadCountSummary = ReadHeadCountSheet(strSummaryFileName, strFileExtension); DataTable dtFormatedSummary = ChangeTheHeaderNm(dtHeadCountSummary); DataTable dtFunctionalTitle = ReadFunctionalTitle(strFunctionalTitleFileNm, strTitleSheetName, strFileExtension); DataTable dtReportData = FilterHeadCountSheet(dtFormatedSummary, dtFunctionalTitle);
class Program { public void doExcelStuff() { string strSummaryFileName = "E:\\VElement\\filterinputs\\v2 Headcount Summary (LnD)_with Staff Movement.xlsx";//Get the variable from BP string strFunctionalTitleFileNm = "E:\\VElement\\filterinputs\\Functional Title.xlsx";//Get the variable from BP string strTitleSheetName = "M2 Only";//Get the variable from BP string strFileExtension = ".xlsx"; DataTable dtHeadCountSummary = ReadHeadCountSheet(strSummaryFileName, strFileExtension); DataTable dtFormatedSummary = ChangeTheHeaderNm(dtHeadCountSummary); DataTable dtFunctionalTitle = ReadFunctionalTitle(strFunctionalTitleFileNm, strTitleSheetName, strFileExtension); DataTable dtReportData = FilterHeadCountSheet(dtFormatedSummary, dtFunctionalTitle); } }
Program program = new Program(); program.doExcelStuff();
public void doExcelStuff() { string strSummaryFileName = "E:\\VElement\\filterinputs\\v2 Headcount Summary (LnD)_with Staff Movement.xlsx";//Get the variable from BP string strFunctionalTitleFileNm = "E:\\VElement\\filterinputs\\Functional Title.xlsx";//Get the variable from BP string strTitleSheetName = "M2 Only";//Get the variable from BP string strFileExtension = ".xlsx"; DataTable dtHeadCountSummary = ReadHeadCountSheet(strSummaryFileName, strFileExtension); DataTable dtFormatedSummary = ChangeTheHeaderNm(dtHeadCountSummary); DataTable dtFunctionalTitle = ReadFunctionalTitle(strFunctionalTitleFileNm, strTitleSheetName, strFileExtension); DataTable dtReportData = FilterHeadCountSheet(dtFormatedSummary, dtFunctionalTitle); }
doExcelStuff();