Select an Excel

[Suneel]

Hi

I want to select an excel file from a folder using selenium. The file name includes the data stamp. But, only that file will be existing in the folder. How to do it please help with the code

[water]

Welcome to AutoIt and the forum,

You could use FileFindFirstFile and FileFindNextFile or _FileListToArray to get this information. Both support wildcards.

[Suneel]

Ok. Can you please help me with code or any reference links. I have to use it in selenium.

[water]

I know nothing about Selenium. But if you can give an example of a filename (including date/time stamp) this shouldn't be too hard.

[Suneel]

AssignmentsList_02172017.xlsx this will be file name

[water]

Something like this:

#include <Excel.au3>

Global $sDir = "C:\Temp\" ; Folder to search
Global $hSearch = FileFindFirstFile($sDir & "AssignmentsList*") ; file pattern to search for
If $hSearch = -1 Then Exit MsgBox(0, "Error", "Error: No files/directories matched the search pattern.")
Global $sFileName = FileFindNextFile($hSearch)
FileClose($hSearch)

Global $oExcel = _Excel_Open()
Global $aWorkbook = _Excel_BookOpen($oExcel, $sDir & $sFileName)

 

[Suneel]

Ok thank you. I will try and let you know. Thanks again

[Suneel]

If I execute that .au3 application, what is the output? how to select that file and take into string?

[water]

It searches directory "C:\temp\" for the first file that matches "AssignmentsList" and opens this file in Excel.
Did you change "C:\temp\" to the directory where your files reside?

[Suneel]

yes I have changed. But, I have to use that file for selenium script, not necessary to open. My script has to refer that file for further.

Here, only the issue is the exported file name will be date specific. In order to give the file name for every time, I want to run auto IT. Am I using correct tool, please advise me.

Sample Script:

String AssignFilePath = "D:\\Functional Automation Data\\Downloaded Excel Files\\AssignmentsList_02172017.xlsx";
        FileInputStream AssignFile = new FileInputStream(AssignFilePath);

        XSSFWorkbook AssignW1 = new XSSFWorkbook(AssignFile);
        XSSFSheet ADcccSheet = AssignW1.getSheet("Activity details");

[water]

Global $sDir = "C:\Temp\" ; Folder to search
Global $hSearch = FileFindFirstFile($sDir & "AssignmentsList*") ; file pattern to search for
If $hSearch = -1 Then Exit MsgBox(0, "Error", "Error: No files/directories matched the search pattern.")
Global $sFileName = $sDir & FileFindNextFile($hSearch)In my example script variable $sFileName

Variable $sFileName holds the path of the first file.