How to add Hyperlinks in Excel using C#

Excel is an exceptional tool for working with large data sets, data visualization, and statistical analysis of data. While creating a detailed data report in Excel, certain data may require to be linked to external data sources, webpages, email addresses, and target locations in another worksheet in the same workbook. Microsoft Excel provides all these hyperlinking options. As a .NET application developer, you may be interested in providing hyperlinking functionality in your C#/VB.
June 26, 2023 · 6 min · Kashif Iqbal

Add Bookmark in Word Document using C#/VB.NET

You must be familiar with the term “Bookmark” which marks a feature that you can get to easily when required. While working with large Word documents, you may often add bookmarks to certain text/pages that you would like to be included in the list of places that you would want to access quickly if required. Microsoft Word lets you work with bookmarks in documents by adding, updating, and deleting bookmarks. As a .
June 21, 2023 · 3 min · Kashif Iqbal

Insert Watermark in Word Document using C#

Watermarks are text, logo, or other graphical pattern that is inserted in a document or superimposed on another image. Its purpose is to keep the identity of the original document or image so as to forbid its use without permission. As a .NET application developer, you can provide the functionality of inserting a Watermark in Word documents in your document processing C# application. In this blog, we’ll show how to insert a watermark in a Word document in C# using the free and open-source .
June 13, 2023 · 3 min · Kashif Iqbal

Add Hyperlink to Word Document in C#

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#.
June 6, 2023 · 3 min · Kashif Iqbal

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.
June 5, 2023 · 4 min · Kashif Iqbal

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.
May 31, 2023 · 3 min · Kashif Iqbal

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 .
May 20, 2023 · 3 min · Kashif Iqbal

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.
May 19, 2023 · 3 min · Kashif Iqbal

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.
May 13, 2023 · 3 min · Kashif Iqbal

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.
May 11, 2023 · 3 min · Kashif Iqbal