Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Benny Thomas
  Where is Benny Thomas?
 Jeddah
 Saudi Arabia
 Benny Thomas
 To: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 Tags
Subject: RE: Sorting Excel Worksheet rows
Thread ID: 288772 Message ID: 288809 # Views: 29 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Microsoft Office Automation
Date: Friday, December 24, 2010 9:15:07 AM         
   


> > Hi Excel experts,
> >
> > Can somebody tell me how to sort rows in a excel worksheet within VFP by office automation? I need to sort entire rows on colum 'B'. First 2 or 3 rows are column heading. I do not know the last row number, this varies for each worksheet. Total number of columns are fixed. Thanks in advance.
> >
> > Benny
>
> Hello Benny,
>
> If the contents of your sheets are just a simple translation of data to excel, then you can try to use ssToExcel class. The good thing about it is since it can transfer data straight from a cursor, then you can choose the initial sort order of a field there via ORDER BY clause before calling that class.
>
>
> http://www.junblogs.com/
> http://weblogs.foxite.com/sandstorm36/default.aspx
> http://www.coderisland.com/forum/viewforum.php?f=10

Hi Jun,

I am using your ssToExcel class else where. But in present problem, I have a excel file and want to sort and then import to vfp table. Any idea?

Benny

ENTIRE THREAD

Sorting Excel Worksheet rows Posted by Benny Thomas @ 12/23/2010 11:18:07 PM
RE: Sorting Excel Worksheet rows Posted by Mike Gagnon @ 12/23/2010 11:54:39 PM
RE: Sorting Excel Worksheet rows Posted by Jun Tangunan @ 12/24/2010 1:47:57 AM
RE: Sorting Excel Worksheet rows Posted by Benny Thomas @ 12/24/2010 9:15:07 AM
RE: Sorting Excel Worksheet rows Posted by Cetin Basoz @ 12/24/2010 4:48:37 PM
RE: Sorting Excel Worksheet rows Posted by Benny Thomas @ 12/25/2010 11:46:15 AM