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

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

Hybrid View

  1. #1
    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.

  2. #2
    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.

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, 02: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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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