Porównanie IronXL i Spire XLS

2.1.1. Platformy

Spire.XLS dla .NET pozwala programistom tworzyć aplikacje ASP.NET, usługi internetowe, WinForms i inne rodzaje aplikacji dla dowolnej wersji .NET Framework od 2.0 do 4.5, .NET 5.0, .NET Core, .NET Standard, MonoAndroid, Xamarin i iOS. Obsługuje zarówno systemy 32-bitowe, jak i 64-bitowe.

2.1.2. Konwersja plików

Spire.XLS umożliwia użytkownikom konwersję plików Excel do różnych formatów oraz konwersję plików w różnych formatach do plików Excel:

• Excel do tekstu
• Excel do obrazu
• Plik Excel do PDF
• Excel do HTML
• Plik XML/CSV do Excela
• Excel do XPS
• Excel do SVG

2.1.3. Zawartość i funkcje

Spire.XLS dla .NET oferuje wiele funkcji do edycji i manipulacji plikami Excel, w szczególności:

• Tworzenie i edycja skoroszytów programu Excel.
• Zapisywanie plików Excel w strumieniach plików.
• Wyszukiwanie i zamiana danych w skoroszytach programu Excel.
• Sortowanie i walidacja danych.
• Drukowanie plików.
• Usuwanie, wstawianie lub ukrywanie wierszy i kolumn.

2.1.4. Funkcje formatowania

Spire.XLS dla .NET zapewnia pełny programowy dostęp do wszystkich elementów arkusza kalkulacyjnego i atrybutów formatowania, takich jak ustawienia czcionek, formaty liczb, wyrównanie tekstu, obiekty graficzne oraz formatowanie arkuszy, wierszy, kolumn lub zakresów komórek programu Excel.

2.1.5. Ustawienia strony

Programiści mogą konfigurować parametry ustawień strony za pomocą Spire.XLS dla .NET:

• Ustaw obszar drukowania i tytuły wydruku lub włącz siatkę.
• Dodaj podziały stron.
• Utwórz lub zaktualizuj nagłówki i/lub stopki oparte na obrazach.
• Zmiana orientacji strony, skali i rozmiaru papieru.
• Ustaw wyśrodkowanie strony i marginesy.

3.1. Funkcje IronXL

5.1 Using the Visual Studio NuGet Package Manager

Visual Studio provides the NuGet Package Manager option to install packages directly to the solution. Here is how you can open the NuGet Package Manager:

Search for "IronXL" in the package manager to find and install the desired package:

Select IronXL and install the package to your solution.

5.2 Using the Visual Studio Command-Line

• In Visual Studio, go to Tools -> NuGet Package Manager -> Package Manager Console.

• Run the following command in the package manager console:

  Install-Package IronXl.Excel

The package will now download to the current project and be ready for use.

5.3 Direct Download from the NuGet Webpage

To download the NuGet package directly:

1. Navigate to https://www.nuget.org/packages/IronXl.Excel.
2. Select "Download Package" from the menu on the right.
3. Double-click the downloaded package to install it automatically.
4. Reload the solution and start using it in the project.

5.4 Direct Download from the IronXL Webpage

Download the latest package from IronXL's webpage here. After downloading:

1. Right-click on the project in the Solution Explorer.
2. Select "Add Reference" and browse to the downloaded reference location.
3. Click OK to add the reference.

6.1. Using the Visual Studio NuGet Package Manager

Following the process for IronXL, open the NuGet Package Manager and search for Spire.XLS:

Select the required package and install it.

6.2. Using the Visual Studio NuGet Package Console

1. In Visual Studio, go to Tools -> NuGet Package Manager -> Package Manager Console.

2. Run the following line in the console:

   Install-Package Spire.XLS -Version 12.3.8

   Install-Package Spire.XLS -Version 12.3.8

   SHELL

The package will be downloaded and installed in the current project.

6.3. Direct Download from the NuGet Website

To download Spire.XLS directly:

1. Navigate to https://www.nuget.org/packages/Spire.XLS/.
2. Select "Download Package" from the right-hand menu.
3. Double-click the downloaded package to install it automatically.
4. Reload the solution and start using it in the project.

7.1. Create New Excel Files Using IronXL

IronXL allows creating Excel sheets in XLS and XLSX formats. The code to create a new workbook using IronXL is as follows:

using IronXL;

