I have an excel sheet that I want to use as a datatable, global sheet, but it has several pivots at the top of the excel sheet, so if I import as a DataTable the headers are messed up. It also includes a number of columns that are not needed. I can, however open the excel sheet and read the cell data in VBScript. Can you create and populate a QTP datatable on the fly - as the code loops through the spreadsheet? What would the cleanest approach be?