• Overview

    Spire.XLS for Silverlight is a professional component to operate Excel on Silverlight platform. As a powerful Silverlight Excel component, it enables developers/programmers to freely generate, read, write and modify Excel files.

    Without Microsoft Office Automation, Spire.XLS for Silverlight can help users realize Excel functions, including basic operation on Excel, Formatting, File Protection, Data importation/Exportation, Contents Inserting, Mark Designer etc.

    Spire.XLS for Silverlight supports Excel 97-2003, Excel 2007 and Excel 2010. However, Silverlight 3.0 or Silverlight 4.0 should be installed for using Spire.XLS for Silverlight.

    New Release - Version 6.8.5
    •Access violation exception caused by allocating not enough buffer during calling the method LoadFromFile.-Fixed

    Main Functions

    Basic Operation
    Spire.XLS for Silverlight enables users to create and read workbook, edit existed worksheet, save to stream/web response, set page and file properties, copy data, merge cells etc.
    Format Cells
    Spire.XLS for Silverlight enables users to format cells, including data format, text alignment, font style and color, cell background color, borders etc.
    File Protection
    Spire.XLS for Silverlight enables users to encrypt Excel workbook, lock worksheet and cells. Also, it can decrypt workbook, unlock worksheet and cell.
    Data Importation/Exportation
    Spire.XLS for Silverlight enables users to import data from datatable to workbook and export data from workbook to datatable.
    Contents Inserting
    Spire.XLS for Silverlight enables users to insert internal and external contents in Excel. User can insert Formulas (all 531 entries supported), Charts (all 74 types Supported), Pivot Table, Comments, VBA, TextBox, Image, Hyperlink etc.
    Marker Designer
    Spire.XLS for Silverlight enables users to use mark designer in Excel. Before using mark designer, template with formatting is necessary.

    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 Silverlight Platform

    High Performance
    high performance for generating Excel documents with huge number columns and rows. Superior performance support for reading and writing spreadsheet.