Micro Focus QTP (UFT) Forums
ImportSheet Once with Multiple Actions - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: ImportSheet Once with Multiple Actions (/Thread-ImportSheet-Once-with-Multiple-Actions)



ImportSheet Once with Multiple Actions - mailman - 07-27-2010

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:
  1. Will ImportSheet only import once if it already has it in the datatable?
  2. If not, is there a common way to only import it one time?
Big Grin