class Program
{
    static void Main()
    {
        // Create a new workbook in XLS format
        WorkBook xlsWorkbook = WorkBook.Create(ExcelFileFormat.XLS);
        xlsWorkbook.Metadata.Author = "IronXL";

        // Add a blank WorkSheet
        WorkSheet xlsSheet = xlsWorkbook.CreateWorkSheet("new_sheet");

        // Add data and styles to the new worksheet
        xlsSheet["A1"].Value = "Hello World";
        xlsSheet["A2"].Style.BottomBorder.SetColor("#ff6600");
        xlsSheet["A2"].Style.BottomBorder.Type = IronXl.Styles.BorderType.Double;

        // Save the Excel file
        xlsWorkbook.SaveAs("NewExcelFile.xls");
    }
}

using IronXL;

class Program
{
    static void Main()
    {
        // Create a new workbook in XLS format
        WorkBook xlsWorkbook = WorkBook.Create(ExcelFileFormat.XLS);
        xlsWorkbook.Metadata.Author = "IronXL";

        // Add a blank WorkSheet
        WorkSheet xlsSheet = xlsWorkbook.CreateWorkSheet("new_sheet");

        // Add data and styles to the new worksheet
        xlsSheet["A1"].Value = "Hello World";
        xlsSheet["A2"].Style.BottomBorder.SetColor("#ff6600");
        xlsSheet["A2"].Style.BottomBorder.Type = IronXl.Styles.BorderType.Double;

        // Save the Excel file
        xlsWorkbook.SaveAs("NewExcelFile.xls");
    }
}

Imports IronXL

Class Program
    Shared Sub Main()
        ' Create a new workbook in XLS format
        Dim xlsWorkbook As WorkBook = WorkBook.Create(ExcelFileFormat.XLS)
        xlsWorkbook.Metadata.Author = "IronXL"

        ' Add a blank WorkSheet
        Dim xlsSheet As WorkSheet = xlsWorkbook.CreateWorkSheet("new_sheet")

        ' Add data and styles to the new worksheet
        xlsSheet("A1").Value = "Hello World"
        xlsSheet("A2").Style.BottomBorder.SetColor("#ff6600")
        xlsSheet("A2").Style.BottomBorder.Type = IronXl.Styles.BorderType.Double

        ' Save the Excel file
        xlsWorkbook.SaveAs("NewExcelFile.xls")
    End Sub
End Class

7.2. Create a New Excel File Using Spire.XLS

Spire.XLS allows creating Excel files without installing MS Excel or any third-party library. Below is the sample code:

using Spire.Xls;
using System.IO;

namespace CreateExcelFiles
{
    class Program
    {
        static void Main(string[] args)
        {
            // Instantiate Workbook
            Workbook workbook = new Workbook();
            Worksheet sheet = workbook.Worksheets[0];

            // Set text in a specific cell
            sheet.Range["C10"].Text = "The sample demonstrates how to save an Excel workbook to a stream.";

            // Save the workbook to a stream
            FileStream fileStream = new FileStream("DEMO.xls", FileMode.Create);
            workbook.SaveToStream(fileStream);
            fileStream.Close();

            // Automatically open the new Excel file
            System.Diagnostics.Process.Start("DEMO.xls");
        }
    }
}

using Spire.Xls;
using System.IO;

namespace CreateExcelFiles
{
    class Program
    {
        static void Main(string[] args)
        {
            // Instantiate Workbook
            Workbook workbook = new Workbook();
            Worksheet sheet = workbook.Worksheets[0];

            // Set text in a specific cell
            sheet.Range["C10"].Text = "The sample demonstrates how to save an Excel workbook to a stream.";

            // Save the workbook to a stream
            FileStream fileStream = new FileStream("DEMO.xls", FileMode.Create);
            workbook.SaveToStream(fileStream);
            fileStream.Close();

            // Automatically open the new Excel file
            System.Diagnostics.Process.Start("DEMO.xls");
        }
    }
}

Imports Spire.Xls
Imports System.IO

Namespace CreateExcelFiles
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			' Instantiate Workbook
			Dim workbook As New Workbook()
			Dim sheet As Worksheet = workbook.Worksheets(0)

			' Set text in a specific cell
			sheet.Range("C10").Text = "The sample demonstrates how to save an Excel workbook to a stream."

			' Save the workbook to a stream
			Dim fileStream As New FileStream("DEMO.xls", FileMode.Create)
			workbook.SaveToStream(fileStream)
			fileStream.Close()

			' Automatically open the new Excel file
			System.Diagnostics.Process.Start("DEMO.xls")
		End Sub
	End Class
End Namespace

