//Obtains Username and Password data for both banks
private void obtainUserData()
{
readData.currentSheet = 1;
readData.InitializeExcel(userDataPath);
//readData.obtainExcelDataTest();
//Obtain NET Data
NET_data NET_UserInfo = new NET_data();
readData.obtainDataNET(NET_UserInfo);
NET_User = NET_UserInfo.User;
NET_Pass = NET_UserInfo.Pass;
//Obtain DCU Data
DCU_data DCU_UserInfo = new DCU_data();
readData.obtainDataDCU(DCU_UserInfo);
DCU_User = DCU_UserInfo.User;
DCU_Pass = DCU_UserInfo.Pass;
//Obtain Email Sender Data
MailSender_data MailSender_UserInfo = new MailSender_data();
readData.obtainSendEmailData(MailSender_UserInfo);
senderEmailAddress = MailSender_UserInfo.senderMailAddress;
senderEmailPassword = MailSender_UserInfo.senderMailPassword;
//Cleanup excel app
readData.Cleanup();
}
public void obtainSendEmailData(MailSender_data UserInfo)
{
UserInfo.senderMailAddress = Sheet.Cells[2, 4].value();
UserInfo.senderMailPassword = Sheet.Cells[3, 4].value();
}