Die C# Excel-Bibliothek

Excel-Dateien ohne Interop lesen Alle 28-Codebeispiele anzeigen

using IronXL;
using System;
using System.Linq;

// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Select worksheet at index 0
WorkSheet workSheet = workBook.WorkSheets[0];

// Get any existing worksheet
WorkSheet firstSheet = workBook.DefaultWorkSheet;

// Select a cell and return the converted value
int cellValue = workSheet["A2"].IntValue;

// Read from ranges of cells elegantly.
foreach (var cell in workSheet["A2:A10"])
{
    Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
}

// Calculate aggregate values such as Min, Max and Sum
decimal sum = workSheet["A2:A10"].Sum();

// Linq compatible
decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);

Install-Package IronXL.Excel

Excel-Arbeitsblätter Alle 28-Codebeispiele anzeigen

using IronXL;

// Create new Excel spreadsheet
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);

// Create worksheets (workSheet1, workSheet2, workSheet3)
WorkSheet workSheet1 = workBook.CreateWorkSheet("workSheet1");
WorkSheet workSheet2 = workBook.CreateWorkSheet("workSheet2");
WorkSheet workSheet3 = workBook.CreateWorkSheet("workSheet3");

// Set worksheet position (workSheet2, workSheet1, workSheet3)
workBook.SetSheetPosition("workSheet2", 0);

// Set active for workSheet3
workBook.SetActiveTab(2);

// Remove workSheet1
workBook.RemoveWorkSheet(1);

workBook.SaveAs("manageWorkSheet.xlsx");

Install-Package IronXL.Excel

Excel-Dateien erstellen Alle 28-Codebeispiele anzeigen

using IronXL;

// Create new Excel WorkBook document
WorkBook workBook = WorkBook.Create();

// Convert XLSX to XLS
WorkBook xlsWorkBook = WorkBook.Create(ExcelFileFormat.XLS);

// Create a blank WorkSheet
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");

// Add data and styles to the new worksheet
workSheet["A1"].Value = "Hello World";
workSheet["A1"].Style.WrapText = true;
workSheet["A2"].BoolValue = true;
workSheet["A2"].Style.BottomBorder.Type = IronXL.Styles.BorderType.Double;

// Save the excel file as XLS, XLSX, CSV, TSV, JSON, XML, HTML and streams
workBook.SaveAs("sample.xlsx");

Install-Package IronXL.Excel

Dateitypen für Tabellenkalkulationen konvertieren Alle 28-Codebeispiele anzeigen

using IronXL;
using System.IO;

// Import any XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Export the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML
workBook.SaveAs("sample.xls");
workBook.SaveAs("sample.xlsx");
workBook.SaveAs("sample.tsv");
workBook.SaveAsCsv("sample.csv");
workBook.SaveAsJson("sample.json");
workBook.SaveAsXml("sample.xml");

// Export the excel file as Html, Html string
workBook.ExportToHtml("sample.html");
string htmlString = workBook.ExportToHtmlString();

// Export the excel file as Binary, Byte array, Data set, Stream
byte[] binary = workBook.ToBinary();
byte[] byteArray = workBook.ToByteArray();
System.Data.DataSet dataSet = workBook.ToDataSet(); // Allow easy integration with DataGrids, SQL and EF
Stream stream = workBook.ToStream();

Install-Package IronXL.Excel

Excel zu SQL über System.Data.DataSet Alle 28-Codebeispiele anzeigen

using IronXL;
using System;
using System.Data;

// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Convert the whole Excel WorkBook to a DataSet
DataSet dataSet = workBook.ToDataSet();

foreach (DataTable table in dataSet.Tables)
{
    Console.WriteLine(table.TableName);

    // Enumerate by rows or columns first at your preference
    foreach (DataRow row in table.Rows)
    {
        for (int i = 0 ; i < table.Columns.Count ; i++)
        {
            Console.Write(row[i]);
        }
    }
}

Install-Package IronXL.Excel

Excel zu SQL und DataGrid über DataTable Alle 28-Codebeispiele anzeigen

using IronXL;
using System;
using System.Data;

// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Select default sheet
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Convert the worksheet to DataTable
DataTable dataTable = workSheet.ToDataTable(true);

// Enumerate by rows or columns first at your preference
foreach (DataRow row in dataTable.Rows)
{
    for (int i = 0 ; i < dataTable.Columns.Count ; i++)
    {
        Console.Write(row[i]);
    }
}

Install-Package IronXL.Excel

Excel Bedingte Formatierung Alle 28-Codebeispiele anzeigen

using IronXL;
using IronXL.Formatting.Enums;
using IronXL.Styles;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Create conditional formatting rule
var rule = workSheet.ConditionalFormatting.CreateConditionalFormattingRule(ComparisonOperator.LessThan, "8");
// Set style options
rule.FontFormatting.IsBold = true;
rule.FontFormatting.FontColor = "#123456";
rule.BorderFormatting.RightBorderColor = "#ffffff";
rule.BorderFormatting.RightBorderType = BorderType.Thick;
rule.PatternFormatting.BackgroundColor = "#54bdd9";
rule.PatternFormatting.FillPattern = FillPattern.Diamonds;
// Apply formatting on specified region
workSheet.ConditionalFormatting.AddConditionalFormatting("A3:A8", rule);

