• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

Can we import data from more than 1 excel sheets into the QTP at run time ?

Can we import data from more than 1 excel sheets into the QTP at run time ?
0
agcps
Asked:
agcps
  • 3
  • 3
1 Solution
 
ExcelGuideConsultantCommented:
I guess that would be possible, but I am not really sure what QTP is. I am for sure you can open up multiple excel files in vbs and then import them in a loop. If this would not work, then you could create one excel file from the multiple excel files and import that specific file.
0
 
agcpsAuthor Commented:
Yeah Thanks for the suggestion. Can u please help me in one more thing so that i can implement the idea you have suggested

1) I have to select the data in excel in a used range
       Like : If i have used the excel sheet from A1 to D10 the i should be able to select only the area A1 to D10

I dont want to use ExcelSheet.Range("A1:D10").select

As the data keeps on changing and i can keep the values static for selecting the range in excel.

Can u help me in finding the way to select the used range from an excel.


0
 
ExcelGuideConsultantCommented:
You should use something like:
Range("A1").CurrentRegion.Select

Good luck
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
agcpsAuthor Commented:
Thanks a lot for that syntax... thats working.


0
 
ExcelGuideConsultantCommented:
strange, first it is solved and then it is not? User doesnt even ask further....
0
 
agcpsAuthor Commented:
Hi,

The main question did not get solved so could not accept your previous solution.

On your request i have accepted the previous solution for my second query and closing this question.

Thanks for the help buddy.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now