Data Driven Testing in Selenium with C# -- Part 12 (Selenium automation with C#)

[@svssajja]

Gone through the complete playlist ..Very useful stuff Karthik ..!!!

[@nileshgupta4143]

Explanation is very neat and clean, After going thru all these videos..i am really passionate to learn more and more on selenium...thanks you so much for sharing these vidoes!!

[@ExecuteAutomation]

Nilesh Gupta Awesome !!! Glad you like it !!! Thanks, Karthik KK

[@testingtrail]

'AsDataSet() ' is not part of ExcelDataReader.Dataset so you may want to download that reference too. In regards 'IsFirstRowAsColumnNames' is not recognized anymore, instead you need to remove and change following line like this: DataSet result = excelReader.AsDataSet(new ExcelDataSetConfiguration() { ConfigureDataTable = (_) => new ExcelDataTableConfiguration() { UseHeaderRow = true } }); And again...great stuff here!!! :)

[@robertshuxley]

These videos are very helpful. please add more videos regarding Assertions or maybe different kinds of Test Runners. Many thanks!

[@tanujgyan787]

Thanks for making these. They are very useful!

[@ExecuteAutomation]

Tanuj Gyan Thanks mate!

[@asmitaborate5603]

Thank you so much for the great video ! Keep up the great work !

[@makiyatow3286]

