How to Trim in Hole xls sheet based on row count and column count?
Pls provide the code
Row count = 500
Column count = 50
Is there any technic to trim all the values in excel sheet please let me know?
what do you want to trim?
you can trim any variable in a loop like this...
for i = 0 to row
for x = 0 to col
var1 = Trim(var2)
it depends what your trying to do.
Why would you trim every cell in the whole spreadsheet?
If you are using values from a spreadsheet, simply trim them when you use them. It's faster this way.
Sure, you could open your spreadsheet, run a loop like gdole suggested to trim everything before you even start interacting with the application you are testing, but why?
Just start interacting/testing your application, and when you need a value from the spreadsheet, trim it right in the same line of code where you obtain/enter/use that value.
A big timer saver.
"The last 10% of any software project will take 90% of the budgeted time. The first 90% will take the other 90%"
You mean to say, how many rows and columns used in Excel?
If Yes, this is the solution:
Uday QTP / UFT Videos from my Youtube Channel QTP / UFT Videos from my Blog