+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: Load Data from Excel (/Thread-Load-Data-from-Excel)
Load Data from Excel - SweetyChowdhury - 04-23-2010
Hi All,
I have a doubt which goes like I need to read a excel file which contains the data for a QTP script.Now after i upload the data into the application(web application) ,I need to check the values reflecting in the application are same as provided in the excel sheet.(first case)
second case: for example : if there is a blank value in (row1,column2) which relates to a data feed for the application...it should throw an error message too.so i need to verify where the blank values too.
Can some one provide me the code in VB for it??
RE: Hi - manishbhalshankar - 04-26-2010
Hi Sweety,
Lode the excel sheet in datatable and then get the values from application and compare it to the values in datatable.
For second case just use If statement to check if the value in a perticular field is equal to "".
RE: Hi - Saket - 04-26-2010
Hi Sweety,
you should provide a relevant title for the thread, Putting Just a 'Hi' does not make sense at all. for more details refer Posting guidelines.
I have changed the Thread title for you, Please do take care of this in future.
RE: Load Data from Excel - basanth27 - 04-28-2010
Sure We can help you with this sweety...Would you mind posting what you have tried so far ...??