Spire.XLS for .NET            Excel 應用工具

Spire.XLS for .NET is a professional Excel .NET component that can be linked into any type of .NET 2.0, 3.5 or 4.0 project, either ASP.NET web sites or Windows Forms application. Spire.XLS for .NET offers a combination of APIs and GUI controls for speeding up Excel programming in .NET platform-create new Excel documents from scratch, edit existing Excel documents and convert Excel files.

This Professional .NET Excel component is a standalone Excel .NET managed assembly and does not depend on Microsoft Office Excel. Spire.XLS for .NET offers support both for the old Excel 97-2003 format (.xls) and for the new Excel 2007 and Excel 2010 (.xlsx) format. It features fast and reliable compared to developing your own spreadsheet manipulation solution or using Microsoft Automation.

Spire.XLS for .NET enjoys good reputation in either enterprise or individual customers. These customer types include Banks, Data processing houses, Educational institutions, Government organizations, Insurance firms, Legal institutions, Postal/cargo services and etc.

Difference between Standard and Pro Edition
The Difference between Standard and Pro Edition lies in the feature of File Conversion: Pro Edition supports converting files from Excel to PDF, HTML, Excel to CSV, Excel to Text, Excel to Image and Excel to XML(the Excel can be either .xls or .xlsx); while the Standard edition doesn't support.

Platforms:
Spire.XLS for .NET enables developers/programmers to build ASP.NET, Web Services, WinForms or any other type of application for any .NET Framework version from 2.0 to 4.0. Full support for 32-bit and 64-bit system.

File Format Supports:
Spire.XLS for .NET supports lots of file formats.
Spire.XLS for .NET offers support both for the old Excel 97-2003

    format (.xls) and for the new Excel 2007 and Excel 2010 (.xlsx)

    format.
Save as HTML is available.
Load and save documents in the tab delimited file format.
Comprehensive support of the CSV format to interact with a variety of

   applications.
Easily extract text by saving in plain text format.
Conversion:
Spire.XLS for .NET has powerful conversion ability and it enables converting Excel files to most common and popular formats.
Excel to HTML/XML/CSV
XML/CSV to Excel
Excel to Image
Excel to Text
Excel to PDF
Contents Features:
Spire.XLS for .NET offers a wide range of features and the main features are listed as below:
Create and Edit Excel
Find and Search Data
Import/Export data from a DataTable, DataView, Array, DataGrid etc.
Save Excel to file/Stream or as web response
Create charts
Read and write hyperlinks
Create auto filters
Implement Data Sorting
Implement Data Validations
Merge / Unmerge Cells
Group / UnGroup Rows and Columns
Insert / Delete or Hide Rows, Columns and Sheets
Calculate Complex Excel Formulae
Freeze / Unfreeze Panes
Insert Hyperlinks to link data
Protect / Unprotect Worksheets
Create Pivot Tables
Encrypt/Decrypt Files
Load/Save Excel VBA
Merge data into Excel with MakerDesigner
Formatting Features:
Spire.XLS for .NET provides detailed programmatic access to formatting properties of all spreadsheet elements.
Apply all characters formatting in the cells including fonts, colors,

   effects, borders and shading.
Apply all the Number Format Settings (supported in MS Excel) for the

   cells.
Set all types of Text Alignment settings.
Apply different kinds of Font Settings for the cells.
Apply different Colors to Cells, Fonts, Gridlines, Graphic objects etc.
Apply different Rich Text formatting in a single cell.
Apply different Border Settings on cells.
Apply different Background Patterns on cells.
Apply gradient Background Patterns on cells.
Apply Format Settings on a Worksheet, Row, Column or a range of

   cells etc.
Page Setup Features:
Spire.XLS for .NET enables developers/programmers to set PageSetup options.
Adjust your page orientation, scaling, paper size.
Specify your margins and page centering.
Create or edit your header and/or footer with image.
Set print area, print titles, or turn on gridlines etc
Managing Page Breaks