Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

9
  • 6
    But you have to make sure that you dispose of everything manually, otherwise you will leak memory
    – MagicKat
    Commented Sep 29, 2008 at 22:40
  • 11
    @Ricky B: Also, in my experience with the interop is that it does use excel. Every time we used it, if Excel wasn't installed on the machine, we would get COM exceptions.
    – MagicKat
    Commented Sep 29, 2008 at 22:42
  • 12
    @Geoffrey: ah OK you are going to make me work for it :) --> support.microsoft.com/kb/257757 Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application... Commented Mar 11, 2010 at 17:49
  • 4
    I'm coming to this discussion after struggling more than a week on interop, and unless your needs are very simple, this is not gonna work. The support for formatting your spreadsheet is abysmal, which is arguably the reason for generating an .xls file and not just a flat .csv file. For example, have you tried outputting more than 911 characters in a cell, or have you tried setting the width of merged cells in a consistent manner? I have, and I can't tell you how much I hate this crap now... Do yourself a favor and go with one of the free libraries mentioned on this discussion.
    – md1337
    Commented Feb 3, 2011 at 18:52
  • 2
    He literally says he does not want to have to install office
    – JSON
    Commented Oct 21, 2020 at 18:58