Npoi Use manual

Directory

1. Knowledge of Npoi

2. Use Npoi to generate XLS files

2.1 Creating Basic Content

2.1.1 Create workbook and sheet

2.1.2 Create Documentsummaryinformation and SummaryInformation

2.1.3 Create cells

2.1.5 Create annotations

2.1.6 Create headers and footers

2.2 Cell operations

2.2.1 Formatting

2.2.2 Merged cells

2.2.3 Alignment Related Settings

2.2.4 using borders

2.2.5 font settings

2.2.6 Background and textures

2.2.7 Set width and height

2.3 Using Excel Formulas

2.3.1 Basic Calculation

2.3.2 Sum function

2.3.3 Date function

2.3.4 String Correlation function

2.3.5 if function

2.3.6 Countif and SUMIF functions

2.3.7 Lookup function

2.3.8 Random number function

2.3.9 get the return value of the formula by Npoi

2.4 Creating graphics

2.4.1 Drawing Line

2.4.2 Draw a rectangle

2.4.3 Draw a circle

2.4.4 painting grid

2.4.5 Insert Picture

2.5 Printing Related Settings

2.6 Advanced Features

2.6.1 Adjust Form display scale

2.6.2 Set Password

2.6.3 Combined rows, columns

2.6.4 Lock Column

2.6.5 Show/Hide Gridlines

2.6.6 sets the row and column of the initial view

2.6.7 Data Availability

2.6.8 to generate a drop-down menu

3. Project Practice

3.1 Generating Excel files based on the. xls template

3.2 Generate 99 multiplication table

3.3 Generate a payroll

3.4 Extract text from xls file

3.5 Ingenious use of Excelchart

3.6 Importing Excel files

Npoi 1.2 Tutorial-1 know Npoi

This chapter will introduce some basic information about Npoi, including the following sections

· What is Npoi

· Copyright notice

· Related Resources

· Team Introduction

· Future prospects

· The role of each assembly

1.1 What is Npoi

Npoi, as the name suggests, is the POI. NET version. What about the POI? Poi is a Java-written library that can help developers read and write office 97-2003 files without installing Microsoft Office, supporting file formats including XLS, Doc, PPT, and so on. At the time this article was published, the latest version of POI was 3.5 beta 6.

Npoi 1.x was developed based on the POI 3.x version, and the POI 3.2 version is Npoi 1.2, and the latest release is 1.2.1, which only supports reading and writing Excel files and drawing formats, and other file formats will be supported in later versions.

1.2 Copyright Description

Npoi is using the Apache 2.0 license (POI is also using this license), this means that it can be used for any commercial or non-commercial project, and you don't have to worry about having to open your own source code because you use it, so it's definitely a good choice for a lot of companies engaged in business system development.

Of course, as an open source license, there must be some obligations, for example, if you use Npoi in the system, you must keep all the declarative information in Npoi. For any modifications to the source code, a clear identification must be made.

Full Apache 2.0 license please see http://www.phpx.com/man/Apache-2/license.html.

1.3 Related Resources

Official website: http://npoi.codeplex.com/

Poifs Browser 1.2

Download Address: http://npoi.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=24305

QQ Exchange Group: 78142590

1.4 Team Introduction

Tony Qu, from Shanghai, China, is the initiator and developer of the project, and the time zone is gmt+8,2008, which started the Npoi development in September and is responsible for the development, testing and bug fixes of all the underlying libraries Npoi.

Personal blog address for http://tonyqus.cnblogs.com/

Hüseyintüfekçilerli from Istanbul, Turkey, is also the developer of the project, the time zone is gmt+2,2008 November participated in the development of NPOI, mainly responsible for Poifs Browser 1.0 of the development work.

Personal blog address for http://huseyint.com/

Atao.xiang, from China, began to participate in the project in August 2009, mainly participated in the Npoi 1.2 Chinese version of the writing and promotion work

Personal blog Address is