Tosca : How to fetch a value from an excel file and store it in a buffer value

How to Fetch a Value from an excel file and store it into a buffer value in Tricentis Tosca

[parthuit]

Hi, Thanks for sharing valid information, Do more real-time video's would useful for anyone..

[Abhilash_TC]

Thank you.. Its been very well explained.

[hameedibrahim]

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

[prachijoshiporwal]

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 ?

[pk]

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?

[shruthisadhana.a.t]

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.

[vijinambiyar]

Is it possible to perform row by row comparison in excel without using excel 1:1 comparison module

[jatindersingh]

Is it mandatory to close the workbook after we used it? Because you have not added that step at last.

[gtr]

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 ..

[anaveerb]

Thank you so much... I am facing a issue I will explain you pls response me

[JyotsnaJha-ui]

I am getting this error
"Unable to cast COM object of type to interface type This operation failed because the QueryInterface call on the COM component for the interface with IID failed due to the following error: Element not found. (Exception from HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND))."
Please help

[muhammadjunaidahmed]

Please Do make all the tosca automation from scratch it would help us in many ways.

[zyx]

Hi.. please advise for me it’s not reading the first row. Error is “could not find row ‘#1’

[gopirajukeerthi]

If rows and columns are dynamic then how to define the range ? Could you please help

[ArjunCreatives]

Sir please add some related videos about Tosca ui automation.

[shruthisadhana.a.t]

Can you share a video for passing 1000+ records from Excel File to API Request as input using Tosca at a time

[shruthisadhana.a.t]

Can you please share a video on how to use this buffer value in scripts further?

[babug]

If row & column is dynamic how to get count in TOSCA

[kranthimusuluru]

Can you please explain a bit clear about the difference between $ and # with an Thanks..!! good work.