// Create conditional formatting rule
var rule1 = workSheet.ConditionalFormatting.CreateConditionalFormattingRule(ComparisonOperator.Between, "7", "10");
// Set style options
rule1.FontFormatting.IsItalic = true;
rule1.FontFormatting.UnderlineType = FontUnderlineType.Single;
// Apply formatting on specified region
workSheet.ConditionalFormatting.AddConditionalFormatting("A3:A9", rule1);

workBook.SaveAs("applyConditionalFormatting.xlsx");

Install-Package IronXL.Excel

Excel-Dateien schützen Alle 28-Codebeispiele anzeigen

using IronXL;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Open protected spreadsheet file
WorkBook protectedWorkBook = WorkBook.Load("sample.xlsx", "IronSoftware");

// Spreadsheet protection
// Set protection for spreadsheet file
workBook.Encrypt("IronSoftware");

// Remove protection for spreadsheet file. Original password is required.
workBook.Password = null;

workBook.Save();

// Worksheet protection
// Set protection for individual worksheet
workSheet.ProtectSheet("IronXL");

// Remove protection for particular worksheet. It works without password!
workSheet.UnprotectSheet();

workBook.Save();

Install-Package IronXL.Excel

Excel-Formeln in C# Alle 28-Codebeispiele anzeigen

using IronXL;
using System.Linq;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set Formulas
workSheet["A1"].Formula = "Sum(B8:C12)";
workSheet["B8"].Formula = "=C9/C11";
workSheet["G30"].Formula = "Max(C3:C7)";

// Force recalculate all formula values in all sheets.
workBook.EvaluateAll();

// Get the formula's calculated value.  e.g. "52"
var formulaValue = workSheet["G30"].First().FormattedCellValue;

// Get the formula as a string. e.g. "Max(C3:C7)"
string formulaString = workSheet["G30"].Formula;

// Save changes with updated formulas and calculated values.
workBook.Save();

Install-Package IronXL.Excel

Excel-Metadaten in C# bearbeiten Alle 28-Codebeispiele anzeigen

using IronXL;
using System;

WorkBook workBook = WorkBook.Load("sample.xlsx");

// Set author
workBook.Metadata.Author = "Your Name";
// Set comments
workBook.Metadata.Comments = "Monthly report";
// Set title
workBook.Metadata.Title = "July";
// Set keywords
workBook.Metadata.Keywords = "Report";

// Read the creation date of the excel file
DateTime? creationDate = workBook.Metadata.Created;

// Read the last printed date of the excel file
DateTime? printDate = workBook.Metadata.LastPrinted;

workBook.SaveAs("editedMetadata.xlsx");

Install-Package IronXL.Excel

Erkunden Sie den Code, installieren Sie IronXL mit NuGet

IronXL

Nuget

Version 2024.11 freigegeben

Sehen Sie, was es Neues gibt

Plattformübergreifende Unterstützung

Konzipiert für C#, F#, & VB.NET weiterlaufend .NET 8, 7, 6, Core, Standard oder Framework

Die C# Excel-Bibliothek

Eine C#-Excel-Bibliothek, bei der Genauigkeit, Benutzerfreundlichkeit und Geschwindigkeit im Vordergrund stehen.

IronXL ist die führende C#-Excel-Bibliothek für die Erstellung und Bearbeitung von Excel-Dokumenten in .NET. Seine benutzerfreundliche API ermöglicht es Entwicklern, Excel-Funktionalität zu .NET-Projekten in wenigen Minuten hinzuzufügen.

Die Excel-API, die Sie brauchen, ohne den Ärger mit Office Interop.

IronXL Release Version 2024.11

Merkmale & Upgrades

Sehen Sie, was es Neues gibt

Kompatibilität

.NET-Sprachen:

C#, VB.NET, F#

Plattformen:

App-Typen:

Konsole, Web und Desktop

Betriebssysteme:

IDEs

Zertifizierung

Microsoft Authenticode

Arbeitsbücher

Tabellenkalkulationen erstellen oder laden

Formate speichern oder exportieren

System.Daten-Objekte

Einfuhr und Ausfuhr als DataSet oder DataTable

Arbeitsmappen bearbeiten

Arbeitsblätter

Formeln bearbeiten:

Daten sortieren:

Erstellen und Bearbeiten von Diagrammen:

Fläche, Balken, Säule, Linien, Torte, Streuung

Layout bearbeiten:

Scheiben einfrieren
Automatische Größe Zeilen/Rubriken
Hinzufügen und Entfernen Zeilen/Rubriken

Arbeitsblätter bearbeiten:

Zellbereiche

Zellbereich-Funktionen:

Style Cells:

Mathematische Funktionen:

Durchschnitt und Summe
Min und Max

Zelldatenformate festlegen:

Text, Zahl, Formel, Datum, Währung, Wissenschaftlich, Zeit, Boolesch, Benutzerdefinierte Formate

Vollständiger Funktionssatz anzeigen

Millionen von Ingenieuren weltweit vertrauen darauf

Technik von Weltklasse,
24-Stunden-Unterstützung

Sprechen Sie mit einem Experten

Sind Sie bereit, loszulegen? Version: 2024.11 gerade veröffentlicht

Lizenzen anzeigen >

IronXL ist ein Teil von IRONSUITE

9 .NET API-Produkte für Ihre Bürodokumente

Sie erhalten 9 Produkte zum Preis von 2

Kostenlos testen