EasyXLS

EasyXLS Basics

EasyXLS library comes with the following basic features that covers most of the MS Excel features and many more. Each feature is documented and tutorials in various programming languages are included. Choose a feature from below list:
  • Create an Excel document
    How to create an Excel file with two sheets in various programming languages
  • Import files
    How to import data from various Excel file formats (XLSX, XLSM, XLSB, XLS or XML Spreadsheet), various text file formats (XML, CSV, TXT or HTML) or into various data structures (DataSet, ResultSet or List)
  • Export files
    How to export data to various Excel file formats (XLSX, XLSM, XLSB, XLS or XML Spreadsheet), various text file formats (XML, CSV, TXT or HTML) or various data structures (DataSet, ResultSet or List)
  • Convert files
    How to convert between Excel file formats (XLSX, XLSM, XLSB, XLS or XML Spreadsheet) or Excel file format and text file formats (XML, CSV, TXT or HTML)
  • Sheets
    How to add sheets to Excel file and set various properties for the sheet
  • Adressing cells
    How to add data in cells, strings, numeric values, dates, boolean values, formulas and how to calculate the formulas from the sheets
  • Cell formatting
    How to format cells, columns and rows, merge cells, set rich text format in cells, set column width and row height, apply auto-format and conditional formatting, set formatting theme for the Excel file
  • Cell comments
    How to use comments on Excel cells
  • Hyperlinks
    How to use hyperlinks to a website, mail, file or cell
  • Images
    How to export or import images from Excel file
  • Named ranges and formulas
    How to use named ranges or named formulas
  • Data validation
    How to use data validation on Excel cell ranges
  • Page setup and print settings
    How to setup page properties when the Excel file is printed, header, footer and page breaks
  • Macros and VBA project
    How to include macros or VBA code into Excel file
  • Groups and outline levels
    How to group data from rows or columns on different levels
  • Freeze and split panes
    How to split panes and freeze rows or columns in Excel sheet
  • Filter and autofilter
    How to use filters for data in Excel sheet
  • Charts
    How to use charts in a worksheet or in a chart sheet and set the formatting for the chart
  • Pivot tables and pivot charts
    How to use pivot tables and pivot charts for Excel sheet
  • Security and protection
    How to secure Excel file by protecting sheet data, encrypt file and set a password for opening the file
  • Document properties
    How to set document summary information and custom properties for Excel file
Go to top

EasyXLS Excel libraries:

.NET
.NET Excel Library
full .NET version to import, export or convert Excel files
COM+ Excel Component
full COM+ version to import, export or convert Excel files
-
Java
Java Excel Library
full Java version to import, export or convert Excel files
Download EasyXLS™ Excel Library for .NET

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019
XLSX XLSM XLSB XLS
XML HTML CSV TXT