How to get excel whole data in Datatable of ZAPTES

[Sarvam AriwalaParticipant]

Hellow Team,
I’m new in ZAPTEST,
I want to know that How to get excel data one bye one in zaptest datatable holds after execution of a script.

Is there any solution for the same?

Thanks.

[Sasha ZAPModerator]

Hello sarvam.ariwala,

Please refer to the following videos which explain how to use Excel in ZAPTEST:
https://www.zaptest.com/user-zone/product-training/zaptest/datatable-methods/method-datatableimportexcel
https://www.zaptest.com/user-zone/product-training/zaptest/datatable-methods/method-datatablevalue

Please check more “How To” videos in the following page:
https://www.zaptest.com/user-zone/product-training

Also please refer to the ZAPTEST Beginner Tutorial to get more understanding how to use ZAPTEST:

Tutorial

Hope this helps.

Thanks,
ZAPTEST Team

[Sarvam AriwalaParticipant]

Thank you for replying SashaY,

If I have one column as Number DataType and I want to use that column value like String DataType than “How can I convert/change that value in String DataType???”
Like – DataTable.Value(“Number”).

Curious to find Solution. :cheer:

Thanks.

[Sasha ZAPModerator]

Hello sarvam.ariwala,

Basically there are 2 options to change Datatable value:
– Do a right click on the Datatable cell -> Select Format -> Select Text.
– ZAPTEST uses some of the VBScript methods, for example you can use statement such as CStr(DataTable.Value(“Number”)) while the “Number is the Column’s name.

Thanks,
ZAPTEST Team

[Author]

Posts