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.

2
  • 69
    @Mike The "without requiring Excel to be installed" piece has nothing to do with being professional. It's about dependencies. The original text of the question was worded as: "Ideally, I would like open source so I don't have to add any third party dependencies to my code, and I would like to avoid using Excel directly to create the file (using OLE Automation.)" It's unfortunate the question was drastically simplified.
    – Tony
    Commented Apr 2, 2019 at 15:02
  • 10
    Assuming you were trying to do something sans library or external code, I can't speak for xls file, but for xlsx files, why not start by taking an existing one, renaming it to a zip file and exploring the contents? A little bit of reverse engineering will tell you quite a bit. There are several different xml files and rels files in the various folders and subfolders. Try exploring that and see if it's something you can replicate or see if you can find documentation on the various xml namespaces/schemas. Commented Aug 13, 2019 at 21:37