This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

how to read xls data from a given folder

Madan Peddagouni over 2 years ago

I need to validate the headers of a given xls file and also i dont have MS office installed on my machine . can any one help me . the code /in .net scripts with Silk test work bench

Tags:

read xls

Suggested Answer

0 Robert Murray over 2 years ago

Hi Madan Peddagouni

You could potentially try using an Active Data asset in Workbench. Simply created an Active Data asset and point it to your Excel document at which point you can use the ActiveData and ActiveDataRow classes in Silk Test Workbench to inspect the data. See the following help topic for more information.

https://www.microfocus.com/documentation/silk-test/210/en/silktestworkbench-help-en/SILKTEST-45A9FFE1-USINGACTIVEDATASCRIPTS-CON.html

If for any reason Active Data is not suitable, then you will likely need to use Vb.NET's native API's for connecting to Excel documents. For example, you should be able to find examples online for using ODBC via Vb.NET to query Excel documents.

Regards

Robert
Cancel
Vote Up 0 Vote Down

Cancel

Menu

Silk Test Discussions

Verified Answers

how to read xls data from a given folder

Tags:

Suggested Answer

Resources