There is a requirement in our project which is very important . Please let me know the solution at the earliest .

Query : Our's is a mainframe database (DB2). There are about 80 lac records. QTP has to read all those records and write them in Excel sheet. Once in excel sheet (Sheet1) the count reaches 50,000 , it should automatically start entering into sheet2 of that excel sheet.

How to go about doing this ? Ours is a Web + java application. Any function related to this will be useful at the earliest possiblity.