Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: JaiPrakash Bhandari
  Where is JaiPrakash Bhandari?
 Hyderabad
 India
 JaiPrakash Bhandari
 Tags
Subject: RE: EXPORT TO XLS Command
Thread ID: 227969 Message ID: 228317 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Monday, May 18, 2009 9:54:33 AM         
   


> >
> > In addition to Frank's comments, use TYPE XL5, not TYPE XLS, which is the Excel 2.0 format.
> >
> > Tamar
> ---------------------------------------
> Thanks for ur valuable comment.
> But, I was looking for a solution which does not force me to open the Excel sheet & to delete/update the records. As b'coz, through an application I am generating several Excel sheets from a database based on various conditions. So, if I Opens & modify & then close the Sheets every time, the processing may be slow to the user.
> That's why I am looking for a technique, which tends to be little faster process.
>
> Regards
> Bhandari


COPY TO file.txt TYPE DELIMITED WITH TAB

There won't be any column headers in that format. The only tabular text format VFP makes with a column header line is COPY TO filename TYPE CSV.
Excel can open most types of tabular text files.

-Anders

ENTIRE THREAD

EXPORT TO XLS Command Posted by JaiPrakash Bhandari @ 5/14/2009 1:57:45 PM
RE: EXPORT TO XLS Command Posted by Frank Cazabon @ 5/14/2009 2:45:21 PM
RE: EXPORT TO XLS Command Posted by Tamar Granor @ 5/15/2009 10:34:32 PM
RE: EXPORT TO XLS Command Posted by JaiPrakash Bhandari @ 5/18/2009 9:35:15 AM
RE: EXPORT TO XLS Command Posted by Anders Altberg @ 5/18/2009 9:54:33 AM
RE: EXPORT TO XLS Command Posted by JaiPrakash Bhandari @ 5/18/2009 1:26:14 PM
RE: EXPORT TO XLS Command Posted by Anders Altberg @ 5/18/2009 5:30:16 PM
RE: EXPORT TO XLS Command Posted by JaiPrakash Bhandari @ 5/19/2009 10:40:07 AM
RE: EXPORT TO XLS Command Posted by Anders Altberg @ 5/19/2009 2:36:53 PM