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