Home > OOPS – Java

Java library for text file operations

To perform text file operation like Create File, Compare Text file, Replace words etc we have created jar which you can download Attached Zip File: TextUtility  After extracting zip file you will get jar file which contains below functionality which is extremely easy to use. Functions appendLine → Read Text File and append new

This Article is TAGGED in , , , , . Read more

MS SQL connection using JDBC in Selenium

To connect MS SQL database using jdbc driver in java, we need to download jdbc driver for MS SQL server. Refer below link to download MS SQL jdbc driver file.  Add external Jar file to project: Right click on project, Go to properties → Java Build Path → Click on Library tab  Add external

This Article is TAGGED in , . Read more

Java Apache POI: Read or Modify data in excel file

Read and write excel file in java Pre-requisite:Download latest apache poi library.  Add below mentions jar files in build path from downloaded compressed file. commons-codec-1.11.jar commons-logging-1.2.jar jaxb-api-2.3.0.jar junit-4.12.jar poi-excelant-4.0.0.jar poi-scratchpad-4.0.0.jar commons-collections4-4.2.jar commons-math3-3.6.1.jar jaxb-core- log4j-1.2.17.jar poi-ooxml-4.0.0.jar xmlbeans-3.0.1.jar commons-compress-1.18.jar curvesapi-1.05.jar jaxb-impl- poi-4.0.0.jar poi-ooxml-schemas-4.0.0.jar activation-1.1.1.jar   Class which contains read and write function. [crayon-62ba08410e6d6785011688/]   Read and write functions from ExcelReadWrite class used. [crayon-62ba08410e6db786320795/] Code Execution Result: Changes in excel file before and after code execution.       Selenium Tutorial >>

This Article is TAGGED in , , . Read more