Spreadsheet

The Spreadsheet class, an integral part of the OpenXMLOffice.Excel library, facilitates seamless interaction with Excel workbooks. Designed to simplify the creation and manipulation of Excel (.xlsx) files, this class provides a user-friendly interface for developers to efficiently handle data, worksheets, and formatting.

Key Features

1. Effortless Initialization: Initializing a new Excel workbook is simplified with the Spreadsheet class. Developers can swiftly create new workbooks or open existing ones, setting the stage for easy data management.

2. Worksheet Manipulation: The class offers intuitive methods for adding, deleting, and manipulating worksheets within a workbook. Developers can efficiently organize data and structure it across multiple sheets.

3. Cell-Level Operations: Granular control over individual cells is provided, allowing developers to set values, apply formatting, and perform various operations on specific cells within a worksheet.

4. Data Import and Export: The Spreadsheet class supports seamless data import from external sources and export to various formats. This enables efficient integration with external data sets and applications.

Basic Code Samples

C#

Spreadsheet spreadsheet = new(string.Format("../../test-{0}.xlsx", DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss")));
Worksheet worksheet = spreadsheet.AddSheet();
spreadsheet.Save();