Editing Excel files
Hi there, Was wondering if there was an easier way to edit the content of an excel file? More specifically, is there a way i can reference specific cells? I have a file that i use to validate tes...
Forum Discussion
Hi Brad,
You can work with Excel files via COM rather than via Excel's GUI. There's an example here:
http://www.sqaforums.com/showflat.php?Cat=0&Number=602068&an=0&page=0&gonew=1
>
import this excel file into test complete as a table or DB rather than using the DDT.ExcelDriver method?
<
You can use ADO to read Excel files. However, it is similar to DDT, so there's no reason to do this. Also, you can read them via COM (via the properties and methods used in the example I referred to above).
You can work with Excel files via COM rather than via Excel's GUI. There's an example here:
http://www.sqaforums.com/showflat.php?Cat=0&Number=602068&an=0&page=0&gonew=1
>
import this excel file into test complete as a table or DB rather than using the DDT.ExcelDriver method?
<
You can use ADO to read Excel files. However, it is similar to DDT, so there's no reason to do this. Also, you can read them via COM (via the properties and methods used in the example I referred to above).
