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