Thursday 14 March 2013

How to Create excel file in QTP

example -

Below code will create new excel file in QTP.





Set objExcel = CreateObject("Excel.Application")
                                                                                                                                            objExcel.Visible = True
Set Wb = objExcel.Workbooks.Add()
                                                                                                                                                Wb.worksheets(1).Cells(1,1).Value  = "Scenario Id"
                                                                                                                                                Wb.worksheets(1).Cells(1,2).Value  = "Secnario Name"
                                                                                                                                                Wb.worksheets(1).Columns(1).ColumnWidth  = 10
                                                                                                                                                Wb.worksheets(1).Columns(2).ColumnWidth  = 40
                                                                                                                                                Wb.worksheets(1).Columns(3).ColumnWidth  = 20
                                                                                                                                                Wb.worksheets(1).Columns(4).ColumnWidth  = 20

                                                                                                                                                                                                Wb.SaveAs "c:\ayx.xlsx"  ' save file in say "c:\ayx.xlsx"
                                                                                                                                                                                                Wb.close
                                                                                                                                                                                                objExcel.Quit
                                                                                                                                                                                                blnFlag = False

No comments:

Post a Comment

Please Leave your reply. We value your feedback and inputs

Best QTP Books

Everything About QTP

Hello Friends,
You can find QTP study material, Multiple choice questions (mcq), QTP question bank, QTP question papers, QTP notes, QTP questionnaire, scenario based QTP interview questions, QTP tutorial and QTP training on this site.

If you are a fresher or experienced QTP professional with (1/2/3/4) years of experience, this blog is just for you.