I don;t have knowledge on excel automation but franky speaking, why
not ....
simply retireve the rows count and columns count. if your prefered row
is inside the total rows count iterate though for column 1 to n and
put the values in an array or in a string in a deliminated form as you
wish. .... hardly 5 lines of code i.e.
set xl = createobject("excel.application")
set sht = xl.workbook("exel name").worksheet("sheet1")
totrows = sht.usedrange.rows.count
str = ""
if row <= totrows then
for c =1 to sht.usedrange.columns.count
str = str & "#" & sht.cells(row,c)
next
end if
i understand it's not the smartest of way but as you wish ....
cheers ..
On Apr 5, 2:11 pm, omkar <[email protected]> wrote:
> Hi guys,
>
> How can I retrieve data from a row(in excel sheet).
>
> I don't want to use "*cells*" object to get the data one by one.
>
> very Urgent !!
>
> Thanks in advance !
> --
> Thanks & Regards,
> Omkar Deekonda
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
