Spire.XLS for .NET is a professional Excel .NET component that can be used to any type of .NET 2.0, 3.5, 4.0 or 4.5 framework application, both ASP.NET web sites and Windows Forms application. Spire.XLS for .NET offers object model Excel API for speeding up Excel programming in .NET platform - create new Excel documents from template, 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,Excel 2010 and Excel 2013 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) format. It features fast and reliably compared to developing your own spreadsheet manipulation solution or using Microsoft Automation.
Spire.XLS for .NET enjoys good reputation in both enterprise and individual customers. These customer types include Banks, Data processing houses, Educational institutions, Government organizations, Insurance firms, Legal institutions, Postal/cargo services and etc.
The Differences between Standard and Pro Edition lie in the feature of Print function and File Conversion: Pro Edition supports converting files from Excel to PDF, Excel to HTML, Excel to CSV, Excel to Text, Excel to Image, Excel to XML(the Excel can be .xls, .xlsx and .xlsb) and Excel to XPS;
Unlike Pro Edition, the Standard Edition doesn't support print or conversion of any kind mentioned above.
MainFunctions100% Standalone .NET Component - No Microsoft Office AutomationSpire.XLS for .NET is a 100% standalone Excel .NET component that allows developers to create, manage and manipulate Excel spreadsheets without requiring Microsoft Excel or Microsoft Office to be installed on the system. In addition, Spire.XLS for .NET is a better alternative to Office Automation in terms of security, stability, scalability, speed, price and features.Spire.XLS for .NET supports converting files from Excel to PDF, Excel to HTML, Excel to CSV, Excel to Text, Excel to Image, Excel to XML and Excel to XPS. And on the other hand, most of popular files can be transferred to Excel back.Spire.XLS for .NET enables developers to generate Excel workbook from scratch, or load a workbook from either folder or file stream. Developers can also save it to file, file stream or web response. Spire.XLS for .NET offers a wide range of security features including Excel encryption/decryption, cell hide/unhide, worksheet lock/unlock.Spire.XLS for .NET enables developers to create, add, delete, rename, edit and move worksheet in either C#, VB.NET or ASP.NET. Developers can also copy, transpose, and consolidate across worksheets with full contents. This professional Excel .NET class library also embeds many flexible options for displaying worksheets, such as page breaks, zoom-setting, freeze panes, headers/footers, Print excel files, print paper size and print area etc.Developers can easily manipulate Excel cells and Evaluate formula value in C#, VB.NET or ASP.NET at runtime. Super-fast, scalable excel calculation engine is compatible with the 97-2003/2007/2010 Excel. Cell Styles are supported by this Excel .NET component, such as cell merging/unmerging, text wrapping/unwrapping, text alignment, rotation, interior, borders, lock/unlock and etc. Font formats, like setting font type, size, color, bold, italic, strikeout and underlining etc. is also fully supported. Conditional formatting, text search and replace, filter and data validation can be applied to cells as easily as you expect.Spire.XLS for .NET provides a wide range of Chart: Pie Chart, Bar Chart, Column Chart, Line Chart, Radar Chart and etc. This Excel .NET component also supports data transportation between database and Excel in C# VB.NET or ASP.NET. Hyperlinks and templates are also supported by Spire.XLS for .NET.
High PerformanceHigh performance for generating Excel documents with huge number columns and rows. Superior performance for reading and writing spreadsheet.
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.5. Full support for 32-bit and 64-bit system.
File Format SupportsSpire.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,Excel 2010 and Excel 2013 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) 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.
ConversionSpire.XLS for .NET has powerful conversion ability and it enables converting Excel files to most common and popular formats.
Contents FeaturesSpire.XLS for .NET offers a wide range of features and the main features are listed as below:
- Create and Edit Excel
- Find and Replace Data
- Print excel files
- 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 and files
- Group/UnGroup Rows and Columns
- Insert/Delete or Hide Rows, Columns and Sheets
- Calculate Complex Excel Formula
- 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 MarkerDesigner
Formatting FeaturesSpire.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, fill 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 FeaturesSpire.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
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
Excel to PDF Excel to HTML Excel to Image Excel to XPS Excel Chart Marker Designer Data Import/Export Runtime Excel Calculation Excel Pivot Table Request free customized demo just for you.
High Quality ConversionConvert Excel to PDFTutorials / Live Demo / Orginial Excel and PDF file
Convert Excel to HTMLTutorials / Live Demo / Orginial Excel and HTML file
Convert Excel to ImageTutorials / Orginial Excel and Image file
Convert Excel to XPSTutorials / Orginial Excel and XPS file
Excel ChartExcel ChartTutorials / Live Demo / C# Code
Marker DesignerMarker DesignerTutorials / Live Demo / C# Code
Data Import/ExportImport Excel from DataTableTutorials / Live Demo / C# Code
Export Excel to DataTableTutorials / Live Demo / C# Code
Runtime Excel CalculationRuntime Excel CalculationTutorials / Live Demo / C# Code
Create Excel Pivot TableCreate Excel Pivot TableTutorials / Live Demo / C# Code
GuidelineBeginners Guide is the first step towards learning the basic information of Spire.XLS for .NETMain Functions contain the main features of our Spire.XLS for .NET and you can have brief information of it.
Program Guide lists the detailed features of our Spire.XLS for .NET and you can search for the information you want.The Videos give an operation guide by video. You can check the produce step by step.
- Convert Excel to PDF
- Convert Excel to HTML
- Excel Reporting - Workbook Marker Designer
- Excel Pivot Table
- Merge Excel Cells
SupportFrequently asked question for Spire.XLS of technical and function issues.We guarantee one business day Forum questions Reply.We guarantee one business day E-mail response.Free Customized service for OEM Users.Skype account: iceblue-supportTo ensure our products to be easier to use, we offer free customized demos to our customers. Please contact firstname.lastname@example.org for the free demo. Make sure the demo you want meets the below requirements.
If you have tried out Spire.XLS and found it useful, please consider sharing your experience with others. By sharing your testimonial with us, you will not only help others to make the right decision but will also to earn rewards from us. Please send your testimonials to email@example.com.
- It relates to our components stored on E-iceblue online store.
- It costs less than 2 hours for us to complete it. If it costs more than 2 hours, please contact our firstname.lastname@example.org