Hi Karthik, I have a case where we are not saving the excel sheet, how to read data without saving it(the data is coming from a excel plugin) Thanks, Manju
Hi Kartik, what is the namespace for IsFirstRowAsColumnNames? I am using system. data and Exceldatareder namespaces but intelligence is not showing IsFirstRowAsColumnNames. My visual studio 2012 pro. does not bring namespace when i use control and ..
Hi Karthik, I do all the code as you do in the vid. However, when i debug, my stream is always null where yours has {System.IO.Filestream} at the 15:38 mark.
HI, can you please give me a help ? when i try IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); i got ExcelDataReader - ExcelReaderFactory.cs not found But dont make sense, i didi everything as you
+Ezequiel Matos Do not put breakpoint. Just continue. When you debug with step into , it is trying step into DLL. If you want to check the data you can put break point after this line check the value of dt. DataTable dt = ExcelUtil.ExcelToDataTable(…); Hope it helps.
Hi Can you please help , I am getting error here excelReader.IsFirstRowAsColumnNames = true; as I am unable to use reference Excel, it is showing only using ExcelDataReader; can you please help me in that?
i am facing a problem i have two Control ,one is file Uploading HTML control another one have one Text Box Control so if am use file type HTML Control to upload the file after uploading the file than i want to enter some data into TextBox than that textbox taking lot of time to identify .................................................... HOW to solve this problem ................................................................... SO HOW can identifying the control faster Note:-this problem is Happening using with file HTML COntrol Please Help Me Kartik
sir i am use [TestInitialize] and also i am ordered Test Technic in same application so at the Execution of the application before run ordered Test method first call [TestInitialize] attribute method so don't want to like that sir,sir i want to once time run [TestInitialize] attribute method for whole application and also all data is live
+AJAY KUMAR Yap, you are correct, everytime the Test Initialize will execute, you can overcome the problem by setting a property may be a flag to true for the first time execution and then next time while it checks the flag for true, it will not execute methods inside the TestInitialize. Hope it helps !!! Thanks,
Very less resources available for coded UI, your videos are the primary source of my knowledge all the time.
Dns Sandeep Thank you Sandeep, glad to hear that this video has helped you !
You are doing an amazing job by taking your precious time to make complex things easy to digest. Thank you
Souleymane Ali Thank you !
Hi Karthik,
I have a case where we are not saving the excel sheet, how to read data without saving it(the data is coming from a excel plugin)
Thanks,
Manju
Hi Kartik, what is the namespace for IsFirstRowAsColumnNames? I am using system. data and Exceldatareder namespaces but intelligence is not showing IsFirstRowAsColumnNames. My visual studio 2012 pro. does not bring namespace when i use control and ..
I have 2015 and got the same problem. I installed Exceldatareader v2.1.2.3 and then changed the reference to using Excel; and worked
Hi Karthik,
I do all the code as you do in the vid. However, when i debug, my stream is always null where yours has {System.IO.Filestream} at the 15:38 mark.
Did you tried adding the reference or nuget package ?
I had added the excel data reader and system.xml reference like you did in the vid. i see Excel and the ICSharpCode in the references list as well
You need to add ExcelDataReader nuget reference as well !!!
HI, can you please give me a help ?
when i try IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
i got
ExcelDataReader - ExcelReaderFactory.cs not found
But dont make sense, i didi everything as you
+Ezequiel Matos You need to install nuget package ExcelDataReader from Manage Nuget Package of References in your project !!!
Thanks,
Karthik KK
+Ezequiel Matos
Do not put breakpoint. Just continue. When you debug with step into , it is trying step into DLL.
If you want to check the data you can put break point after this line check the value of dt.
DataTable dt = ExcelUtil.ExcelToDataTable(…);
Hope it helps.
Hi Can you please help , I am getting error here
excelReader.IsFirstRowAsColumnNames = true; as I am unable to use reference Excel, it is showing only using ExcelDataReader; can you please help me in that?
hi, I am facing the same issue . how did you solved it? I would like to get your help. thanks!
why do you give links of the videos which you are asking to watch?
Any one use Drag and drop function in Automation Test using C#
i am facing a problem
i have two Control ,one is file Uploading HTML control another one have one Text Box Control
so if am use file type HTML Control to upload the file after uploading the file than i want to enter some data into TextBox than that textbox taking lot of time to identify
....................................................
HOW to solve this problem
...................................................................
SO HOW can identifying the control faster
Note:-this problem is Happening using with file HTML COntrol
Please Help Me Kartik
How to Use [TestInitialize] attribute wtin OrderList Method
+AJAY KUMAR You mean Ordered Test method ?
yes
sir i am use [TestInitialize] and also i am ordered Test Technic in same application so at the Execution of the application before run ordered Test method first call [TestInitialize] attribute method
so don't want to like that sir,sir i want to once time run [TestInitialize] attribute method for whole application and also all data is live
+AJAY KUMAR Yap, you are correct, everytime the Test Initialize will execute, you can overcome the problem by setting a property may be a flag to true for the first time execution and then next time while it checks the flag for true, it will not execute methods inside the TestInitialize.
Hope it helps !!!
Thanks,
than previews data is Live
i have some issue
if any one use can you reply me
Hi Kartik
hi kartik
please reply me
hi all
hi kartik
please
help me
+AJAY KUMAR Hi, please let me know whats the issue ?
Normally, i am used hard coded all successful message in Assert method
like- Assert.AreEqual("Forwarder information added successfully", successMsg, successMsg);
in Assert.AreEqual() method successfully message is hard coded so here got problem
if i am use Multi language application
so kartik how to use load the language resource file data depends on the language code to access the resources file