Add Barcodes to XLSX in C# ASP.NET VB.NET

Add Barcodes to Excel Documents in .NET

Conholdate.Total for .NET makes it easy for .NET developers to generate a customized barcode image based on provided text, and dynamically add it to the XLSX document by implementing a few easy steps.

Instantiate linear barcode object, Set the text and barcode symbology
Creating memory stream and Saving barcode image to memory stream
Instantiate Excel class that represents an excel file
Add the barcode image into the pictures collection of the first worksheet of the excel file in the form of a MemoryStream and save the excel file

APIs Download & Installation Instructions

The following code example requires Aspose.PDF & Aspose.BarCode namespaces. Get the respective files from the downloads section or fetch the whole package from NuGet directly into your workspace.

Insert barcodes to a XLSX document on different operating systems such as Windows, Linux or macOS while using platforms such as Windows Azure, Mono and Xamarin.

What is XLSX file format?

The XLSX file format is a widely used file format for storing spreadsheet data. It was introduced by Microsoft as part of their Microsoft Office suite, specifically for the Excel application. XLSX stands for Excel Open XML Spreadsheet. Unlike its predecessor, the XLS format, which was based on a proprietary binary file structure, XLSX is based on the Open XML file format.

XLSX files are structured as a collection of XML files compressed into a single ZIP archive. This XML-based structure allows for more efficient storage and faster data processing. XLSX files store data in a tabular format, with rows and columns that can contain text, numbers, formulas, and other types of data. They also support formatting options such as cell styles, fonts, colors, and conditional formatting.

One of the advantages of the XLSX format is its compatibility across different platforms and software applications. Many spreadsheet programs, including Microsoft Excel, Google Sheets, and LibreOffice Calc, can open and edit XLSX files. This makes it easy to share and collaborate on spreadsheet data with others, regardless of the software they are using.

XLSX files also offer features like data validation, filtering, sorting, and the ability to create charts and graphs based on the data. Additionally, XLSX files can contain multiple sheets within a single file, allowing users to organize and manage different sets of data within a single document.

Learn