A hyperlink is an anchored text that leads to an online web page when it is clicked. You can make any text in a Word document a hyperlink that will navigate the users to the linked page when clicked. Hyperlinks make it easy for writers to guide the document readers for any references that are linked to the main article. Being a .NET application developer, you can add the feature of adding hyperlinks to your document processing application in C#.
Add Header and Footer to DOCX using C#
Headers and Footers are commonly used while working with Word documents. They give a clear view of the main theme of the document as well as any additional information that needs to be put in front of readers. Microsoft Word lets you add header and footer information to your document with customization. If you are a .NET application developer who is interested in developing (or has developed) an application for word document processing, adding the feature of inserting headers and footers to Word documents from your application can be a beneficial feature.
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 into words. Adding images makes the content easier to understand. As a .NET developer, adding the functionality of inserting images into a Word document is an interesting feature that can add value to your application.
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 use it one way or the other to generate documents. You must be familiar with the .docx file format which is the default file format for saving Word documents.
Being a .
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 many other types of data. That is why it is the first choice of use when it comes to creating documents. Word documents, hence, created are saved in the popular Open Office XML document format with .
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 available to be used in both .NET and .NET Core projects using C# and VB.NET.
In this article, we go through NPOI for .NET API for working with DOCX file format.
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 borders, and cell shading. This helps in improved and better visualization of data for quick referencing.
As a .NET application developer, you may be interested in providing the functionality of setting cell style in Excel workbooks from within your .
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 much hard work and somehow make changes to your data. All your hard work is now about to get wasted as data consistency may have arisen due to all these changes.
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 well as rows and columns using Excel. As a .NET application developer, you may be interested in providing the functionality of merging cells in Excel spreadsheets from within your application. You can achieve this using NPOI API in your application that can merge cells or cell ranges using C# or VB.
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 in your workbook. As a .NET application developer, you may want to add the feature of inserting images in Excel files from within your application programmatically. The good news is that this can be achieved using NPOI API in C# and VB.