Results 1 to 4 of 4

Thread: Write to existing Excel file, without having Excel installed?

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Sep 2009
    Posts
    20

    Write to existing Excel file, without having Excel installed?

    Hi there,

    I am looking for a function that will let me write my variables to an existing Excel file. I found one solution, but it only works on machines with Microsoft Office installed. Does anyone have a good idea to solve this?

    Thank you in advance

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: Write to existing Excel file, without having Excel installed?

    If you want to write to an XLS file then basically you must have Excel installed so that you can use COM Interop to control an Excel instance to do the work. If you want to write to an XLSX then you can use the Open XML SDK, which is a .NET library for writing to Office 2007 and later format files.

    http://www.microsoft.com/en-us/downl...s.aspx?id=5124
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

  3. #3
    Addicted Member
    Join Date
    Jan 2009
    Posts
    216

    Re: Write to existing Excel file, without having Excel installed?


  4. #4

    Thread Starter
    Junior Member
    Join Date
    Sep 2009
    Posts
    20

    Re: Write to existing Excel file, without having Excel installed?

    Hi Guys,

    Thank you very much for your answers.
    I can't use Com Interop, because of the need of Office, but I will take a look at the links #3 provided.

    Again, thank you very much

Tags for this Thread

Posting Permissions

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



Click Here to Expand Forum to Full Width