23. Read values from Excel, Data Driven Testing: Selenium 2018 Tutorial using C# Visual Studio

This is the twenty third part of the Selenium 2018 version 3.11 tutorial using C# and Microsoft Visual Studio 2017. In this video, we are going to learn:
1. How to install the ExcelDataReader and ExcelDataReaderDataSet nuget package.
2. How to create a generic Excel Opertation class that can be used to multiple times for reading values.
3. How to get data from Excel 2016 worksheet. It works for all the Excel versions be it Excel 2010 or Excel 2013.
4. How to get the entire table inside Excel Worksheet as a DataSet.
5. How to get a particular value from Excel by providing the Row Number and Column Name.
6. How reading a value from an already opened Excel file can raise exception.
7. Deprecated ” excelReader.IsFirstRowAsColumnNames = true ” where the top row contains the Column names.
8. Solution for ” excelReader.IsFirstRowAsColumnNames = true ” after its deprecation.

Like, Share this video and Subscribe the channel for more.

Useful links:
Download Visual Studio from here:
SeleniumHQ :
NUnit :

Nguồn: https://kuherbal.com/

Xem thêm bài viết khác: https://kuherbal.com/category/cong-nghe


  1. I can't see the data set visualizer, my resultSet option is null

  2. giving me error on line
    DataSet resultset = excelreader.Asdataset(new excdat) //

    AsDataset is not showing in auto list

  3. Cou can duplicate lines by just clicking on them and hitting CTRL + D, just a little shortcut that'll make things a bit easier for you.

  4. 28:14 : Who is your God?

  5. Hi I have error in the Methode public static void PopulateInCollection(string filename);

  6. Great job "TheSpearman" , Thanks for well explainations of the course, looking forward to seeing more , I'll be more inclined to see how to implement the fluent wait , reading data from Excel , taking multiple screenshots for each test case and reporting using extent report all together , can you please make one video with all of them

Leave a Reply

Your email address will not be published. Required fields are marked *