Aspose.Cells .NET for NPOI

Project Aspose.Cells for NPOI (HSSF and XSSF) shows how different tasks can be performed using Aspose.Cells .NET APIs in comparison with NPOI. The project also covers the features that are only available in Aspose.Cells APIs but not in NPOI for dealing with Microsoft Excel files or OpenOffice Spreadsheets.

This project is helpful for developers who want to compare NPOI with Aspose.Cells OR migrate from NPOI to Aspose.Cells.

Getting Started

Introduction

Why Aspose for NPOI (HSSF and XSSF)?

The developers looking for file format APIs may need to walk through the features provided by the APIs available on the market. Mostly following factors are considered when choosing an option:

  • Features
  • Efforts required to use the API
  • Comparison between libraries to determine which is better

If you are a .NET developer looking to choose a file format API to process files, you may want to compare NPOI with Aspose.

Project Aspose.Cells for NPOI (HSSF and XSSF) shows how different tasks can be performed using Aspose.Cells .NET APIs in comparison with NPOI. The project also covers the features that are only available in Aspose.Cells APIs but not in NPOI for dealing with word processing documents.

This project is helpful for developers who want to compare NPOI with Aspose.Cells OR migrate from NPOI to Aspose.Cells.

What’s NPOI

NPOI is the .NET version of POI Java project at http://poi.apache.org/. POI is an open source project which can help you read/write XLS, DOC, PPT files.

Read more at https://npoi.codeplex.com/

What’s HSSF and XSSF

HSSF is the POI Project’s pure Java implementation of the Excel ‘97(-2007) file format.

XSSF is the POI Project’s pure Java implementation of the Excel 2007 OOXML (.xlsx) file format.

HSSF and XSSF provides ways to read spreadsheets create, modify, read and write XLS spreadsheets. They provide:

  • low level structures for those with special needs
  • an eventmodel api for efficient read-only access
  • a full usermodel api for creating, reading and modifying XLS files

Read more at poi.apache.org

Aspose.Cells for .NET

Aspose.Cells for .NET provides the most flexible group of components that enable .NET applications to create, modify, convert, render and print Excel® spreadsheets without requiring Microsoft Excel® to be installed on the server.

Aspose.Cells for .NET supports all the major Microsoft Excel and other file formats including XLS, XLSX, XLSM, XLTX/XLTM, HTML, CSV, ODS, Tab Delimited, SpreadsheetML and PDF, etc.

Read more at this link.

System Requirements and Supported Platforms

System Requirements

Aspose.Cells for NPOI examples can be tested and run on any system that have Visual Studio 2010 or above installed.

Supported Platforms

You can use any of the following Visual Studio versions to use test and explore these examples

  • Visual Studio 2010
  • Visual Studio 2012
  • Visual Studio 2013

Downloading and Installing

Downloading

You can download latest version for Aspose.Cells for .NET from

You can download Aspose for NPOI from one of the following locations

Installing

It is very simple to start testing and exploring these examples, please follow these simple steps

Release package

If you have downloaded the release package from GitHub or Codeplex then each example is provided as a separate zip file.

  1. Extract the required zip file
  2. Double click on the project file to open it in Visual Studio
  3. In order to ensure that you use the latest version with latest features we have not provided Aspose.Cells dll with source code or package therefore please add reference to Aspose.Cells.dll to your projects.
  4. Click Debug on Visual Studio toolbar or F5 to run the example.

Source code

  1. Depending upon your Visual Studio version, double click on one of the solution files
    1. Aspose.Cells.Examples.2010.sln
    2. Aspose.Cells.Examples.2012.sln
    3. Aspose.Cells.Examples.2013.sln
  2. In order to ensure that you use the latest version with latest features we have not provided Aspose.Cells dll with source code or package therefore please add reference to Aspose.Cells.dll to your projects.
  3. One the solution is opened you can run any project by selecting the project and hitting F5.
  4. The output document is saved in your Bin -> Debug folder for each project respectively.

Using

How to apply Aspose License?

This Plugin uses an evaluation version of Aspose.Words. Once you are happy with your evaluation, you can purchase a license at the Aspose Purchase Website. To remove evaluation message and feature limitations, product license should be applied. You will receive a license file after you have purchased the product. Please follow the steps below to apply the license

  • Make sure the license file is named as Aspose.Cells.lic
  • Place Aspose.Cells.lic file in Bin/Debug/ folder of your project website e.g. “project website Folder/Bin/Debug/Aspose.Cells.lic”

Support, Extend and Contribute

Support

From the very first days of Aspose, we knew that just giving our customers good products would not be enough. We also needed to deliver good service. We are developers ourselves and understand how frustrating it is when a technical issue or a quirk in the software stops you from doing what you need to do. We’re here to solve problems, not create them.

This is why we offer free support. Anyone who uses our product, whether they have bought them or are using an evaluation, deserves our full attention and respect.

You can log any issues or suggestions related to this control using any of the following platforms

Extend and Contribute

Aspose for NPOI is open source and its source code is available on the major social coding websites listed below. Developers are encouraged to download the source code and extend the functionality as per their own requirements.

Source Code

You can get the latest source code from one of the following locations

How to configure the source code

You need to have the following installed in order to open and extend the source code

  • Visual Studio 2010
  • Visual Studio 2012
  • Visual Studio 2013

Please follow these simple steps to get started

  1. Download/Clone the source code.
  2. Open Visual Studio 2010, 2012 or 2013 and Choose File > Open Project

Browse to the latest source code that you have downloaded and depending upon your Visual Studio version, double click on one of the solution files

  1. Aspose.Cells Vs NPOI HWPF and XWPF v1.3 - 2010.sln
  2. Aspose.Cells Vs NPOI HWPF and XWPF v1.3 - 2012.sln
  3. Aspose.Cells Vs NPOI HWPF and XWPF v1.3 - 2013.sln

Source code overview

In the initial version there are following projects created for compassion features

  • Add Comment In a Cell
  • AutoFitColumns
  • FreezePanesInExcel
  • HidingRowsandColumns
  • SplitCellsInExcel

Sample Code Examples

This section includes the following topics