We are looking to outsource a project to someone who can create Java packages (similiar to JExcel pckage available on the web ) which can be utilized to perform test automation on Oracle SMARTVIEWS [login to view URL] application. People with proven project experience may respond.
SMARTVIEWS is an excel based application with the connectivity to a database. Data from the database are extracted using SMARTVIEWS and the data is imported into the excel spreadsheet. User authentication is needed before the data is extracted from the database.
Following are required..
• Develop packages needed to automate excel sheets, ribbons and panels
• Packages must have classes and functions to do actions on objects in excel
• Any error/unforeseen windows that pop up, can be identified using the package developed - exception handling
• Methods to include in package(complete list will be provided later)
a. openExcel(String path)
b. closeExcel(String path)
c. selectTab(String tabName)
d. selectRibbonElement(String elementName)
e. selectPane(String paneTitle)
f. selectButton(String buttonText)
g. selectTextbox(Pane pane, String textboxTitle)
h. setText(Textbox textbox)
i. selectSheet(String sheetName)