📚
OpenXML-Office
v4.x (Alpha)
v4.x (Alpha)
  • Welcome
    • Getting Started
    • Introduction
    • Benchmark🚧🛠️
    • Status Badge 🚧🛠️
    • Privacy Policy
    • License
  • Spreadsheet
    • Excel
    • Worksheet🚧🛠️
    • Shape🚧🛠️
    • Picture🚧🛠️
    • Table🚧🛠️
    • Chart🚧🛠️
      • Area
      • Bar
      • Column
      • Line
      • Pie
      • Scatter
      • Combo
    • Style🚧🛠️
    • Shared🚧🛠️
  • Presentation🚧🛠️
    • PowerPoint🚧🛠️
    • Slide🚧🛠️
    • Shape🚧🛠️
    • Picture🚧🛠️
    • Textbox🚧🛠️
    • Table🚧🛠️
    • Chart🚧🛠️
      • Area
      • Bar
      • Column
      • Line
      • Pie
      • Scatter
      • Combo
      • Waterfall
  • Document🚧🛠️
    • Word🚧🛠️
    • Shape🚧🛠️
    • Picture🚧🛠️
    • Table🚧🛠️
    • Chart🚧🛠️
  • FFI🚧🛠️
    • Spreadsheet🚧🛠️
    • Presentation 🚧🛠️
    • Document🚧🛠️
Powered by GitBook
On this page

Was this helpful?

  1. Spreadsheet

Excel

The Excel class/struct, an integral part of the library, facilitates seamless interaction with Excel workbooks. Designed to simplify the creation and manipulation of Excel (.xlsx) files, this class/struct 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 Excel class/struct. Developers can swiftly create new workbooks or open existing ones, setting the stage for easy data management.

  2. Worksheet Manipulation: The class/struct 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 Excel class/struct 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

let mut file = crate::spreadsheet_2007::Excel::new(
        None,
        crate::spreadsheet_2007::ExcelPropertiesModel::default(),
    )
.expect("File Created Failed");
Excel excel = new();
Worksheet worksheet = excel.AddSheet();
excel.SaveAs(string.Format("../../test-{0}.xlsx", DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss")));

PreviousLicenseNextWorksheet🚧🛠️

Last updated 1 month ago

Was this helpful?