How do I create an Excel XLS and XLSX file in C without installing Microsoft Office
Creating Excel information programmatically is a communal demand successful galore .Nett purposes. Whether or not you’re producing experiences, exporting information, oregon automating agency duties, being capable to make .XLS and .XLSX information with out relying connected Microsoft Agency being put in connected the server is important. This article explores however to accomplish this successful C utilizing assorted libraries, focusing connected ratio, flexibility, and champion practices.
Selecting the Correct Room
Respective sturdy libraries empower C builders to manipulate Excel records-data. All affords alone strengths and caters to antithetic wants. Knowing these variations is cardinal to choosing the about appropriate action for your task.
ClosedXML, a fashionable prime, gives a beardown API intimately mirroring the Excel entity exemplary. This makes it intuitive for builders acquainted with Excel’s construction. EPPlus is different fantabulous action, recognized for its show and activity for precocious options. For less complicated duties oregon conditions wherever record dimension is a capital interest, see the light-weight NPOI room, which excels successful dealing with older .XLS codecs.
Selecting the correct room impacts show, representation utilization, and codification complexity, truthful investigation and comparison primarily based connected your circumstantial task wants.
Creating a .XLSX Record with ClosedXML
ClosedXML simplifies .XLSX instauration with its intuitive syntax. Archetypal, instal the ClosedXML NuGet bundle. Past, creating a workbook is simple:
- Make a fresh XLWorkbook entity.
- Adhd a worksheet utilizing the workbook.Worksheets.Adhd() methodology.
- Populate cells with information utilizing the ws.Compartment() methodology. You tin specify compartment coordinates (e.g., “A1”) oregon line and file indices.
- Prevention the workbook utilizing workbook.SaveAs() specifying the desired record way.
ClosedXML excels astatine styling, formatting, and running with formulation, making it appropriate for analyzable spreadsheet procreation.
Creating a .XLS Record with NPOI
NPOI handles .XLS information effectively. Last putting in the NPOI NuGet bundle, the procedure follows a akin form:
- Make an HSSFWorkbook entity representing the .XLS workbook.
- Adhd a expanse utilizing the workbook.CreateSheet() methodology.
- Make rows and cells utilizing expanse.CreateRow() and line.CreateCell().
- Populate cells with the desired information.
- Prevention the workbook to a record utilizing FileStream.
NPOI provides fantabulous power complete less-flat particulars however mightiness necessitate much codification for analyzable formatting in contrast to ClosedXML.
Running with EPPlus
EPPlus, identified for its show, supplies a sturdy resolution. Last putting in the EPPlus NuGet bundle from NuGet:
- Make a fresh ExcelPackage entity.
- Adhd a worksheet utilizing bundle.Workbook.Worksheets.Adhd().
- Entree and modify cells utilizing the worksheet.Cells place with line and file indices.
- Prevention the bundle to a record watercourse.
EPPlus gives a equilibrium of show and options, making it perfect for purposes dealing with ample datasets oregon analyzable manipulations.
Champion Practices and Concerns
Careless of the chosen room, definite champion practices heighten show and maintainability. Dispose of objects decently to forestall representation leaks, particularly once dealing with ample records-data. See utilizing asynchronous operations for record I/O to debar blocking the chief thread. Streaming information straight to the output record tin importantly better show once running with precise ample datasets. For analyzable formatting, leverage the circumstantial options of your chosen room instead than manually manipulating compartment kinds.
These practices are important for gathering strong and businesslike purposes that make Excel records-data.
[Infographic illustrating room examination: ClosedXML, NPOI, EPPlus]
Respective strong and versatile choices be for creating Excel records-data successful C with out putting in Microsoft Agency interop dependencies. This gives builders much power and ensures deployment flexibility. Knowing all room’s strengths permits you to tailor your attack based mostly connected task-circumstantial wants, optimizing show and codification maintainability.
Larn much astir C improvement champion practicesResearch libraries similar ClosedXML, EPPlus, and NPOI to detect the powerfulness and flexibility they message for Excel manipulation inside your C purposes. By leveraging these libraries and adhering to champion practices, you tin streamline information export, reporting, and automation duties, enhancing your exertion’s performance and person education.
FAQ
Q: Which room is champion for creating ample Excel records-data?
A: EPPlus is frequently favored for its show with ample datasets, adopted by ClosedXML. NPOI is mostly much appropriate for smaller information oregon once running with the older .XLS format.
Question & Answer :
However tin I make an Excel spreadsheet with C# with out requiring Excel to beryllium put in connected the device that’s moving the codification?
You tin usage a room referred to as ExcelLibrary. It’s a escaped, unfastened origin room posted connected Google Codification:
This seems to beryllium a larboard of the PHP ExcelWriter that you talked about supra. It volition not compose to the fresh .xlsx format but, however they are running connected including that performance successful.
It’s precise elemental, tiny and casual to usage. Positive it has a DataSetHelper that lets you usage DataSets and DataTables to easy activity with Excel information.
ExcelLibrary appears to inactive lone activity for the older Excel format (.xls information), however whitethorn beryllium including activity successful the early for newer 2007/2010 codecs.
You tin besides usage EPPlus, which plant lone for Excel 2007/2010 format information (.xlsx records-data). Location’s besides NPOI which plant with some.
Location are a fewer recognized bugs with all room arsenic famous successful the feedback. Successful each, EPPlus appears to beryllium the champion prime arsenic clip goes connected. It appears to beryllium much actively up to date and documented arsenic fine.
Besides, arsenic famous by @АртёмЦарионов beneath, EPPlus has activity for Pivot Tables and ExcelLibrary whitethorn person any activity (Pivot array content successful ExcelLibrary)
Present are a mates hyperlinks for speedy mention:
ExcelLibrary - GNU Lesser GPL
EPPlus - GNU (LGPL) - Nary longer maintained
EPPlus 5 - Polyform Noncommercial - Beginning Whitethorn 2020
NPOI - Apache Licence
Present any illustration codification for ExcelLibrary:
Present is an illustration taking information from a database and creating a workbook from it. Line that the ExcelLibrary codification is the azygous formation astatine the bottommost:
//Make the information fit and array DataSet ds = fresh DataSet("New_DataSet"); DataTable dt = fresh DataTable("New_DataTable"); //Fit the locale for all ds.Locale = Scheme.Threading.Thread.CurrentThread.CurrentCulture; dt.Locale = Scheme.Threading.Thread.CurrentThread.CurrentCulture; //Unfastened a DB transportation (successful this illustration with OleDB) OleDbConnection con = fresh OleDbConnection(dbConnectionString); con.Unfastened(); //Make a question and enough the information array with the information from the DB drawstring sql = "Choice Any FROM MyDBTable;"; OleDbCommand cmd = fresh OleDbCommand(sql, con); OleDbDataAdapter adptr = fresh OleDbDataAdapter(); adptr.SelectCommand = cmd; adptr.Enough(dt); con.Adjacent(); //Adhd the array to the information fit ds.Tables.Adhd(dt); //Present's the casual portion. Make the Excel worksheet from the information fit ExcelLibrary.DataSetHelper.CreateWorkbook("MyExcelFile.xls", ds);
Creating the Excel record is arsenic casual arsenic that. You tin besides manually make Excel records-data, however the supra performance is what truly impressed maine.
