convert a .xls text file to a Valid Excel file


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. 01-12-2006, 12:17 PM #1
    neela
    neela is offline Registered User
    Join Date
    Nov 2005
    Posts
    6

    convert a .xls text file to a Valid Excel file

    Is it possible for me to convert a .xls text file to a Valid Excel file through code?
    I am using a text file with .xls extension which is basically a download from SAP.It does look like an Excel file. But it is not a valid excel file and it would let me connect to it using a connection string only after I open it manually in Excel and do a "save as " .
    Can I do this process through code?
    thx
    Last edited by neela; 01-12-2006 at 12:51 PM.
    Reply With Quote Reply With Quote
  2. 01-12-2006, 07:42 PM #2
    Jason Bourne
    Jason Bourne is offline Registered User
    Join Date
    Jan 2006
    Posts
    11
    If you are using VB, you can add a reference to the Microsoft Excel COM object. In VB.NET, you can download the Office Primary Interop Assemblies.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Importing text file using schema.ini
    By Kevin in forum VB Classic
    Replies: 3
    Last Post: 12-05-2005, 07:25 PM
  2. very urgent how to read text from .doc file into text file
    By vimala in forum VB Classic
    Replies: 1
    Last Post: 03-23-2005, 12:18 AM
  3. Compare contents of a dir with golden text file
    By lodey in forum VB Classic
    Replies: 1
    Last Post: 03-16-2005, 06:45 PM
  4. Convert binary file to bitmap
    By Sara in forum VB Classic
    Replies: 2
    Last Post: 01-23-2001, 02:30 PM
  5. Re: How to load certain parts of a text file to an access database and get the size of each string w
    By deborah in forum authorevents.kurata
    Replies: 0
    Last Post: 04-17-2000, 02:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


Top DevX Stories

Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL