How to handle 2 datatables in QTP

[Anu123]

Hi All,
In our project we maintain 2 DataTable for a QTP script.
Currently we create a temporary file, where each of the excel and there sheets read and pasted on temporary excel sheet.

This is a long procedure as each of the excel include nearly 26 sheets.

Can anyone suggest a better way of doing the same.

Thank you,

[manishbhalshankar]

Hi Anu,

What exactly do you want to do?
How many excel files you want to import?
If you are using only one sheet at a time out of 26, then import that perticular sheet to qtp and when you are done with it, import another.

[vinod123]

just directly import the the excel workbook which contain 26 sheets it automatically creates sheets in datatable but it takes long time just try by same method