|
Essential XlsIO 2008 Vol 2
A Document Generator Control/Component for .Net, ASP.Net
Essential XlsIO is a .NET library that can read and write Microsoft Excel files (BIFF 8 format). It features a full fledged object model just like the Microsoft Office COM libraries. It does not use COM interop and is built from scratch in C#. It can be used on systems that do not have Microsoft Excel installed, making it an excellent report engine for tabular data.
For more information about this product please visit the
Quick Overview
Provides a quick overview of the functionalities of excel. The potential usage of XlsIO has been classified under the four categories
SpreadsheetFromScratch
ExtractDataFromSpreadsheet
SpreadsheetFromTemplate
EditSpreadsheet
Formatting
This sections explains the formatting capabilities of Essential XlsIO.
AlignmentSettings
BorderSettings
FontSettings
GlobalStyles
NumberFormatting
PatternSettings
ColorPalette
Formulas
Essential XlsIO has advanced support for working with Formula.
ArrayFormula
ExcelFunctions
ReadFormula
CalculationEngine
The formulas entered during runtime can be computed using Essential Calculate and XlsIO.
XlsIOCalcEngine
Data Manipulation
Essential XlsIO has advanced support for working with Data in a worksheet. Here are some key functionalities that make working with data easier.
NamedRanges
ImportExportDataTable
RangeManipulation
Worksheet Manipulation
Essential XlsIO has advanced support for manipulating the worksheet.
AutofitRowsandColumns
CopyWorksheetToAnotherWorkbook
Freezepane
GroupUngroupRowsandColumns
HideUnhideRowsandColumns
InsertRowsandColumns
PageBreak
RowHeightandColumnWidth
Comments
Essential XlsIO has API's for reading and writing comments in a worksheet.
ReadComments
WriteComments
Rich Text
Essential XlsIO has advanced API support for working with Rich Text in cells.
ReadRichText
WriteRichText
Working With Images
Essential XlsIO has advanced API support for working with Images.
Read Image
Write Images
Charts
Essential XlsIO has advanced support for creating and modifying Excel charts inside a workbook. There is an option to choose between creating a chart as an embedded chart .
ChartWorksheet
EditCharts
EmbeddedChart
PreserveTemplateChartProperties
Auto filters
Essential XlsIO has API's for writing Autofilters in a worksheet.
Write Autofilters
Data Validation
Essential XlsIO has API's for reading and writing DataValidation in a worksheet.
ReadDataValidation
WriteDataValidation
Conditional Formatting
Essential XlsIO has API's for reading and writing Conditional Formatting in a worksheet.
Read Conditional Formatting
Write Conditional Formatting
Diagrams
Essential XlsIO has support for working with template spreadsheets that contain diagrams.
DiagramsInTemplate
VBA Macros
Essential XlsIO has support for working with template spreadsheets that contain macros.
VBAInTemplate
Security
Essential XlsIO has support for setting the worksheet security settings.
CellsProtection
Unlocking
Worksheet Protection
Streams Support
Essential XlsIO can working with spreadsheets that are stored as streams and can also save to a stream.
Open From Stream
SaveToStream
Spreadsheet Property Settings
Essential XlsIO has support for reading and writing the spreadsheet properties.
Document Properties
HeaderFooter
Margins
Page SetUp
Hyperlinks
Essential XlsIO has support for reading and writing hyperlinks in cells.
ReadHyperlinks
WriteHyperlinks
Technical Information
Component Type - Contains the following types of components...
|
• .Net Class Library
|
|
• ASP.Net Web Control
|
|
|
|
For more information and to buy this product...
Product Type:
Control/Component
Product Version:
2008 Vol 2
Prices From:
$495
|
