Yes, when I check the length of the variable it game me 273,284 respectively Pls suggest me some alternate way Thanks
Thanks, Venkat Reddy Bandaru [email protected] + 91 9884524606 On 16-Jul-2013 6:45 AM, <[email protected]> wrote: > ** > Venkat, > > Are you sure it is returning 273 or 284? > > I guess it returns 255 characters. In Excel ADODB, if a cell contains more > than 255, then it should be defined in first row itself, I mean the first > row should have more than 255 for that particular cell. > > Excel is not a relational database, all data types will be defined from > first ten rows' data only. > > I hope this is helpful. > > > Sent on my BlackBerry® from Vodafone > ------------------------------ > *From: * Venkat Reddy Bandaru <[email protected]> > *Sender: * [email protected] > *Date: *Tue, 16 Jul 2013 01:09:17 +0530 > *To: *<[email protected]> > *ReplyTo: * [email protected] > *Subject: *Need urgent help on Excel data > > 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. > > > > -- > -- > 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.
