Hi Mary, I think Used Range will give the only used Rows & Column Values. So you can use that..
Thanks & Regards Sedhu On Mon, Sep 2, 2013 at 7:35 PM, Ludmila Kosharny <[email protected]> wrote: > http://www.mrexcel.com/forum/excel-questions/5510-what-%22usedrange%22.html > > "UsedRange returns a rectangular range which goes from the upper left > populated cell in the spreadsheet, to the lower right populated cell." > > > Ludmila. > > > ------------------------------ > Date: Mon, 2 Sep 2013 18:52:51 +0530 > Subject: Re: How to ignore blank rows in datatable? > From: [email protected] > To: [email protected] > > > Hi, > > copy those two rows into another excel sheet, while paste don't select > entire workbook., select only entire two rows ans paste > > Thanks, > Kamesh. > On Mon, Sep 2, 2013 at 3:30 PM, Mary <[email protected]> wrote: > > Hi, > I have imported an excel sheet to the datatable. It has values only > in two rows. But when i used datatable.GetRowCount it shows 65536.. > So, it takes more time for the script execution. > > > > -- > -- > 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. > > > > > -- > -- Happy Testing > Kamesh. > + 91-9666199933 > http://qtp-vbscript-learners.blogspot.com/ > > -- > -- > 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.
