Openize.Cells.Examples 24.5.0

Openize.Cells.Examples

Overview

Openize.Cells.Examples is a comprehensive collection of C# examples demonstrating efficient ways to manipulate Excel spreadsheets using the Openize.Cells C# API. This package is designed to help developers streamline their spreadsheet processing tasks with practical, ready-to-use code snippets.

Features

• Workbook Operations: Create, save, and manipulate Excel workbook files.
• Worksheet Manipulation: Read and write data in cells, merge cells, and protect/unprotect worksheets.
• Cell Formatting: Apply styles, fonts, and colors to cells.
• Formulas: Add and compute formulas in cells.
• Document Properties: Set and retrieve custom document properties like author, title, and subject.

Getting Started

To use Openize.Cells.Examples in your project, follow these steps:

1. Install the Package:

   Install-Package Openize.Cells.Examples
   

2. Add Namespace:

   using Openize.Cells.Examples;
   

3. Explore Examples: Browse through various examples provided in the package to understand how to perform different spreadsheet operations.

Usage

Here's a simple example of how to create a new workbook and add a worksheet with data:

WorkbookExamples workbookExamples = new WorkbookExamples();
workbookExamples.CreateAndSaveWorkbook("path/to/your/newWorkbook.xlsx");

For more detailed examples, refer to the individual methods within the WorkbookExamples and WorksheetExamples classes.