Selenium with C# 63 - Selenium Data Driven Testing using excel in MS Test and EPPlus library

[@AnkproTraining]

Thank you for watching. Cheers! would you mind hitting *_like_* button and *_subscribe_* to our channel! That will be awesome. We would be grateful to you. And also share this video in your circle via whatsapp, facebook and twitter.

[@javiontadeo7407]

A tip : you can watch movies on Flixzone. I've been using them for watching all kinds of movies recently.

[@fisherpeyton2824]

@Javion Tadeo yup, I've been watching on flixzone for since december myself =)

[@vivek777new]

Can you please suggest if the same code will work for NUnit? Or if what modifications are required to support Nunit?

[@sachinpawar420]

Build Is Succesful , but test case is failed says Object reference not set to an instance of an object. stackTrace d__4.MoveNext() line 82 Enumerable.Any[TSource](IEnumerable`1 source)

[@JesmineRivera]

Are you able to resolved this?

[@seeema46memon]

Did you resolved it ?

[@phaniraja9104]

hello, sir, your classes are very helpful. sir at this line [DynamicData(nameof(ReadExcel) ,DynamicDataSourceType.Method)] i am getting this error "dynamic data attribute does not contain a constructor that takes two arguments "

[@AnkproTraining]

You might have accidentally created a class file "DynamicData.cs", delete the file and try to include the namespace again. It should work. Thank you for watching this video and commenting. Cheers! would you mind hitting *_like_* button and *_subscribe_* to our channel! That will be awesome. We would be grateful to you. And also share this video in your circle via whatsapp, facebook and twitter. Link to subscribe the channel goo.gl/hFueBi

[@phaniraja9104]

@@AnkproTraining tq so much for answering my question that error has gone but another error pop up 😔.it's "A project with an output type of class cannot be started directly. In order to debug this project, add an executable project to this solution". I tried to put it as start up project but same error is coming whenever I use nunit .pls help how to resolve this issue.

[@AnkproTraining]

@@phaniraja9104 You have to run the test cases using test explorer. Test explorer is available in the test menu of the visual studio.

[@gamehacks2846]

Can you please create the same with Nunit?

[@AnkproTraining]

On the way with new selenium version. Thank you for watching this video. Don't forget to *_like , subscribe_* and hit that *_notification_* bell 🔔. And also share this video in your circle via *WhatsApp* , *Facebook* and *Twitter* . Link to subscribe the channel goo.gl/hFueBi

[@JavierLavandierTejada]

Could you pls share all the codes, include the past videos pls or if you can share the repository of github or some like that

[@giancabrera8274]

May I know the references?

[@AnkproTraining]

References section is available at kzbin.info/www/bejne/g4WWZWOvi9qko7M Thank you for watching this video and commenting. Cheers! would you mind hitting *_like_* button and *_subscribe_* to our channel! That will be awesome. We would be grateful to you. And also share this video in your circle via whatsapp, facebook and twitter. Link to subscribe the channel goo.gl/hFueBi This is a video series. To understand better follow from the Selenium with C# 63 Playlist link kzbin.info/www/bejne/Z6mslHxrm6xkrqM

[@giancabrera8274]

@@AnkproTraining I followed all references then whenever I run the test, it is always marked as "Not Run" with an exception in the output. An exception occurred while invoking executor 'executor://mstestadapter/v2': Could not load type 'Microsoft.VisualStudio.TestPlatform.ObjectModel.Utilities.TypesToLoadAttribute' from assembly 'Microsoft.VisualStudio.TestPlatform.ObjectModel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.

[@AnkproTraining]

@@giancabrera8274 Looks like MSTest version issue. Update the MSTest to latest version from the Nuget manager then build and see the test cases in test manager and run. Let me know if this solution worked.

[@lakshmanreddy8817]

for (int row = 2; row

[@vaishnavi-gupta]

Its because you have placed the second for loop above return statement. I don't know if you still need it but the below worked for me, for making columns dynamic as well. I don't know if its a 100% correct though: public static IEnumerable ReadExcel() { using (ExcelPackage package = new ExcelPackage(new FileInfo("DemoData.xlsx"))) { ExcelWorksheet worksheet = package.Workbook.Worksheets["Sheet1"]; int maxRows = worksheet.Dimension.End.Row; int maxCols = worksheet.Dimension.End.Column; Console.WriteLine(maxRows); for (int i = 2; i