Abstract

In this article, I am going to share my hands-on with Spire.XLS for .NET by E-ICEBLUE. This article is from one of my projects requirement where we need to create a dynamic reports of certain data captured/entered in Excel spreadsheets.  I did lot of research for the same and finally, I found E-ICEBLUE’s Spire.XLS

Introduction

In this article, we will see how to setup/start with a great .NET standalone component i.e Spire.XLS by E-ICEBLUE. This article is a very first step of a series of articles where we will learn how to play with Spire.XLS.

Through-out the series of these articles we will see how to create Excel files using Spire.XLS component. All the examples are written with code snippet and moreover, you will find a demo app source code.

 

What is Spire.XLS?

First words in my mind, what is all about Spire.XLS, I did a research and found that Spre.XLS is a component for .Net by E-ICEBLUE. At the time of this article I found that we can use this component with any .Net application viz. ASP.Net windows or web both. It supports .NET 2.0, 3.5, 4.0 and 4.5 (I did not verify with later editions of .NET)J

The important thing is that Spire.XLS is standalone .NET managed component. This is a managed so we do not need to do special things to dispose the object as CLR will handle in its own wayJ. Amazing thing is this component supports both Microsoft Office Excel [Excel97-203, Excel 2003, Excel 2007, and Excel 2010] and Open office.

Is Spire.XLS free?

Yes, there is a Free Edition available of Spire.XLS. Anyone can play with the functionality and taste the flavor of this great component.

Where do I find Spire.XLS?

Spire.XLS is available for download at its official website: E-ICEBLUE. It comes with following flavors:

Free edition

This is a community edition and is absolutely free anyone can download its without any cost. It means this version is absolutely free. It provides the facility to create / manipulate any .Net excel files.

Please note that free version is having some limitation:

• Not more than 5-sheets per workbook
• Not more than 150 rows per sheet
• Conversion provides only first 3-pages while converting Excel files to HTML/XML, Excel to Text, Excel to PDF etc.

Pro Edition

You can get Pro Edition of Spire.XLS with amount of US$799.00 per unit.  Great thing is that Pro Edition comes with 14-days money back guarantee so, purchasing of Pro Edition via Pay Pall is very easy and secure.

In this edition you will get new fixes and pre-support absolutely free upto one year. More great news is that E-ICEBLUE provides a great discount on renewal of its product:

 

• If licensed is yet not expired – 40% off
• If licensed expired – 25% off

 

Standard Edition

You can get Standard Edition of Spire.XLS with amount of US$599.00 per unit.  Great thing is that Pro Edition comes with 14-days money back guarantee so, purchasing of Standard Edition via Pay Pall is very easy and secure.

In this edition you will get new fixes and pre-support absolutely free upto one year. More great news is that E-ICEBLUE provides a great discount on renewal of its product:

 

• If licensed is yet not expired – 40% off
• If licensed expired – 25% off

Refer to updated prices at: http://www.e-iceblue.com/Buy/Spire.XLS.html

 

How to download/install Spire.XLS?

It is very easy to download the assemblies for your .NET project. Follow these steps:

Login or register with: E-Iceblue

Follow the instructions.

Go to you desired component page: http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html#.VHG36nkcTIU

Click on download:

Click on Direct link in case there is any problem with your download:

This is all. Now, just go to your download location, unzip and then double click on MSI package. It will install Spire.XLS component on your system.

 

Click on Next from Welcome Screen

Access License agreement by clicking on I Accept checkbox

Select install location and features

Click Install to start installation

Progress Installation

Click on Finish to complete installation

Spire.XLS functionalities at a glance

Spire.XLS is propelled with lot of functionality few are discussed here:

• This is a standalone .NET component
• This is a managed .NET component so no need to apply special things to dispose objects during your developments
• It supports conversions, you can convert Excel files to PDF, HTML, CSV, Image, XML etc.
• It provides facility to generate automated reports or you can import the data
• It provides CRUD operations eg. .NET developers can play with Create/add, delete, rename, edit operations.
• It provides run-time facility where we can make math calculation at the run time dynamically.
• It provides the facility to create charts (there are lot of charts available).

Conclusion

In this article we get an idea how to start / setup Spire.XLS – a .NET component by E-Iceblue. In coming articles we will take a look into its different functionalities with some hands-on simple code snippet. Till then enjoy and happy coding with Spire.XLS J