Micro Focus QTP (UFT) Forums
How can I download an ExcelSheet from QC folder to QTP programmatically - 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: How can I download an ExcelSheet from QC folder to QTP programmatically (/Thread-How-can-I-download-an-ExcelSheet-from-QC-folder-to-QTP-programmatically)



How can I download an ExcelSheet from QC folder to QTP programmatically - chilloutsreeram - 03-11-2008

Hi

For Example there is a attachement in QC at "Subject\AutomationFramework\DataSheets\Excel.xls"

I want to download this attachement to local hard disk or to QTP.

Please let me know this with an Example

Thanks ,
Sreeram Pavan


RE: How can I download an ExcelSheet from QC folder to QTP programmatically - sreekanth - 03-11-2008

Hi sreeram,
first connect QTP to QC and then
use
Code:
datatable.importsheet "[QualityCenter]Subject\AutomationFramework\DataSheets\Excel.xls", "Sor","Global"
datatable.exportsheet "path","dest"



RE: How can I download an ExcelSheet from QC folder to QTP programmatically - chilloutsreeram - 03-11-2008

This doesnt work Sreekanth for latest version of QC. I tried this earlier


RE: How can I download an ExcelSheet from QC folder to QTP programmatically - sreekanth - 03-11-2008

can you just send us your version no of QC


RE: How can I download an ExcelSheet from QC folder to QTP programmatically - chilloutsreeram - 03-11-2008

I'm using QTP 9.2 and QC 9.0