|
|
Spire.XLS is a professional Excel component which enables developers/programmers to fast generate, read, write and modify Excel document for .NET and Silverlight. It supports C#, VB.NET, ASP.NET, ASP.NET MVC and Silverlight.
Spire.XLS doesn't need Microsoft Office Excel Automation. It allows user to operate Excel document directly such as save to stream, save as web response, copy, lock/unlock worksheet, set up workbook properties, etc. As a professional .NET Excel component, it owns the ability of inserting content into Excel document, formatting cells and converting Excel documents to popular office file formats. Spire.XLS for .NET supports Excel 97-2003, Excel 2007 and Excel 2010.
Note: Standard Edition doesn't support Silverlight
New Release - Version 6.6.
When save a Workbook with Charts as Excel 2007 or Excel 2010, the charts will be lost when open the Workbook. - Fixed
New Features
Silverlight platform supported
Enable to Load PageBreaks and WorksheeOptions.ShowPageBreakZoom in Excel 2003 XML file
Enable to Write PageBreaks and ShowPageBreakZoom into Excel 2003 XML file
Added ZoomScaleNormal, ZoomScalePageBreakView and ZoomScalePageLayoutView in Worksheet
Support loading/writing ZoomScaleNormal and ZoomScalePageBreakView in Excel 2003
Support loading/writing ZoomScaleNormal and ZoomScalePageBreakView in Excel 2003 XML file
Support loading/writing ZoomScaleNormal, ZoomScalePageBreakView and ZoomScalePageLayoutView in Excel 2007/2010
Enable to load viewMode in Excel 2003
Support writing viewMode into Excel 2003
Main Functions
Directly Operate Excel Document
Without Microsoft Excel installed on system, users can use Spire.XLS for .NET to create new workbook, edit exist worksheet, save to stream/web response, set up properties, worksheet print set up, cells merge, copy, etc. Furthermore, Spire.XLS for .NET also enables users to lock or unlock worksheet.
Import/Export
Spire.XLS for .NET supports importing data from datatable to spreadsheet and exporting data from spreadsheet to datatable.
Format Cells
Spire.XLS for .NET has powerful functions on cells formatting. It allows you to Format number, Text Alignment, Font, Cell Border, Cell Fill, Cell Protection, Interior, etc.
Insert Content to Excel Document
Conversion - Only for .NET
Spire.XLS for .NET supports converting files from Excel to PDF, Excel to HTML, Excel to CSV, Excel to Text, Excel to Image and Excel to XML. And on the other hand, most of popular files can be transferred to Excel. Spire.XLS for .NET can transfer XML to Excel, CSV to Excel and insert images into Excel.
Marker designer including Template, Auto Populate, Style Copy and Variables are also available for Spire.XLS for .NET
Feature Details
| Support |
Excel97~2003 |
Excel2007 |
Excel2010 |
| Operation |
Create New Workbook |
Edit Existing Workbook |
| Save to file |
Save to stream |
Save as web response |
| Workbook Properties Setup |
Worksheet Print Setup |
| Worksheet Copy |
Cells Data Copy |
Cells Styles Copy |
Cells Merge |
| Lock Worksheet |
Unlock Worksheet |
| Data Table Import |
Data Table Export |
| Freezepane |
Group |
| Filter |
Data Validation |
| Marker Designer |
Template |
Auto Populate |
Style Copy |
Variables |
| Format Cells |
Number Format |
Text Alignment |
Font |
| Cell Border |
Cell Fill |
Cell Protection |
Interior |
| Content |
Formula (all 531 entries supported) |
Chart (all 74 types supported) |
| Image |
Pivot Table |
RichText |
| Hyperlink |
Comments |
VBA |
| Convert |
XML |
HTML |
Image |
CSV |
Text |
|
Not supported in Standard Edition |
High Performance
high performance for generating Excel documents with huge number columns and rows. Superior performance support for reading and writing spreadsheet.
|