NPOI Tutorial

Sample 1 - create a simple Excel file with NPOI

Sample 2 - Open an existing Excel tempate and setup formula in it

Sample 3 - applying data formats to Excel cells

Sample 4 - insert pictures with NPOI

Sample 5 - how to use WorkbookFactory

Sample 6 - How to operate Sheet object

Sample 7 - How to set fill pattern color for a cell

Planning Tutorials

Excel

• How to set up border style for cells
• How to change the column width and row height in Excel
• How to use ExcelMapper to populate an Excel document
• How to merge cells in Excel
• How to set the print area in Excel
• How to apply conditional formats in Excel
• How to create a bar chart in Excel

Word

• How to create a Word document with Paragraph and Run
• How to insert a table in a Word document

Complete Project

• Create a multiplication table in Excel
• Create a colorful matrix table in Excel
• Create a loan calculator in Excel
• Create a monthly salary report in Excel
• Create an Excel file from a DataSet collection