It will work with Excel object and fetching values from cell But as a excel database , it will fetch up to 255 characters. or you can fetch using DataTable as well
Regards, Ravi S On Wed, Jul 17, 2013 at 9:56 AM, Venkat Reddy Bandaru <[email protected] > wrote: > Hi All, > I have tried with Excel.application object, it worked fine > Thanks for all your help > > Thanks, > Venkat Reddy Bandaru > [email protected] > + 91 9884524606 > On 16-Jul-2013 8:31 AM, "Venkat Reddy Bandaru" <[email protected]> > wrote: > >> Ganesh,could you help me write code using array? >> I will try import and excel object concepts and let you know >> Thanks >> >> Thanks, >> Venkat Reddy Bandaru >> [email protected] >> + 91 9884524606 >> On 16-Jul-2013 1:21 AM, "Ganesh muralidharan" <[email protected]> >> wrote: >> >>> Not sure about the reasons but can you try with a Array variable and >>> check how much is getting stored. Also, importsheet didnot work? or storing >>> data into an access db didnot work? >>> >>> >>> On Mon, Jul 15, 2013 at 2:39 PM, Venkat Reddy Bandaru < >>> [email protected]> wrote: >>> >>>> Hi, >>>> I am trying to load data into variable using ADODB concept from excel >>>> sheet and i have more than 300 leters of text is stored in excel sheet >>>> cell and when i am trying to load to variable it is loading only half of >>>> the text (some time 273 characters, some time 284 characters) (Yellow >>>> colour marked data only loading), could any one please help me on this how >>>> to get it the full text into my script? >>>> I have tried with .xls and .xlsx as well, but not working... >>>> >>>> Any urgent help might be appreciated and Please find the attached error >>>> Thanks >>>> >>>> >>>> >>>> Thanks & Regards, >>>> Venkat Reddy Bandaru >>>> [email protected] >>>> +91.9884524606 >>>> >>>> -- >>>> -- >>>> 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 >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "QTP - HP Quick Test Professional - Automated Software Testing" >>>> group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>>> >>>> >>> >>> >>> >>> -- >>> Regards, >>> >>> >>> Ganesh Muralidharan >>> 'God Never Forgets' >>> >>> -- >>> -- >>> 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 >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "QTP - HP Quick Test Professional - Automated Software Testing" >>> group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> -- > -- > 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 > > --- > You received this message because you are subscribed to the Google Groups > "QTP - HP Quick Test Professional - Automated Software Testing" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- -- 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 --- You received this message because you are subscribed to the Google Groups "QTP - HP Quick Test Professional - Automated Software Testing" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
