Srinidhi ...good explanation ....am preparing for interview ...i actually liked urs clear explanation In this video ...please post more videos ...am expecting urs response for this comment
Hi Thank you so much well explained on excel operations I have one query that in the Excel sheet. how can we get list of duplicate name that are present in Excel sheet can you please share the test steps for that?
$ is used to steer a particular position. # is used for the number of occurrence. So if u write $3 then it will steer the 3rd row of the table. But say u have the name Peter 3 times in the table. And you want the third occurence then use #3. If you know the position use $. Otherwise go for #
Is it possible to loop through the excel data using TOSCA ?? I mean TOSCA should read the row 1 data in first iteration and then row 2 in 2nd iteration and so on ..
@@srinidhiarekal3483 Hi, have you done this kind of video? this must be really helpful if you can post a video to capture multiple rows and store in DB
I am getting this error "Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Element not found. (Exception from HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND))." Please help
Srinidhi ...good explanation ....am preparing for interview ...i actually liked urs clear explanation In this video ...please post more videos ...am expecting urs response for this comment
Thank you so much. All the best for your interview 😃
Hi, Thanks for sharing valid information, Do more real-time video's would useful for anyone..
Sure I will
Nicely explained Arekal - thank you!
Thank you.. Its been very well explained.
You saved my life very wonderfully explained and i completed my task.... Are you gonna share video how to use this buffer value in scripts now ?
Yes. Definitely. But it may take a while.
u know how to add total amount to a buffer from a table which have n rows?
You can use rowcount or column countfor that
Hi Thank you so much well explained on excel operations
I have one query that in the Excel sheet.
how can we get list of duplicate name that are present in Excel sheet can you please share the test steps for that?
Really helpful thanks..
Please Do make all the tosca automation from scratch it would help us in many ways.
Yes I hope I will 😀
Do more videos on Tosca automation
Sir please add some related videos about Tosca ui automation.
Is it mandatory to close the workbook after we used it? Because you have not added that step at last.
It's good to close.. as it would not disturb the process.
Thank you so much... I am facing a issue I will explain you pls response me
Is it possible to perform row by row comparison in excel without using excel 1:1 comparison module
You mean comparing the cells like A1 and B1 ?
Yes all the cell values in two different work sheet .
I got the answer how to do that
Hi, I have another question too. Kindly confirm, Can we pass 1000+ records from Excel File to API Request as input using Tosca at a time.
Yes you can.
@@srinidhiarekal3483 Can you please share a video for the same if possible
Can you please explain a bit clear about the difference between $ and # with an example.....!! Thanks..!! good work.
$ is used to steer a particular position.
# is used for the number of occurrence.
So if u write $3 then it will steer the 3rd row of the table. But say u have the name Peter 3 times in the table. And you want the third occurence then use #3.
If you know the position use $. Otherwise go for #
@@j_j8758 Thank you 🙂
Can you please share a video on how to use this buffer value in scripts further?
Yes I would
@@srinidhiarekal3483 Can you please provide the link of the video
If rows and columns are dynamic then how to define the range ? Could you please help
You can use "COUNT" to get the range.
Right
Is it possible to loop through the excel data using TOSCA ?? I mean TOSCA should read the row 1 data in first iteration and then row 2 in 2nd iteration and so on ..
Following this question as i also need this answer
Yes it is possible to loop the Excel data . You can perform this with rowcount actions
Hi.. please advise for me it’s not reading the first row. Error is “could not find row ‘#1’
Are you using the right file ?
Can you share a video for passing 1000+ records from Excel File to API Request as input using Tosca at a time
Yes... I would do it soon!
Try request and response api request once
@@srinidhiarekal3483 Hi, have you done this kind of video? this must be really helpful if you can post a video to capture multiple rows and store in DB
If row & column is dynamic how to get count in TOSCA
You can use ResultCount for verification.
@@srinidhiarekal3483 result count for defining range?
I am getting this error
"Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Element not found. (Exception from HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND))."
Please help
can you post your contact details.