xlnt
  • Read Me
  • Introduction
    • Motivation
    • Examples
    • Features
    • Installation
  • Basics
    • Workbook
    • Worksheet
    • Cell
    • Iteration
    • Memory model
  • Advanced
    • Formatting
    • Properties
    • Printing
    • Encryption
    • Views
  • API Reference
  • Source code
  • Change Log
  • Contributing
  • License
Powered by GitBook
On this page
Edit on GitHub
  1. Introduction

Features

Feature
Read
Edit
Write

Excel-style Workbook

✓

✓

✓

LibreOffice-style Workbook

✓

✓

✓

Numbers-style Workbook

✓

✓

✓

Encrypted Workbook (Excel 2007-2010)

✓

✓

Encrypted Workbook (Excel 2013-2016)

✓

✓

Excel Binary Workbook (.xlsb)

Excel Macro-Enabled Workbook (.xlsm)

Excel Macro-Enabled Template (.xltm)

Document Properties

✓

✓

✓

Numeric Cell Values

✓

✓

✓

Inline String Cell Values

✓

✓

✓

Shared String Cell Values

✓

✓

✓

Shared String Text Run Formatting (e.g. varied fonts within a cell)

✓

✓

✓

Hyperlink Cell Values

Formula Cell Values

Formula Evaluation

Page Margins

✓

✓

✓

Page Setup

Print Area

Comments

✓

✓

Header and Footer

Custom Views

Charts

Chartsheets

Dialogsheets

Themes

✓

✓

Cell Styles

✓

✓

✓

Cell Formats

✓

✓

✓

Formatting->Alignment (e.g. right align)

✓

✓

✓

Formatting->Border (e.g. red cell outline)

✓

✓

✓

Formatting->Fill (e.g. green cell background)

✓

✓

✓

Formatting->Font (e.g. blue cell text)

✓

✓

✓

Formatting->Number Format (e.g. show 2 decimals)

✓

✓

✓

Formatting->Protection (e.g. hide formulas)

✓

✓

✓

Column Styles

Row Styles

Sheet Styles

Conditional Formatting

Tables

Table Formatting

Pivot Tables

XLSX Thumbnail

✓

✓

Custom OOXML Properties

Custom OOXML Parts

Drawing

Text Box

WordArt

Embedded Content (e.g. images)

Excel VBA

PreviousExamplesNextInstallation

Last updated 8 months ago