Tag Archives: NPOI Code Examples

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 …

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 …

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 …

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 …

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 …

Microsoft Excel is a perfect tool for working with data-intensive computations and calculations. People use it in their routine work to carry out complex calculations such as mathematical formula implementation, statistical analysis and many more. Data in an Excel worksheet …

If you are a frequent user of working with Excel workbooks, you must be familiar with adding Headers and Footers to your file. As the name indicates, the Header in an Excel file represents the repetitive information added to the …

If you have worked with Formulas in Excel, you must know the power of using formulas to perform calculations and analysis. Using formulas is essential for creating effective spreadsheets and making informed decisions. Excel has a wide range of formulas …

In our previous article, Using NPOI for Spreadsheets in .NET, we went through and showed how you can create a Workbook with NPOI in C#. We also showed examples of how to read data from a spreadsheet and save …