+- 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: How to handle 2 datatables in QTP (/Thread-How-to-handle-2-datatables-in-QTP)
How to handle 2 datatables in QTP - Anu123 - 11-12-2010
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,
RE: How to handle 2 datatables in QTP - manishbhalshankar - 11-30-2010
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.
RE: How to handle 2 datatables in QTP - vinod123 - 11-11-2011
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