Create excel object vs ImportSheet
I'm a bit stumped. I've seen some really fancy footwork with ppl create that whole CreateObject(Excel.Sheet) type thing.
In what way or how perhaps is this more effective than using the ImportSheet facility in QTP?
We do data preparation into excel spreadsheets which is then just imported into QTP for comparison etc.
I get the feeling that i'm missing the bigger picture here.
Re: Create excel object vs ImportSheet
1. u can import only one file at a time, but in createobject u can, for more than one excel file.
2. the format of the excel file in headers are lost once u import and export, not the same while u create an object.
3. the mode of accessing the data is bit easy compare to import.
4. last but not the least, as i guess its more fast than import....
more to this, from others.....