Working with Excel XLSX programmatically | FileFormat.Cells

An introduction to FileFormat.Cells – an open-source C# Excel API that lets users create, view, and edit spreadsheets seamlessly & programmatically. Overview Goodbye to the repetitive tasks and welcome to the FileFormat.Cells to achieve spreadsheet automation. Empower your .NET application with an open-source C# Excel API that is easy to use and offers features to create, view, and edit Excel XLSX files programmatically. Above all, FileFormat.Cells is based on OpenXML and is powered by Microsoft.
August 29, 2023 · 3 min · Muhammad Mustafa

How to Create an Excel Spreadsheet in C# using FileFormat.Cells

Forget MS Excel and use FileFormat.Cells to craft & manage MS Excel Spreadsheets. This spreadsheet automation software offers user friendly features. Overview After the remarkable success of FileFormat.Words, we are excited to introduce FileFormat.Cells for .NET. This open-source C# API empowers .NET developers to programmatically create, design, and enhance MS Excel Spreadsheets. Whether you’re a novice or an expert, integrating FileFormat.Cells into your .NET application is effortless. The importance and versatility of MS Excel in business are undeniable.
August 25, 2023 · 3 min · Fahad Adeel

Working with Excel Cells in Java using Apache POI API

If you are a Java application developer working with Excel from within your Java applications, you would be interested in providing the functionality of manipulating Excel data in your application. Excel lets you format cell styling, set the type of a cell to different data types, fill a cell with different colors, and so on. Apache POI serves as your bridge between Java and Excel, offering tools to manipulate Excel XLSX files programmatically.
August 22, 2023 · 7 min · Kashif Iqbal

Insert Header and Footer in Excel using Apache POI for Java

Apache POI is a popular Java library that allows you to work with Microsoft Office formats, including Excel spreadsheets. The Apache POI’s XSSF (XML Spreadsheet Format) module works with Excel files in the newer XML-based format, commonly known as .xlsx. Headers and footers in Excel are the areas at the top and bottom of each page in a worksheet where you can place content such as titles, page numbers, dates, and other relevant information.
August 19, 2023 · 3 min · Kashif Iqbal

How to Insert Table Headers in Word Documents

Follow this blog post to learn how to add table headers in Word documents programmatically. FileFormat.Words offers rich table creation & manipulation methods. Overview Data tables are critical elements in MS Word documents. Working with tables is a routine task but what if there are a number of documents with multiple data tables involved? Of course, some sort of automation will badly be needed to automate the repetitive tasks to save time and boost productivity.
August 18, 2023 · 6 min · Muhammad Mustafa

Work with Excel Formulas in Java Applications with Apache POI Library

Microsoft Excel’s powerful formula capabilities are essential for performing complex calculations, data analysis, and creating dynamic reports. But what if you could automate these formulaic operations using a Java library? That’s where Apache POI comes into play. In this blog post, we’ll show how to use the Apache POI library to calculate Excel Formulas from within your Java application and save the workbook as XLSX file. Understanding Formulas and Calculations Formulas are at the heart of Excel’s functionality.
August 17, 2023 · 4 min · Kashif Iqbal

Add Image in Excel Cell with Java POI

Images make you understand any story the easy way. It’s a famous saying that a picture is worth a thousand words. Microsoft Excel lets you insert pictures in your worksheets in cells and recording facts against these. In this article, we’ll show how to use Apache POI API to insert an image in Excel XLSX file using Java. Apache POI Apache POI is a Java library for working with Microsoft Office file formats such as XLS, XLSX, DOC, DOCX, PPT, PPTX, etc.
August 11, 2023 · 3 min · Kashif Iqbal

Read Excel File in Java with Apache POI

Excel files are widely used to maintain large datasets and for statistical data analysis. Reading Excel files in Java applications is a widely used feature for accessing and parsing data. If you are a Java application developer who intends to provide the functionality of reading Excel files in Java, Apache POI for Java should be your obvious choice. In our previous article for Creating Excel Files in Java using Apache POI, we showed the basics of creating an Excel workbook.
August 8, 2023 · 3 min · Kashif Iqbal

How to Move a Table in Word Documents Programmatically

Install FileFormat.Words library to automate the creation & manipulation of Docx/Docs files. Use this open-source API to learn how to align table in Word files. Overview Welcome to another interesting blog post on FileFormat.Words for .NET. There are many articles published on this open-source API that you may find here. This library has the potential to create and manipulate MS Word documents in a C# application. However, we already have covered how to create Tables in Word documents using FileFormat.
August 4, 2023 · 4 min · Muhammad Mustafa

Create Excel Workbook in Java using Apache POI

In our previous article, we went through the details of Apache POI, an open-source Java API for working with Microsoft file formats. In this article, we’ll go through the Apache POI component for working with Excel Workbooks. We will also show how to use Apache POI to create an Excel file and add sheets to it using this Java library. Apache POI Java APIs for Accessing Excel File Formats Apache POI Java API provides separate components for working with two different Excel file formats.
August 2, 2023 · 4 min · Kashif Iqbal