Hi,
In my excel i have few columns and Status column. First i will import
the excel to the datatable.
Script will do comparision between some columns and will write "Pass" in
the status column.
Then again i will export that datatable sheet to same excel sheet.
If i run the same script again, it is importing the same excel...Now it
returns 65536 rows.
So i think while exporting the datatable sheet - all the rows including
unused rows are exported to the excel sheet.
On Thursday, September 5, 2013 11:21:47 PM UTC+5:30, udayanem wrote:
>
> Hi Mary,
>
> How you are importing the Excel file to Datatable?
> Is it Datatable.import(fileName)?
>
> Can you please check what is printing if you have a statement like
> xlSheetObj.UsedRange.Rows.Count. If it returns 65536, then that is what
> Datatable.getrowcount also prints.
>
> Also create another sample xls file and enter few rows of data and check
> import and print getRowCount.
>
> It should return you only the rows of data.
>
> Thanks,
> Uday
> QTP \ UFT Videos <http://www.youtube.com/user/AnemUday/videos>
> QTP Videos Blog <http://qtpftvideos.blogspot.in>
>
> On Monday, 2 September 2013 15:30:47 UTC+5:30, Mary 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.
