Dependencies

 

• No external library dependency

 

Open workbooks in the following formats

 

• Excel 97-2003 Workbook (.xls)
• Excel Binary Workbook (.xlsb)
• Excel Workbook (.xlsx)
  • Excel Macro-Enabled Workbook(.xlsm)
• XML Spreadsheet 2003
• CSV (Comma delimited)
• Formatted text (Tab or space delimited)

 

Save workbooks in the following formats

• Excel Workbook (.xlsx)
• CSV (Comma delimited)
• Formatted text (Tab or space delimited)

 

Full API Support for the following features

 

• Charts
• Formatting Cells
  • Alignment
  • Borders
  • Fill
  • Fonts
  • Number Format
  • Protection
  • Rich Text
• Comments
  • Formatting
  • Line, Fill
  • Background Picture
• Conditional Formatting
• Connections and Query Tables
• Data Validation
• Filtering
• Find and Replace
• Formulas
• Hyperlinks
• Page Setup
• Shapes
  • Fill
  • Line
  • Effects
  • Pictures
  • Shape Types
  • Text Formatting
  • Text Effects
• Sorting
• Sparklines
• Tables
  • Calculation
  • Filter
  • Sort
  • Styling

 

Read-Only API Support

• Pivot Tables
• Slicers

 

Specification and Standards

• • ECMA-376 5th edition OpenXml
  • [MS-XLS]: Excel Binary File Format (.xls) Structure
  • [MS-XLSB]: Excel (.xlsb) Binary File Format
  • [MS-XLSX]: Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format
  • [MS-ODRAW]: Office Drawing Binary File Format
  • [MS-ODRAWXML]: Office Drawing Extensions to Office Open XML Structure
  • [MS-OGRAPH]: Office Graph Binary File Format
  • [MS-OSHARED]: Office Common Data Types and Objects Structures
  • [MS-OVBA]: Office VBA File Format Structure 

• [MS-OFORMS]: Office Forms Binary File Formats (1.0)