Load Data from Excel

[SweetyChowdhury]

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??

[manishbhalshankar]

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 "".

[Saket]

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.

[basanth27]

Sure We can help you with this sweety...Would you mind posting what you have tried so far ...??