Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can you write a script for to insert array elements in an
excel A to Z columns only. if the number oe elements in the
array is greater than the number of columns (A to Z), come
to next row and proceed furthur. eah cell should contain
only one array value.



Can you write a script for to insert array elements in an excel A to Z columns only. if the number..

Answer / dwarapudi.mca

Dim arr
n=inputbox("Enter Array size")
ReDim arr(n)
For i=0 to n
arr(i)=cint("1")+Cint(i)
Next
Set Excl=CreateObject("Excel.Application")
Excl.workbooks.open("C:\Ex.xlsx")
Set ExclSht=Excl.Sheets.Item("Sheet1")
LOP=int((Ubound(arr)/cint(26))+1)
For i=0 to LOP
For j=0 to 25
If (j+k)<=ubound(arr) Then
ExclSht.cells(i+1,j+1)=arr(j+k)
else
Exit for
End If
Next
k=k+j
Next
Set ExclSht=nothing
Set Excl=nothing



Please let me know if u have simplest answer than this.

Thx

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More QTP Interview Questions

If a object property is changed in the application. where it should be updated in QTP... Pls anybody can give the answer.. Thanks in advance...

4 Answers   Navis,


How to set the function parameters as optional. Pls anybody can give the answer.. Thanks in advance...

2 Answers   Navis,


If there is a change in the object type eg: A button is changed as link, 1. How to edit that in the shared object repository. 2.What options are available to edit the object within shared object repository other than copy from loca; 3.What would be the effect of the change in Coded Scripts within QTP and Functions stored in .vbs file which are loaded and used in QTP

0 Answers   HP,


How to connect the real time application application with the QTP?

2 Answers  


The hybrid framework can be implemented for any application. Is it true?

0 Answers  


In QA Testing when do you use Loadrunner vs QTP? What are the main differences between those two tools? Explain the purpose with real world scenario examples...In advance thank you!!!

0 Answers  


Am going to QTP testing......but i dont know coding languages like (c,c++,java,etc)and am not having interest in coding .............can i choose testing tools like qtp to learn and get a job in software......please reply me

1 Answers  


What is QuickTest Automation Object Model? Where we can use AOM?

1 Answers  


Hi All, I need Code For how to export Pass\Fail status to excell sheet without using QC. Thanks Balaji

3 Answers  


actually how many hours per one day we will work on automation(qtp) in real time

1 Answers   Synechron,


What is dynamic arrays

1 Answers   Patni,


Hi Friends,I hav Just finished QTP course.Can any body suggest me which is the best place to go and post resume(Ban,Chennai,Pune,Mumbai,NCR,Kolkata).I mean how r calls in these cities,the best one?

3 Answers  


Categories