Timeline for How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 2, 2020 at 17:12 | comment | added | Flydog57 | Don't forget to download the OpenXML Productivity Tool from the Microsoft site when you use this API. The way I work: Create a document with the content and format that I want in Excel and save it. Open it with the Tool. Scrape the code that I'm interested in from the reflected code in the tool, start from there. I also use the tool to verify and error check my output. When I want to put a new feature into my code, I use the tools "Diff" feature to figure out how the feature should be coded. It's really an essential OpenXML dev tool | |
| Jun 12, 2020 at 13:33 | comment | added | elnaz jangi | How interesting it was and your answer made me learn this. I have just entered the field of programming and such content is interesting to me. | |
| S Sep 25, 2019 at 17:05 | history | suggested | Dave | CC BY-SA 4.0 |
Replace broken Microsoft link with link to Github
|
| Sep 17, 2019 at 13:44 | review | Suggested edits | |||
| S Sep 25, 2019 at 17:05 | |||||
| Jul 18, 2018 at 5:57 | history | edited | Kolappan N | CC BY-SA 4.0 |
Updated URL to avoid redirect
|
| May 30, 2018 at 23:37 | comment | added | horeaper | Please note that Open XML SDK are now open source and hosted on github. Also you don't need to install the SDK, just fire-up nuget and DocumentFormat.OpenXml is all you need. It works with .net standard 1.3. | |
| Feb 17, 2017 at 17:54 | comment | added | Greg | I found Microsoft Open XML SDK's Open XML Writer to be great. Using the solutions above, (Especially Vincent Tom's sample (Poly Math)), it's easy to build a writer that streams through big sets of data, and writes records in a manner similiar and not too much more complex to what you'd do for CSV; but that you're instead writing xml. Open XML is the mindset that Microsoft considers it's new Office formats in. And you can always rename them from .xslx to .zip files if you feel like poking at their XML contents. | |
| Feb 17, 2017 at 17:51 | comment | added | Greg | A great sample of Microsoft Open XML SDK - Open XML Writer can be found at polymathprogrammer.com/2012/08/06/… Or see Stack Overflow solution stackoverflow.com/questions/11370672/… | |
| Dec 24, 2014 at 16:27 | comment | added | Tsahi Asher | The SDK models the XML into classes, so that each XML tag is mapped to a tag, and then you have to build the class hierarchy (each instance has a collection of child instances/tags) correctly. This means you have to know the XML structure of an Excel file, which is very complicated. It's much easier to use a wrapper such as EPPlus, mentioned above, which simplifies things. | |
| Jan 4, 2013 at 16:47 | comment | added | Snuffleupagus | Just a heads up that v2.5 is out and can be downloaded here. | |
| Jan 20, 2012 at 21:06 | history | edited | Sogger | CC BY-SA 3.0 |
Added some benefits and description of links
|
| Sep 20, 2011 at 13:03 | comment | added | Josh Brown | Important to note that the DLL for this is just over 5 MB and limited to Office 2007 formats. But certainly the easiest and fastest solution which works for me. | |
| S Aug 16, 2011 at 9:25 | history | answered | Pellared | CC BY-SA 3.0 | |
| S Aug 16, 2011 at 9:25 | history | made wiki | Post Made Community Wiki by Pellared |