Reply to topic  [ 1 post ] 
EasyXLS Library Features v8.6 
Author Message

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 197
Location: Brasov, Romania
Reply with quote
Post EasyXLS Library Features v8.6

FeatureDescriptionAvailable for
Cell values
  • Strings
  • Numbers
  • Dates
  • Booleans
  • Formulas
  • Errors
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer, EasyXLS Express Excel Writer
Formulas
  • All functions supported by Excel
  • Arithmetic, logical and unary operators
  • Formulas with numbers, dates and strings
  • Formulas with cell references
  • Formulas with cell ranges
  • Formulas with named ranges
  • Formulas with arrays
  • Formulas in A1 or R1C1 reference style
  • Formulas with references to external documents
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer, EasyXLS Express Excel Writer
Formula computation engine
  • Formula computation engine is available
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Worksheets
  • Title
  • Worksheet can be selected
  • Worksheet can be protected
  • Worksheet can be hidden
  • Zoom
  • Tab color
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Chart sheets
  • Title
  • Chart sheet can be selected
  • Chart sheet can be protected
  • Chart sheet can be hidden
  • Zoom
  • Tab color
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Format cells
  • Format a cell, a row, a column or a specified range
  • Number format - all text, number and date formats supported by Excel are available
  • Alignment vertical & horizontal alignment, wrap & shrink text
  • Indent
  • Text direction
  • Text rotation
  • Font font name, font size, color, bold, italic, underline, strikethrough, superscript & subscript
  • Border style and color
  • Background & foreground
  • Pattern
  • Gradient fill
  • Protection locked & hidden
  • Merged cells
  • Rich text format
  • Themes
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer, EasyXLS Express Excel Writer
Auto-formats
  • Default Excel auto-formats
  • Custom auto-formats
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer, EasyXLS Express Excel Writer
Conditional Formatting
  • Conditional formatting for a range
  • Font - color, bold, italic, underline, strikethrough
  • Border - style and color
  • Background & foreground
  • Themes
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Hyperlinks
  • URL's
  • Files
  • Cell references
  • Named ranges
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Comments
  • Font name, font size, bold, italic, underline
  • Foreground
  • Location
  • Rich text format
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Images
  • JPEG, GIF, PNG, WMF, EMF, BMP, TIFF images
  • Image file path
  • Location
  • Extract image bytes from an Excel document
Note: xls file format supports only JPEG images
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Names
  • Title
  • Formula
  • Hidden
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Data validation
  • Data entered in a cell can be restricted to certain values
  • Input message and error alert can be set
  • Drop-down controls to select the allowable values for a cell are available
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Header & footer
  • Position left, center and right side
  • Font font name, font size, underline, strikethrough, superscript, subscript
  • Predefined texts: page number, total number of pages, date and time, file name
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Page Setup
  • Set page orientation (portrait, landscape), paper size
  • Set scaling factor, fit to pages width/height
  • Set paper margins
  • Set print area
  • Set rows to be repeated at top, columns to be repeated at left
  • Print order
  • Print gridlines, print black and white, print draft quality, print row and column headings, print comments
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Page breaks
  • Horizontal and vertical page breaks
  • Allows displaying the file in page break preview mode
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Row & column dimension
  • Row height & column width can be set for the grid
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Group and outline levels
  • Group the rows and the columns. Multiple and embedded outline levels are available.
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Split and freeze panes
  • Split window views
  • Freeze rows and columns
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Filter and AutoFilter
  • Auto-filter
  • Advanced filter
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Chart objects
  • All chart types and chart formats supported by Excel are available
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Pivot tables
  • Pivot table options: Layout&Format, Totals&Filters, Display, Printing, Data
  • Fields and their settings
  • Row labels
  • Column labels
  • Report filter
  • Value fields and their settings
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Pivot tables
  • Pivot charts can be created based on a pivot table. All the features presented for charts are available also for pivot charts.
Encryption & password protection
  • Password protection for the workbook
  • Password to open and password to modify MS Excel documents
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer, EasyXLS Express Excel Writer
File properties
  • Document summary properties
  • Custom properties
EasyXLS Professional Excel Library, EasyXLS Excel Reader, EasyXLS Excel Writer
Read as SQL result set
  • Read the sheet values of an XLS document (Office 97-2003)
  • Read the active sheet values of an XLS document (Office 97-2003)
  • Read the sheet values of an XLSX document (Office 2007)
  • Read the active sheet values of an XLSX document (Office 2007)
  • Read the sheet values of an XLSB document (Office 2007)
  • Read the active sheet values of an XLSB document (Office 2007)
  • Read the values from a TXT file
  • Read the values from a CSV file
  • Read the values from an XML file
EasyXLS Professional Excel Library, EasyXLS Excel Reader
Save as
  • XLS document (Office 97-2003)
  • XLSX document (Office 2007)
  • XLSB document (Office 2007)
  • TXT file
  • CVS file
  • XML file
  • HTML file
EasyXLS Professional Excel Library, EasyXLS Excel Writer, EasyXLS Express Excel Writer
Load
  • An XLS document (Office 97-2003)
  • An XLSX document (Office 2007)
  • An XLSB document (Office 2007)
  • A TXT file
  • A CSV file
  • An XML file
  • An HTML file
EasyXLS Professional Excel Library, EasyXLS Excel Reader
Import/Export
  • SQL result sets
  • XML files
  • TXT files
  • CSV files
  • HTML files
  • Custom lists
EasyXLS Professional Excel Library, EasyXLS Excel Reader (only export), EasyXLS Excel Writer (only import), EasyXLS Express Excel Writer (only SQL and custom lists)
VB and macros
  • Preserve the macros when load/edit/write XLS, XLSX and XLSB files
EasyXLS Professional Excel Library

_________________
EasyXLS Team
.NET and Java library to read and write Excel files
Facebook X Reddit LinkedIn


Fri Jan 19, 2018 6:50 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 1 post ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.