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


> > ---------------------------------------
> > 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
------------------------------------
Hello Anders
Ur Idea Works. Thanks for it.

But finally, I have to create .Xls file. So, can u pls suggest me how to convert or 'Save As' that particular .Txt file into .Xls file programmatically.

Regards
Bhandari

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