How to get excel whole data in Datatable of ZAPTES

• Author
  Posts
• January 1, 2019 at 4:22 pm #32171
  Sasha ZAP

  Moderator

  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

  January 1, 2019 at 4:30 pm #32172
  Sarvam Ariwala

  Participant

  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.

  January 1, 2019 at 4:51 pm #32173
  Sasha ZAP

  Moderator

  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