In your QTP test script, add the following line of code so that your test will import the spreadsheet as the global datatable. If you are using UFT then you can save it with a newer format like. If you are using QTP version 11 or before then you need to save it as an. Save your spreadsheet so you can access it from your test script.

Here you see a 'USER' column with a value 'jeanette' and a 'PASSWORD' column with a value 'mercury' Here you see a 'USER' column with a value 'jeanette'Įx. You can outdent your statements by selecting Edit > Format > Outdent or by deleting the space at the beginning of the statements.įor more details, see VBScript Reference.We are going to learn how to put values that we will use in our tests on a spreadsheet and then import that spreadsheet as the Global DataTable so that QTP can read in those values instead of using hardcoded values in the test script itself.įirst write the header for the column User and then put in the valueĮx. The text is indented according to the Tab spacing selected in the General pane of the Text Editor tab in the Options dialog box ( Tools > Options > Text Editor tab > General node). If you want to indent multiple lines, you can also select the text and press the Tab key. You can indent your statements by selecting the text and choosing Edit > Format > Indent. Use indentation to reflect the logical structure and nesting of your statements. You can remove the comments from a selected block or line of text by choosing Edit > Format > Uncomment. You can remove comments from your statements by deleting the apostrophe ('), either at the beginning of a separate line, or at the end of a statement. Each line in the block is preceded by an apostrophe. You can comment a selected block of text by choosing Edit > Format > Comment. You can add comments to your statements by adding an apostrophe ('), either at the beginning of a separate line, or at the end of a statement. For details, see Comments.Īdding Comments. This improves readability and makes your scripts easier to maintain and update. Use comments to explain sections of an action, a scripted component, or a function library.

When working with actions, scripted components, or function libraries in the Editor, it is important to follow accepted VBScript practices for comments and indentation. Relevant for: GUI actions, scripted GUI components, and function libraries

Format code in uft