DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: convert a .xls text file to a Valid Excel file

  1. #1
    Join Date
    Nov 2005

    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?
    Last edited by neela; 01-12-2006 at 12:51 PM.

  2. #2
    Join Date
    Jan 2006
    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.

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. Replies: 1
    Last Post: 03-23-2005, 12:18 AM
  3. 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. Replies: 0
    Last Post: 04-17-2000, 01:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center