Create a new Excel File

VB C#

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");

Imports IronXL

' Create new Excel WorkBook document
Private workBook As WorkBook = WorkBook.Create()

' Convert XLSX to XLS
Private xlsWorkBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLS)

' Create a blank WorkSheet
Private workSheet As WorkSheet = workBook.CreateWorkSheet("new_sheet")

' Add data and styles to the new worksheet
Private workSheet("A1").Value = "Hello World"
Private workSheet("A1").Style.WrapText = True
Private workSheet("A2").BoolValue = True
Private 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

Create a new Excel File

The Create Excel feature provides developers with a powerful way to generate and manage Excel files directly within .NET applications.

It streamlines tasks like creating new workbooks, adding worksheets, and inputting data while offering advanced styling options such as text wrapping, borders, and formatting. This feature is perfect for automating reports, exporting data, or creating dynamic spreadsheets. IronXL supports multiple file formats, including XLS, XLSX, CSV, and more, ensuring compatibility with various systems. With its user-friendly API, developers can focus on core functionality while saving time and reducing complexity in Excel file management.

5 Steps to Create and Style Excel Files with IronXL

WorkBook workBook = WorkBook.Create();
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");
workSheet["A1"].Value = "Hello World";
workSheet["A1"].Style.WrapText = true;
workBook.SaveAs("sample.xlsx");

The WorkBook object serves as the foundation of any Excel file. By initializing a new workbook, developers gain access to a blank Excel document, ready to be populated with data and formatted as needed.

Every Excel workbook requires at least one worksheet. The next step demonstrates how to create a new sheet within the workbook and assign it a custom name. Worksheets act as the primary structure for organizing data in rows and columns.

The snippet demonstrates how to add content by assigning the value "Hello World" to a specific cell, A1. This shows how easy it is to populate data into an Excel sheet programmatically, enabling developers to automate tasks like report generation and data export.

Additionally, the snippet applies styling to the cell by enabling the WrapText property. This ensures that lengthy content in the cell is displayed neatly across multiple lines, improving readability and preventing text from being cut off. Such styling options empower developers to create visually appealing and professional spreadsheets.

Lastly, the workbook is saved as an .xlsx file, ensuring all changes are preserved. This file can be opened in any Excel-compatible application, offering broad compatibility.

// Create a new workbook
WorkBook workBook = WorkBook.Create();

// Create a new worksheet with a specified name
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");

// Set the value of cell A1
workSheet["A1"].Value = "Hello World";

// Enable text wrapping for cell A1 to improve readability
workSheet["A1"].Style.WrapText = true;

// Save the workbook to a specified file path
workBook.SaveAs("sample.xlsx");

// Create a new workbook
WorkBook workBook = WorkBook.Create();

// Create a new worksheet with a specified name
WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet");

// Set the value of cell A1
workSheet["A1"].Value = "Hello World";

// Enable text wrapping for cell A1 to improve readability
workSheet["A1"].Style.WrapText = true;

// Save the workbook to a specified file path
workBook.SaveAs("sample.xlsx");

' Create a new workbook
Dim workBook As WorkBook = WorkBook.Create()

' Create a new worksheet with a specified name
Dim workSheet As WorkSheet = workBook.CreateWorkSheet("new_sheet")

' Set the value of cell A1
workSheet("A1").Value = "Hello World"

' Enable text wrapping for cell A1 to improve readability
workSheet("A1").Style.WrapText = True

' Save the workbook to a specified file path
workBook.SaveAs("sample.xlsx")

$vbLabelText $csharpLabel

Click here to view the How-to Guide, including examples, sample code, and files