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 | |
---|---|---|---|---|---|
Oct 11, 2023 at 18:40 | comment | added | ninMonkey | If you are using Powershell or dotnet, ImportExcel is great 1] You do not need excel or office installed, and 2] no COM is required -- I use pwsh on Amazon linux lambdas to dynamically attach excel sheets for emails | |
Oct 21, 2020 at 18:58 | comment | added | JSON | He literally says he does not want to have to install office | |
Dec 3, 2019 at 7:13 | comment | added | Mark | Warning the Microsoft.Office.Interops library has a dependency on Excel being installed. Thus does not answer the user's question | |
Nov 19, 2019 at 14:32 | history | edited | TylerH | CC BY-SA 4.0 |
Updating to provide a bit more info so that users don't have to dig through 2300+ pages of documentation just to find the useful/relevant info.
|
Jul 18, 2018 at 6:07 | history | edited | Kolappan N | CC BY-SA 4.0 |
Updated URL to avoid redirect, improved format
|
May 13, 2013 at 15:11 | comment | added | pkuderov | I haven't changed Interop for EPPlus yet (but already on the half way) so I don't really know how much better life is with it, but dealing with Interop I got so much pain in very surprising cases nearly every time I needed something more complex than just create .xls/.xlsx file with simple table inside. And mentioned above 'twice-check-to-dispose-everything-magic' is one of that everyday pain. But yeah, it works, and most of the time it's enough. | |
Feb 3, 2011 at 18:52 | comment | added | md1337 | 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. | |
Dec 8, 2010 at 5:39 | history | made wiki | Post Made Community Wiki | ||
Mar 12, 2010 at 0:34 | history | edited | GEOCHET | CC BY-SA 2.5 |
added 93 characters in body; added 365 characters in body; added 12 characters in body
|
Mar 11, 2010 at 17:49 | comment | added | Jennifer Zouak | @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... | |
Mar 9, 2010 at 21:54 | comment | added | Jennifer Zouak | With the OLE, even with very careful disposals, it eventually leaks memory or crashes. This is argueably OK for attended applications/ workstations, but for servers is not recommended (MS has a KB stating this). For our server, we just reboot it nightly. Again, that works OK. | |
Sep 29, 2008 at 22:42 | comment | added | MagicKat | @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. | |
Sep 29, 2008 at 22:40 | comment | added | MagicKat | But you have to make sure that you dispose of everything manually, otherwise you will leak memory | |
Sep 29, 2008 at 22:34 | history | answered | GEOCHET | CC BY-SA 2.5 |