Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
datatable column exist
#3
Solved: 11 Years, 3 Months, 4 Weeks ago
got thru on error resume next



Code:
datatable.ImportSheet "C:\Documents and Settings\Administrator\Desktop\excelblank.xls",1,"Action1"
paramcount=datatable.GetSheet("Action1").GetParameterCount
msgbox paramcount


on error resume next
val=DataTable("Result","Action1")
If err.number<> 0 then

MsgBox "Parameter does not exist"
datatable.GetSheet("Action1").AddParameter "results","Added"
Else
Msgbox "Parameter exists"
End If


but for loop not able to proceed further....please help



Thanks Elango....got it



elango can you see the link below and please explain as what he is trying to do...

i also have a question regarding local sheet data and run time data and how to compare

https://www.learnqtp.com/forums/Thread-H...data-table



Elango,

Can you please go thru the link below and please tell me the difference and how we compare

https://www.learnqtp.com/forums/Thread-H...data-table

i imported and the data is in run time data...what is local data
Reply


Messages In This Thread
datatable column exist - by diya - 12-10-2012, 09:20 PM
RE: datatable column exist - by elango87 - 12-10-2012, 10:09 PM
RE: datatable column exist - by diya - 12-10-2012, 10:19 PM
RE: datatable column exist - by elango87 - 12-11-2012, 11:24 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Exist and Visible Are True When Objects Aren't There - Is there A Better Way? zunebuggy 3 3,146 04-24-2018, 02:12 PM
Last Post: Ankur
  Time Delay issue with Exist mv8167 11 24,814 06-19-2017, 02:56 PM
Last Post: grosorg
  [UFT] Get column name from SfwObject felino 0 3,023 12-02-2015, 04:07 PM
Last Post: felino
  AddParameter method does not add in first column of datatable alpha1 4 5,584 07-14-2015, 12:44 AM
Last Post: supputuri
  Performance Issues Using '.Exist' AndyBSG 2 3,501 12-12-2014, 03:24 PM
Last Post: AndyBSG

Forum Jump:


Users browsing this thread: 3 Guest(s)