Effortlessly Merging Cells in Spreadsheets with FileFormat.Cells

Overview Spreadsheets are essential for many businesses and organizations, helping to keep data organized and easy to understand. But even simple tasks like merging cells can sometimes be tricky and time-consuming. That’s where FileFormat.Cells comes in. It’s a real lifesaver when it comes to handling spreadsheets. In this blog post, we’ll show you how FileFormat.Cells makes merging cells easy for everyone, whether you’re a spreadsheet pro or just getting started.
November 29, 2023 · 4 min · Fahad Adeel

Customizing Excel Spreadsheet Styles in C# using FileFormat.Cells

Overview Excel spreadsheets are a ubiquitous tool for data management, analysis, and reporting. Whether you’re a business professional, a data analyst, or a software developer, there comes a time when you need to create customized Excel files to suit your specific needs. If you’re working with C#, you’re in luck because the FileFormat.Cells library offers very smart features to help you achieve precisely that. In this blog post, we’ll explore how to use FileFormat.
October 25, 2023 · 3 min · Fahad Adeel

Insert Image in PowerPoint Presentation in Java with Apache POI API

In our earlier blog post, we explored the Apache POI XSLF API for creating and updating a Microsoft PowerPoint PPTX file with Java. Apache POI for Java lets you work with PPT and PPTX files from within your Java applications without getting into the internal file format details of these. In this article, we will go through the details of how Apache POI API can be used to insert an image in a PPTX with Java.
September 28, 2023 · 3 min · Kashif Iqbal

Create PowerPoint Presentation in Java with Apache POI API

In our previous article, we introduced the Apache POI components for working with PowerPoint presentation files. We had a look at the HSLF (Horrible Slide Layout Format) and XSLF (XML Slide Layout Format) APIs offered by Apache POI. In this article, we’ll see how to create presentations in Java and save these as PPTX files. System Requirements Before you begin, make sure that your system meets the following requirements. JDK – Java SE 2 JDK 1.
September 8, 2023 · 2 min · Kashif Iqbal

How to Merge Table Cells in Word Documents

Perform horizontal merge or vertical merge of one or more table cells in Docs/Docx files. FileFormat.Words provides methods to work with tables in Word files. Overview The newer version of FileFormat.Words offers further methods to work with tables in Word documents. The previous version contains methods to create, edit, and read table properties whereas the latest version lets users programmatically merge table cells in Docs/Docx files. In addition, you can do horizontal merge or vertical merge of table cells using this open-source .
September 7, 2023 · 7 min · Muhammad Mustafa

Java API to Access PowerPoint File Formats

When it comes to working with PowerPoint files using the Apache POI library, its two powerful components HSLF and XSLF are here to help you. These components provide developers with the tools they need to manipulate and create PowerPoint presentations, whether they’re dealing with the older PPT format or the more modern PPTX format. HSLF (Horrible Slide Layout Format) HSLF is tailored for handling the classic PPT format, which was widely used before the introduction of PPTX.
August 30, 2023 · 4 min · Kashif Iqbal

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