Home > Excel

Read data from CSV file using CSV Data set config in Jmeter

For reading data from CSV file, JMeter provides a config element called CSV Data Set Config. Below are the steps for configuring and executing CSV Data Set Config: Step 1: Go to File -> Click on New. User will see a new Test Plan as shown in below image: User needs to save

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-2.3.0.1.jar 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-2.3.0.1.jar 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-62b8ef1eccb1e147391271/]   Read and write functions from ExcelReadWrite class used. [crayon-62b8ef1eccb27436577005/] Code Execution Result: Changes in excel file before and after code execution.       Selenium Tutorial >>

This Article is TAGGED in , , . Read more

Protractor: How to read excel file in node.js? 

To read excel file in nodejs application we required exceljs to be installed. In protractor to read excel file, we need exceljs library along with node and protractor. Here are the steps to install exceljs library. Go to the folder location where you want to install exceljs library. Type npm install exceljs and press

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