Can we use Excel file in zap-fix?

[Barbara JacksonParticipant]

Hello Zap,

In QTP and UFT there is an option to importexport Excel file during runtime of a testing script, is there such option in Zap-fix Standalone version?
And if yes then how do we do it?

Thanks.

[Sasha ZAPModerator]

Hello BarbJack,

Thank-you for your question.

Basically in our latest Zap-fix Standalone versions there is already the following Excel file’s feature:
Datatable.ImportCSV(<path>) – Imports Datatable to CSV during runtime.
To read from a runtime Excel datatable:
x = Datatable.Value("Name of the Spreadsheet")
To write into a runtime Excel datatable:
Datatable.Value("Name of the Spreadsheet") = x

Our R&D Department works to implement the Export method as well.

Until the new method will be published in teh next build you can use the following VBScript code to importexportreadwrite into and Excel file:

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook = objExcel.Workbooks.Open("C:Test.xls")
Set objWorksheet = objWorkbook.Worksheets(1)
‘Write into Excel Worksheet
objWorksheet.Cells(1, 1).Value = "Number"
objWorkbook.Save()
‘Read from Excel Worksheet
value = objWorksheet.Cells(1,1).Value

objExcel.Quit
Set objWorksheet = Nothing
Set objWorkbook = Nothing
Set objExcel = Nothing

Please contact Zap for further help.

Thanks,
Sasha

[Author]

Posts