Comment enregistrer un fichier Excel en VB.NET

How to Use VB.NET to Save an Excel File

1. Create a new console project.
2. Install the IronXL library.
3. Create the necessary object to use the IronXL library.
4. Use the created object to add the values.
5. Save the Excel document in the desired location and dispose of the object.

What is 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:

• Data handling: Reading, writing, and manipulating data in Excel spreadsheets is made simple with IronXL. Cell values can be retrieved using a two-dimensional array, and calculations, formulas, and data formatting are all possible.
• Excel file creation and modification: Developers have the ability to create new Excel files and modify existing ones, as well as add, remove, and manage worksheets. They can also interact with a wide range of Excel elements.
• Cross-platform compatibility: Due to its cross-platform compatibility, IronXL can be used in various application scenarios and is compatible with multiple .NET platforms, such as Xamarin, .NET Core, and .NET Framework.
• Versatility and compatibility: It works with several Excel versions and supports the newer XLSX Excel format in addition to the older XLS Excel format.
• Support for both legacy and modern Excel formats: It is capable of supporting both older Excel file formats (XLS, which dates back to Excel 97–2003) and more modern XML-based formats (XLSX, which dates back to Excel 2007).
• Usefulness: The library makes Excel-related tasks more accessible to developers with different levels of experience by providing a simple API with clearly understood properties and operations.
• Data extraction and export: IronXL makes it easy to connect with databases and other systems by facilitating the extraction of data from Excel files and the export of Excel data to various formats.
• Support and documentation: IronXL offers a plethora of tutorials, support, and documentation to help developers utilize its library for Excel-related tasks.
• Automation and efficiency: IronXL helps users create data-driven, efficient applications, be more productive, and spend less time on manual labor by automating Excel processes.
• Integration and customization: By offering options for exporting Excel data into multiple formats, it facilitates the creation of customized reports and data-driven solutions. It also integrates well with other systems and databases.

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.

Create a New Visual Studio Project

Installing IronXL Library

To install the IronXL library, follow these steps:

1. 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

   Install-Package IronXL

   SHELL

   

2. 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.

   

Saving an Excel File with IronXL in VB.NET

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())
        ' Define the path where the Excel file will be saved
        Dim excelFilePath As String = "file path here"

        ' Create a new Excel workbook
        Dim workbook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)

        ' Add a worksheet to the workbook
        Dim worksheet As WorkSheet = workbook.CreateWorkSheet("Sheet1")

        ' Add data to the worksheet
        worksheet("A1").Value = "Hello"
        worksheet("B1").Value = "IronXL!"

        ' Save the Excel workbook to the specified path
        workbook.SaveAs(excelFilePath)

        ' Output confirmation message
        Console.WriteLine("Excel file saved successfully at: " & excelFilePath)
    End Sub
End Module

Imports IronXL

Module Program
    Sub Main(args As String())
        ' Define the path where the Excel file will be saved
        Dim excelFilePath As String = "file path here"

        ' Create a new Excel workbook
        Dim workbook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)

        ' Add a worksheet to the workbook
        Dim worksheet As WorkSheet = workbook.CreateWorkSheet("Sheet1")

        ' Add data to the worksheet
        worksheet("A1").Value = "Hello"
        worksheet("B1").Value = "IronXL!"

        ' Save the Excel workbook to the specified path
        workbook.SaveAs(excelFilePath)

        ' Output confirmation message
        Console.WriteLine("Excel file saved successfully at: " & excelFilePath)
    End Sub
End Module

To 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.

Conclusion

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 $799. 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.