Monthly Archives: May 2023

Insert Image in Word Document using NPOI in C#/VB.NET

The use of images in documents is a routine operation while working with Microsoft Word. Images give clarity to the content of the document as well as play a vital role in relaying information that is more difficult to put …

Posted in Word Processing | Tagged , ,

Text Formatting in Word Document using NPOI in C#/VB.NET

Microsoft Word is to stay here and remain one of the widely used document editors for creating documents. Almost everyone knows about it and uses it in daily life one way or the other. People from every aspect of life …

Posted in Word Processing | Tagged , ,

Create Empty Word Document using NPOI API in C#/VB.NET

Almost everyone uses Microsoft Word on a daily basis to create documents and save them once they are done. It offers a lot of functionality for creating documents that are rich in text, images, multimedia options, art clips, tables, and …

Posted in Word Processing | Tagged , ,

NPOI API for Processing Word Documents in .NET – An Overview

NPOI is an open-source .NET equivalent API of the POI Java project that is used to read/write Microsoft® Office file formats. It has XWPF namespace for Word document processing and supports working with Word .docx file format. The API is …

Posted in Word Processing | Tagged ,

Set Cell Style in Excel using NPOI API in C#

Applying a style to a cell or set of cells is a very common operation while working with workbooks in Excel. By cell styling, we mean applying a defined set of formattings such as fonts, font sizes, number formats, cell …

Posted in Spreadsheet | Tagged , ,

Protect Excel Worksheets using NPOI in C#

Imagine you have hard worked to compile your data in an Excel workbook and saved it to your computer. Your kids are using the same computer for their educational purpose. They accidentally open the file you have compiled after so …

Posted in Spreadsheet | Tagged , ,

Merge Cells in Excel using NPOI in C#

A common operation in Microsoft Excel is to merge two or more cells. This gives a more organized look and feels to your data with the sense of data grouping and headers information. You can merge as many cells as …

Posted in Spreadsheet | Tagged , ,

Insert Image in Excel using NPOI in .NET

Inserting images in Excel files is a very commonly used feature for Microsoft Excel users. Adding images to your Excel workbooks helps clarify your point of view and data representation more effectively. You can add multiple images to each worksheet …

Posted in Spreadsheet | Tagged , ,

Create Drop-down List in Excel with NPOI in C#

Drop-down lists provide a better way to limit users for data entry from a specified list of options. This removes the chances of making wrong data entries if input by the user manually. Creating drop-down lists in your Excel workbook …

Posted in Spreadsheet | Tagged , ,