Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tamar Granor
  Where is Tamar Granor?
 Elkins Park
 Pennsylvania - United States
 Tamar Granor
 To: vaishali maske
  Where is vaishali maske?
 mumbai
 India
 vaishali maske
 Tags
Subject: RE: getting excel range programatically
Thread ID: 288803 Message ID: 288868 # Views: 26 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Projects and Design
Date: Friday, December 24, 2010 10:43:55 PM         
   


> Hello Experts,
>
> I need to get Microsoft excel range in for loop on reccount of my cursor.I have cursor and I have its reccount.suppose its reccount is 30 then I have given for loop on those 15 records if my recno is 1 then I should get A,if recno is 2 then I should get B,and so on .If recno is 27 then I should get AA,If recno is 28 then I should get AB and so on.
>
> Is there any function available in vfp SP2 or I have to write code.If I have write to code then pls tell me how to do this?Pls tell me. Thanks in advance.

Why do you need this? Pretty much anything you want to automate in Excel can be done without every using column letters. You can refer to the columns by number, using the Cell reference.

Tamar

ENTIRE THREAD

getting excel range programatically Posted by vaishali maske @ 12/24/2010 8:37:57 AM
RE: getting excel range programatically Posted by Bhushan Sahni @ 12/24/2010 11:42:29 AM
RE: getting excel range programatically Posted by Suresh Adhikari @ 12/24/2010 1:51:51 PM
RE: getting excel range programatically Posted by Tamar Granor @ 12/24/2010 10:43:55 PM