8.1. CSV to Excel using IronXL

IronXL enables developers to generate Excel workbooks from CSV format effortlessly. Here is how to convert a CSV file to Excel:

using IronXL;

class Program
{
    static void Main()
    {
        // Load CSV file into a workbook
        WorkBook workbook = WorkBook.LoadCSV("test.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");
        WorkSheet ws = workbook.DefaultWorkSheet;

        // Save the workbook as an Excel file
        workbook.SaveAs("CsvToExcelConversion.xlsx");
    }
}

using IronXL;

class Program
{
    static void Main()
    {
        // Load CSV file into a workbook
        WorkBook workbook = WorkBook.LoadCSV("test.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");
        WorkSheet ws = workbook.DefaultWorkSheet;

        // Save the workbook as an Excel file
        workbook.SaveAs("CsvToExcelConversion.xlsx");
    }
}

Imports IronXL

Friend Class Program
	Shared Sub Main()
		' Load CSV file into a workbook
		Dim workbook As WorkBook = WorkBook.LoadCSV("test.csv", fileFormat:= ExcelFileFormat.XLSX, ListDelimiter:= ",")
		Dim ws As WorkSheet = workbook.DefaultWorkSheet

		' Save the workbook as an Excel file
		workbook.SaveAs("CsvToExcelConversion.xlsx")
	End Sub
End Class

8.2. CSV to Excel using Spire.XLS

Spire.XLS handles CSV to Excel conversion efficiently. Here's how you can achieve this:

using Spire.Xls;

namespace ConvertCsvToExcel
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create an instance of Workbook class
            Workbook workbook = new Workbook();

            // Load a CSV file
            workbook.LoadFromFile(@"ExcelToCSV.csv", ",", 1, 1);

            // Get the first worksheet and used range
            Worksheet sheet = workbook.Worksheets[0];
            CellRange usedRange = sheet.AllocatedRange;
            usedRange.IgnoreErrorOptions = IgnoreErrorType.NumberAsText;

            // Autofit columns and rows
            usedRange.AutoFitColumns();
            usedRange.AutoFitRows();

            // Save the result file
            workbook.SaveToFile("CSVToExcel.xlsx", ExcelVersion.Version2013);
        }
    }
}

using Spire.Xls;

namespace ConvertCsvToExcel
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create an instance of Workbook class
            Workbook workbook = new Workbook();

            // Load a CSV file
            workbook.LoadFromFile(@"ExcelToCSV.csv", ",", 1, 1);

            // Get the first worksheet and used range
            Worksheet sheet = workbook.Worksheets[0];
            CellRange usedRange = sheet.AllocatedRange;
            usedRange.IgnoreErrorOptions = IgnoreErrorType.NumberAsText;

            // Autofit columns and rows
            usedRange.AutoFitColumns();
            usedRange.AutoFitRows();

            // Save the result file
            workbook.SaveToFile("CSVToExcel.xlsx", ExcelVersion.Version2013);
        }
    }
}

Imports Spire.Xls

Namespace ConvertCsvToExcel
	Friend Class Program
		Shared Sub Main(ByVal args() As String)
			' Create an instance of Workbook class
			Dim workbook As New Workbook()

			' Load a CSV file
			workbook.LoadFromFile("ExcelToCSV.csv", ",", 1, 1)

			' Get the first worksheet and used range
			Dim sheet As Worksheet = workbook.Worksheets(0)
			Dim usedRange As CellRange = sheet.AllocatedRange
			usedRange.IgnoreErrorOptions = IgnoreErrorType.NumberAsText

			' Autofit columns and rows
			usedRange.AutoFitColumns()
			usedRange.AutoFitRows()

			' Save the result file
			workbook.SaveToFile("CSVToExcel.xlsx", ExcelVersion.Version2013)
		End Sub
	End Class
End Namespace

IronXL Licensing

IronXL provides a developer's license for free, with the Lite bundle starting at a price with no hidden fees. SaaS and OEM distribution are possible. All licenses offer a 30-day money-back guarantee, a year of software support and upgrades, and a perpetual license. For more details on IronXL pricing and licensing, visit their official licensing page.

Spire.XLS Licensing

Spire.XLS offers three licensing categories:

• Free Version: Limited to five sheets per workbook and 200 rows per sheet. The print function is not available.
• Standard Edition: Limited to .NET, without printing or conversion support.
• Pro Edition: Part of the Spire.XLS Pack, supports numerous conversions like Excel to PDF, HTML, CSV, etc.