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.
