How can I create an Excel Spreadsheet with C# without requiring Excel to be installed on the machine that’s running the code?
You can utilize a library called ExcelLibrary. It’s a complimentary, open source library published on Google Code
This seems a port of the PHP ExcelWriter that you discussed above. It will not compose to the new.xlsx format yet, but they are dealing with adding that functionality in.
It’s really basic, simple and little to utilize. Plus it has a DataSetHelper that lets you utilize DataSets and DataTables to quickly deal with Excel data.
ExcelLibrary appears to still only work for the older Excel format (. xls files), however might be including support in the future for newer 2007/2010 formats.
You can likewise utilize EPPlus, which works only for Excel 2007/2010 format files (. xlsx files).
There are a couple of recognized bugs with each library as noted in the comments. In all, EPPlus seems to be the finest option as time goes on. It seems to be more actively updated and recorded too.
EPPlus has support for Pivot Tables and ExcelLibrary might have some assistance (Pivot table issue in ExcelLibrary).
If XLSX is a should: ExcelPackage is a great start however died off when the designer quit working on it. ExML got from there and added a few functions. ExML isn’t a bad alternative, I’m still utilizing it in a couple of production websites.
An incredibly lightweight option might be to utilize HTML tables. Just develop body, head, and table tags in a file, and wait as a file with an.xls extension. There are Microsoft particular qualities that you can use to style the output, including solutions.
I realize that you might not be coding this in a web application, however here is an example of the composition of an Excel file through an HTML table. This method could be utilized if you were coding a console app, desktop app, or service.
An exceptionally light-weight alternative might be to utilize HTML tables. Just create head, body, and table tags in a file, and conserve it as a file with an.xls extension. There are Microsoft particular characteristics that you can use to design the output, consisting of solutions.
I realize that you might not be coding this in a web application, but here is an example of the composition of an Excel file by means of an HTML table. This strategy could be utilized if you were coding a console app, desktop app, or service.
OpenXML is also an excellent alternative that assists avoid installing MS Excel on Server.The Open XML SDK 2.0 offered by Microsoft simplifies the task of controling Open XML packages and the underlying Open XML schema elements within a plan. The Open XML Application Programs Interface (API) encapsulates numerous typical jobs that developers carry out on Open XML bundles.
The simplest and fastest way to create an Excel file from C# is to use the Open XML Performance Tool. The tool reverse engineers any Excel file into C# code.