The C# Excel Library
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
Microsoft Excel is a popular multipurpose spreadsheet program that is well-known for its efficiency in data organization, analysis, and visualization. Excel is a program that functions in a manner like a grid. It organizes data into rows and columns and enables users to enter various types of data, including text, numbers, dates, and formulas within individual cells.
Its powerful computation capabilities via formulas and functions allow users to carry out various logical, statistical, and mathematical tasks.
Excel provides capabilities for organizing and analyzing data, as well as creating graphs and charts to depict the data graphically. It promotes teamwork by enabling file sharing and concurrent editing among several people. Because of its versatility in meeting a variety of user demands across sectors, it can be customized and automated through the use of macros, VBA, and add-ins.
Applications for Excel include finance, research, business analytics, and education. It is a vital tool for managing, analyzing, and making decisions with data. In this article, we're going to look at how you can use VB.NET to save Excel files with the help of IronXL.
IronXL is a robust .NET framework designed to make working with Excel files in C#, VB.NET, and other .NET languages easier. Both the XLS and XLSX file formats are compatible with it. Developers can write, read, modify, and create Excel spreadsheets more quickly and easily with the help of this library. There are also a wide range of tools and features available.
Salient attributes and functionalities of IronXL include:
Among the many industries that use IronXL are finance, data analysis, reporting, business intelligence, and software development. It enables programmers to interact with Excel files and create reliable solutions by combining data manipulation with Excel integration. For more information, visit this link.
Creating a Visual Studio console project is simple. Follow these steps to develop a console application using Visual Studio:
To start a new project, follow these steps:
Choose File, New, and finally Project.
Provide a name for your project in the "Name" field.
Click Create to create a new console application project.
To install the IronXL library, follow these steps:
Install the IronXL library as it is required for the upcoming steps. To do this, open the NuGet Package Manager Console and enter the following command:
Install-Package IronXL.Excel
Alternatively, you can search for the package "IronXL" using the NuGet Package Manager. From the list of all the NuGet packages related to IronXL, select the ones that need to be downloaded.
You can follow these steps to save an Excel file using IronXL in a VB.NET application. Here is an example code snippet that demonstrates how to use IronXL in VB.NET to save an Excel document:
Imports IronXL
Module Program
Sub Main(args As String())
Dim excelFilePath As String = "file path here"
' Create a new Excel workbook
Dim workbook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)
' Add data or perform operations within the workbook (optional)
Dim worksheet As WorkSheet = workbook.CreateWorkSheet("Sheet1")
worksheet("A1").Value = "Hello"
worksheet("B1").Value = "IronXL!"
' Save the Excel workbook to the specified path
workbook.SaveAs(excelFilePath)
Console.WriteLine("Excel file saved successfully at: " & excelFilePath)
End Sub
End ModuleImports IronXL
Module Program
Sub Main(args As String())
Dim excelFilePath As String = "file path here"
' Create a new Excel workbook
Dim workbook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)
' Add data or perform operations within the workbook (optional)
Dim worksheet As WorkSheet = workbook.CreateWorkSheet("Sheet1")
worksheet("A1").Value = "Hello"
worksheet("B1").Value = "IronXL!"
' Save the Excel workbook to the specified path
workbook.SaveAs(excelFilePath)
Console.WriteLine("Excel file saved successfully at: " & excelFilePath)
End Sub
End ModuleTo save an Excel document, replace "file path here" with the appropriate location and filename. You can modify the data or perform other operations within the workbook before saving.
This code snippet creates a new Excel workbook, adds a worksheet named "Sheet1", uses IronXL to write data into cells A1 and B1, and saves the workbook in the XLSX format at the specified file path. Ensure that the location where you plan to save the Excel file has the necessary write permissions. You can also use an existing template Excel file to save the documents.
By running this code, you will be able to use IronXL in a VB.NET program to create an Excel sheet in the specified file directory with the desired data and structure. Make any necessary adjustments to the workbook's data and settings before saving it in the XLSX file format.
To learn more about this code, refer to the documentation here.
Software development, finance, data analysis, and reporting are just a few of the industries that heavily rely on the Excel library IronXL.
The ability to create dynamic, data-centric applications that effectively and programmatically manage Excel files makes IronXL a vital tool for developers and enterprises looking to maximize operations using Excel.
In conclusion, IronXL offers a reliable and flexible way to create, load, and save Excel documents programmatically in a VB.NET context. With its comprehensive functionality and user-friendly API, developers can easily generate Excel files with structured data, formatting, and calculations to effectively meet various data management and reporting needs.
A free Community Edition with limitations for non-commercial usage is available from IronXL. Paid versions come with additional features, support, and full capabilities, with prices starting at $749. Licensing options include subscription-based or perpetual-based models.
For up-to-date and comprehensive licensing details, please refer to the official IronXL website. For more information on Iron Software products, visit this link.
Install-Package IronXL.Excel
Want to deploy IronXL to a live project for FREE?
Your trial key should be in the email.
The trial form was submitted
successfully.
If it is not, please contact
support@ironsoftware.com
Get started for FREE
No credit card required
Test in production without watermarks.
Works wherever you need it to.
Get 30 days of fully functional product.
Have it up and running in minutes.
Full access to our support engineering team during your product trial
No credit card or account creation required
Your trial key should be in the email.
If it is not, please contact
support@ironsoftware.com
Get started for FREE
No credit card required
Test in production without watermarks.
Works wherever you need it to.
Get 30 days of fully functional product.
Have it up and running in minutes.
Full access to our support engineering team during your product trial
Licenses from $749. Have a question? Get in touch.
9 .NET API products for your office documents
