07-27-2010, 12:06 AM
Hi there,
I've been programming for over 5 years, but new to QTP (and thus vbscript).
I've got several Actions that execute their own scripts, however they both use a single excel spreadsheet where I use the "ImportSheet" method to bring it into the DataTable on the first action.
As it iterates through the Excel spreadsheet, I don't want it to continually reimport, so...
Two questions:
I've been programming for over 5 years, but new to QTP (and thus vbscript).
I've got several Actions that execute their own scripts, however they both use a single excel spreadsheet where I use the "ImportSheet" method to bring it into the DataTable on the first action.
As it iterates through the Excel spreadsheet, I don't want it to continually reimport, so...
Two questions:
- Will ImportSheet only import once if it already has it in the datatable?
- If not, is there a common way to only import it one time?