public static Dictionary <string, List <string> > MyWebSSOInputData(String path, String excelfileName) { Dictionary <string, List <string> > excelDataDict = new Dictionary <string, List <string> >(); XLSExcelDataAccess xlsfile = new XLSExcelDataAccess(path, excelfileName); xlsfile.DatasheetName = xlsfile.GetSheetName(0); int totalrow = xlsfile.GetLastRowNum(); for (int i = 1; i <= totalrow; i++) { List <string> list = new List <string>(); list.Add(xlsfile.GetValue(i, 0).Trim()); list.Add(xlsfile.GetValue(i, 1).Trim()); list.Add(xlsfile.GetValue(i, 2).Trim()); string TenantURL = xlsfile.GetValue(i, 3).Trim(); list.Add(TenantURL); list.Add(xlsfile.GetValue(i, 4).Trim()); list.Add(xlsfile.GetValue(i, 5).Trim()); list.Add(xlsfile.GetValue(i, 6).Trim()); if (!string.IsNullOrEmpty(TenantURL)) { excelDataDict.Add("User" + i, list); } } return(excelDataDict); }