Hello! The links are not available :( it says PAGE COULD NOT BE FOUND. I need this for my project please :(

[@abhishektiwari4120]

Great Video, Thank you!! I've have two questions: 1. How to not hard code the CSV file path 2. how to not hard code row number and automatically move to next row in every iteration. example: ExcelLib.ReadData(1, "Column_Name")

[@subrahmanyaadiga4178]

Hi Karthik, DDT with Excel CCUIT blog link is not accessible. Can you please share the active link if available Thanks Subrahmanya

[@prakharranjan5862]

Hi kartik, I am not able to access the DDT with Excel in CUIT with Custom Library (Part 1) and part(2) link from the Website, getting 404 error

[@umernadeem7608]

First of all your video series is amazing....I have just started automated testing and your videos saved my career.....The only problem I ma having is that I have dowloaded the same version of Excel reader that you ar using and my Excel Lib class has no errors.....BUT unfortunately I am unable to access this class in Program.CS plz help me with this problem

[@ArunYadav23]

@Kartik : I think the code and library you used is out-dated, Can you please post your new video with the latest version of Excel Data Reader ?

[@keerthi33]

can you please tell where the code is available?

[@maurvipathak7259]

I have added reference Excel Data Reader but unable to find "using Excel" and getting error IExcelDataReader does not contain IsFirstRowAsColumnName. What should I do here?

[@BogemiaRegent]

The same issue is on my side

[@r.suganya9036]

Hi Karthik, Thanks for the video. Could you please upload a video for to write test data into CSV file?

[@iBoyTrade]

Hi Karthik, I have an question, i have excel file which is stored username and password which is more than 3 records in excel and i want to validate the correct user than how will i do? Thanks in advance

[@jithesh6759]

Hi Kartik, Can u provide the steps to implement Json or csv

[@pavankumarpalla1656]

yes, your video really helpful for beginners, could you pls explain the reason for changing the method to STATIC and how to make further changes, when it need to be tested multiple records in xl i.e when we want the same test run for multiple user id and passwords and also when it requires run through PARALLEL mechanism , as in that case we can't use methods with STATIC.

[@TheMezanine]

Thank a lot for this great good tutorial

[@ExecuteAutomation]

Medoune Kane You are welcome mate!

[@himanshubagga6924]

Hi Kartik - Thank you for the wonderful videos. Also, I am getting an error where the query is giving null value. Could you please help on this ?

[@chiragbansod4003]

Could you add how to access multiple sheets and then read data in those sheets video ... I tried but I am facing issues

[@shilpamehta4113]

Hi , could you please share the code how we input the data from excel into hashmap in csharp -C#. I will be very thankful to you

[@per-olavchristiansen2638]

Ran into issue finding reference to System.Data in VS 2015. I could not install nuget package "System.Data.Common". Fix: change project target framework from 4.5 to 4.5.1. Needed a restart of VS, but then I could install the package.

[@ashirbadratha5135]

Hi All, One trouble, When i added multiple rows in the excel sheet and similarly updated the same in the calling class, i faced the problem of data being not available or resource not available. Can anyone please suggest possible measures to cater this. For Ex. I wanted to access the data from the 6th row to be accessed from the excel sheet. Thanks in Advance

[@ahmedsalahel-din1311]

Hello karthik, Thank you for the video. Notice, for me it threw an exception (Cannot find column 6) as I have 6 columns in my Excel sheet, so to get this work let's take a look at this piece of code: for (int col = 0; col < =table.Columns.Count; col++) { Datacollection dtTable = new Datacollection() { rowNumber = row, colName = table.Columns[col].ColumnName, colValue = table.Rows[row - 1][col].ToString() }; //Add all the details for each row dataCol.Add(dtTable); } here we have this line for (int col = 0; col < =table.Columns.Count; col++) you iterate from the value 0 to (

[@bishnuprasad7393]

Hey Karthik, Can you please let us know how we can perform DataProvider thing in Selenium C#. So that we can use same excel for all the Tests. Please reply.

[@saradalakshmi7443]

Hi, I went through this video. It is quite a useful one. Thank you so much for the share. May I know if this approach is the latest or do we have another latest approach to achieve the same functionality in Selenium webdriver C#. Appreciate if you can advise.

[@sohebk2272]

Hi Karthik. I m new to selenium C# and i have gone through your videos and they are of great help. I need to know about excel writer (write data to excel). Is there any solution to write data similar to ExcelDataReader

[@NguyenHoang-xl5hj]

Did you solve the problem?

[@savanamvenkateswarareddy4823]

hello Karthik, I am getting the following error...... System.NullReferenceException : Object reference not set to an instance of an object. what do I do to fix this out.

[@nenadtripunovic6723]

I have the same problem.Have you solved this?

[@DinkarGuptadud]

@kartik i am getting "System.ArgumentNullException : text cannot be null Parameter name: text " with same code

[@manjunathb.n7465]

Hi, How can we read multiple rows data from excel?

[@sriramnarayanan633]

Hi i need videos of how to iterate over excel and get different data for same test

[@hennymakaveli]

+Execute Automation (Karthik), When I try to run my own data-driven testing following your steps, I got this error message: Message: System.TypeInitializationException : The type initializer for 'Excel.ExcelReaderFactory' threw an exception. ----> System.NotImplementedException : This functionality is not implemented in the portable version of this assembly. You should reference the PCLStorage NuGet package from your main application project in order to reference the platform-specific implementation. Please what should I do to correct this thing? Your assistance is needed urgently please.

[@ExecuteAutomation]

Actually , there is an breaking change in Excel data reader, you can watch this video for fix kzbin.info/www/bejne/lZnCZWB-rdeAg8U

[@hennymakaveli]

Thanks so much, the new method works perfectly as expected but I had to be mindful of my column names (lower or upper case) to avoid "System.ArgumentNullException" error. Once again, THANK YOU.

[@ExecuteAutomation]

Awesome !

[@ankitrahaman593]

Thanks a lot for teaching so much.. But it I would be grateful to you if u can kindly teach keyword driven and hybrid framework also..

[@ExecuteAutomation]

ankit rahaman Its already here www.udemy.com/framework-development-with-cuit/

[@sparklingsta8061]

Hey karthik Thanks a lot for the video . Can you please explain how can i loop through the excel sheet . what i am trying to say is using 100 or so username and password within the same test without passing the variable row number and column name 100 times. Please if anyone can help me out for this given situation.

[@VIDYASAGARPOGIRI]

Hey can u provide the steps to implement Json or csv instead of excel , thanks

[@LivingSmallLivingMobile1]

found another bug in ExcelLib this row the

[@ExecuteAutomation]

Thanks again, but its addressed in the lecture already www.udemy.com/framework-development-with-selenium-csharp-advanced

[@RetroRampageArcade]

How to save data and then read the data

[@akanshaneekhra5342]

code from where you copied is not working Blogs

[@snehapothuri6659]

Great Videos. Can we see how to use TestNG DataProvider like data driven tests in c#?

[@UaiMTB]

+Sneha Pothuri Also I would like to know ...

[@ExecuteAutomation]

+RAMON VINÍCIUS There is no such provider here in C#, but you can write your own attribute though !!

[@mavlogs884]

ddl workin to bta do bhai find ni hora

[@pavanch12321]

Nice explanation. But i have a question here...... how can i parameterize my test if i have more than one row of data

[@ExecuteAutomation]

+Pavan Ch Thats when you should use Excel sheet

[@123lowp]

awesome!!!!!

[@abhinavsharma2763]

thanks!

[@khaledmonir3467]

I need to know how to select date from calender and i need to select the current date can anyone help me please

[@vedantkumar9854]

excelReader.IsFirstRowAsColumnNames = true; //Return as DataSet DataSet result = excelReader.AsDataSet(); These two lines are giving error after following all your steps.Can you please help me to solve this

[@LivingSmallLivingMobile1]

did you find a solution. I have same

[@LivingSmallLivingMobile1]

Seems you need additional nuget package and IsFirstRow.. is no longer supportedI added ExcelDataReader.DataSet nugget pachage to get rid of one error. Commented out excelReader.IsFirstRowAsColumnNames = true; Replaced line under // Return as DataSet with DataSet result = excelReader.AsDataSet(new ExcelDataSetConfiguration() { ConfigureDataTable = (tableReader) => new ExcelDataTableConfiguration() {// Gets or sets a value indicating whether to use a row from the // data as column names. UseHeaderRow = true, // Gets or sets a callback to determine which row is the header row. // Only called when UseHeaderRow = true. ReadHeaderRow = (rowReader) => { // F.ex skip the first row and use the 2nd row as column headers: // rowReader.Read(); } } }); tested and working

[@avijitsur]

Uninstall the latest ExcelDatareader package. Install version 2.1.2.3. Add using Excel; and it should solve your problem.

[@sahilx8635]

@@avijitsur- Thanks! Your advise resolved my issue.

[@vijaybhargav8710]

Thanks for the Video. I am getting this error when I am tying to access 2nd row .works fine for 1st row. Message: System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation. ----> System.ArgumentNullException : text cannot be null

[@iBoyTrade]

did you get any solution for "text cannot be null"

[@jcmontoya831]

I'm getting the same error: System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation. ----> System.ArgumentNullException : text cannot be null Parameter name: text

[@jcmontoya831]

Nevermind, had a typo.

[@AdixJFrhcp]

@@jcmontoya831 where? i have same problem but can't fix it.

[@Adam-hj1hc]

Is there a particular reason why .Click() will not work, but .Submit() will? I thought these were interchangeable... Excellent tutorials though! Thank you Karthik!

[@ExecuteAutomation]

Its based on the button type, if its submit type, then we need to use Submit() method.

[@Adam-hj1hc]

Ahh ok, understood. Thanks! :)

[@ZnSstr]

DataSet result = excelReader.AsDataSet(new ExcelDataSetConfiguration() { ConfigureDataTable = (_) => new ExcelDataTableConfiguration() { UseHeaderRow = true } }); That code is required instead of that boolean that is not found in the assembly. And add an aditional ExcelReader nuget package This row will throw an exception: for (int col = 0; col

[@veereshhadli1587]

pls write the automation script to read data from Excel file for only login feature from beginning

[@NguyenHoang-xl5hj]

Did you solve the problem?

[@BogemiaRegent]

Thank you for your tutorial. But everything is out dated. It will be nice if you make replacement of this tutorial which is very interesting.