Read Excel using JDBC Request Test Step
Can you please let me know how i can use the database connections i.e jdbc for reading the excel data as a sql query
Forum Discussion
If you want to read excel data then use DataSource Step instead of DataBase Step.
- Yes I know we can use the Data Source but since we have limited licences we are using soapui open source and trying to use JDBC connection for reading excel as a SQL query.
you can use groovy script to read excel file if you are working with SoapUI that is free version.
Go through below post to have a look on how to read it via groovy
SoapUI-Open-Source read excel via groovy
