You can also find sample scripts that demonstrate how to work with Excel sheets from TestComplete in the following How To section These variables store links to Excel files and provide read-only access to data rows stored in these. You can hide and unhide rows or columns in Excel 2010 when you don’t want part of the worksheet to be visible or when you don’t want certain data (such as salary information) to appear in printed reports - hidden rows and columns do not print. Excel 2003 and earlier: Choose Data, List, Create, and then click OK. Click Summarize with Pivot Table from the Design tab, and then click OK.
Excel 2007 and later: As shown in Figure 2, click on cell A1, choose Insert, Table, and then click OK. Figure 1: I’ll use this data set to explain why duplicate data may appear within a pivot table.
