Forum Discussion

rraghvani's avatar
rraghvani
Champion Level 3
2 years ago

I see the code like this,

function environmentVar()
{
    envVar = aqEnvironmentVariable.GetEnvironmentVariable("USERPROFILE");
    envVarfolder = envVar + "\\DMData\\";
    if (!aqFileSystem.Exists(envVarfolder))
        aqFileSystem.CreateFolder(envVarfolder);
    else
        Log.Message("Folder Exists");

    if (!aqFileSystem.Exists(envVarfolder + "\\DMMobile")) 
    {
        Log.Error("Excel file doesn't exists");
        Runner.Stop();
    }
}

function getExcelData(filename)
{
    var excelFile = Excel.Open(envVarfolder + "\\DMMobile.xlsx");
    var excelSheet = excelFile.SheetByTitle(fileName);
    return excelSheet;
}

You create a folder called DMData in %userprofile%, if it does not exist. You then check if the folder DMMobile does not exist, and output "Excel file doesn't exists" - are you checking the folder or file?

 

Then you get the Excel file DDMobile.xlsx from folder %userprofile%\DMData - which will not exist, if you've created the folder.

 

I don't really understand what's going on. Why can't you just read the Excel file as normal!?

 

 

 

 

  • ḥari's avatar
    ḥari
    Frequent Contributor
    2 years ago

    In function environmentVar there I am checking envVarfolder+DMData folder not exists then it create that folder.

    DMMobile is a excel file name if that file not exists it throwing error as file not exists in DMData folder.

    Function getExcelData here filename as sheet name.

    Because I have lot of excel files and sheets also so if some one need to execute the script they need to copy the excel file in same location for that i am using userprofile. If any one need to execute the script they need to copy the excel files in userprofile DMData folder then only they can execute. 

     

    I think now you have a clear understanding on this code. Still not yet let me know