Streamline Excel Spreadsheet Generation and Customization with .NET API

Getting Started with Openize.Cells for .NET

The recommended way to install Openize.Cells for .NET is using NuGet. Please use the following command for a smooth installation.

NuGet\Install-Package Openize.Cells 

Creating an Empty Excel Workbook / Spreadsheet Programmatically

The following code snippet exemplifies how to create and save a new Microsoft Excel spreadsheet using C# with the Openize.Cells library.

• The code begins by importing the necessary library Openize.Cells, providing access to functionalities for Excel spreadsheet manipulation.
• Within the Example namespace, the Program class is defined.
• The Main method serves as the entry point of the program, accepting command-line arguments if any (string[] args).
• An instance of the Workbook class is initialized using Workbook workbook = new Workbook();.
• The Save method is invoked on the workbook instance to save the Excel spreadsheet. The file is saved with the name "Spreadsheet.xlsx" in the root directory `("/") of the disk.

Copy and paste the code snippet below into your main file and execute the program.

 
using Openize.Cells;

namespace Example
{
    class Program
    {
        static void Main(string[] args)
        {
            // Initialize an instance of the Workbook class.
            Workbook workbook = new Workbook();

            // Call the Save method to save the MS Excel Spreadsheet/Workbook onto the disk.
            workbook.Save("/Spreadsheet.xlsx");
        }

    }
}

Getting Cell Values from an Excel Spreadsheet/ Workbook Programmatically

The following code illustrates how to open an existing Microsoft Excel spreadsheet using C# and retrieve the value from a specific cell. To access and interact with your spreadsheet, follow these steps:

• Create an instance of the Workbook class by specifying the path to your existing spreadsheet.
• Retrieve the Worksheet from the Workbook.
• Assign the cell object to a variable.
• Use the GetValue() method to extract the value from the specified cell.

Copy and paste the code snippet below into your main file and execute the program.

 

using (Workbook wb = new Workbook(filePath)) // Load existing spreadsheet/workbook file.
{
    Worksheet firstSheet = wb.Worksheets[0]; // Load first worksheet within workbook.
    Cell cellA1 = firstSheet.Cells["A1"]; // Get A1 cell object within cellA1 variable.
    Console.WriteLine(cellA1.GetDataType()); // Output cellA1 data type.
    string value = cellA1.GetValue(); // Get value within cell A1.
    Console.WriteLine(value); // Output the value stored in cell A1
}

Merging Cells within an Excel Worksheet Programatically

The provided code demonstrates how to programmatically merge cells in a Microsoft Excel spreadsheet using C#. Here's a breakdown of the steps:

• Initialize a new instance of the Workbook class.
• Access the first worksheet within the workbook.
• Utilize the MergeCells method to merge cells from A1 to C1.
• Assign a value to the top-left cell of the merged area..
• Save the modified workbook to a specified file path.

To integrate this functionality into your C# application, follow these steps:

• Insert the code snippet into your main file.
• Execute the program to merge cells and assign values accordingly.

This approach streamlines the process of merging cells and manipulating cell data within Excel spreadsheets programmatically

Copy and paste the code snippet below into your main file and execute the program.

 

using (var workbook = new Workbook())
{
    var firstSheet = workbook.Worksheets[0];
    firstSheet.MergeCells("A1", "C1"); // Merge cells from A1 to C1

    // Add value to the top-left cell of the merged area
    var topLeftCell = firstSheet.Cells["A1"];
    topLeftCell.PutValue("This is a merged cell");

    workbook.Save(filePath);
}