Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: JaiPrakash Bhandari
  Where is JaiPrakash Bhandari?
 Hyderabad
 India
 JaiPrakash Bhandari
 Tags
Subject: RE: Save As 'Txt to Xls'
Thread ID: 228461 Message ID: 228486 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Active X Controls & OLE Automation
Date: Tuesday, May 19, 2009 10:30:20 AM         
   


> Hello!
> I have an TAB separated text file, and I want to Save it as .Xls by not opening the file.
> Is it possible programmatically through VFP ?
> This is required as I want to get the values on the Excel sheet.
>
Hi Bhandari -

What do you mean by not opening the file? Without that requirement, it would be easy, e.g.:
Create Cursor theCursor (...
Append From theTxtFile Type Delimited ...
Copy To theXlsFile Type XL5



hth
-Stefan

ENTIRE THREAD

Save As 'Txt to Xls' Posted by JaiPrakash Bhandari @ 5/19/2009 8:08:09 AM
RE: Save As 'Txt to Xls' Posted by Stefan Wuebbe @ 5/19/2009 10:30:20 AM
RE: Save As 'Txt to Xls' Posted by Yousfi Benameur @ 5/19/2009 10:47:47 AM
RE: Save As 'Txt to Xls' Posted by Cetin Basoz @ 5/19/2009 2:43:09 PM