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.

5
  • 9
    It's so ad hoc but it works (not to mention excel issuing a warning on opening) and is so simple, it deserves to have a place as a solution. Though only for showing that you can export an excel file :)) Commented Jan 4, 2012 at 7:23
  • 3
    This solution worked fine for me, just note you cannot use .xlsx extension
    – Jill
    Commented Mar 30, 2016 at 18:24
  • Some people at my organization can't open excel files made this way in Office 2010 and above. Don't know what the problem is, but I had to roll my own OpenXML implementation. (see Sogger's answer) Commented Dec 8, 2016 at 22:55
  • 1
    An even more lightweight version is to just create a csv file, which Windows associates with Excel. Commented May 6, 2021 at 21:35
  • Watch out for security warnings appearing to your user if you do this: "Warning, the content of the file doesn't match the extension". Particularly alarming when you're doing a download from your bank. I wouldn't rcommend pursuing the approach mentioned in this answer
    – Caius Jard
    Commented May 3, 2022 at 10:13