Convert XLSX to byte array via C#
Native and high performance Microsoft Excel XLSX to byte array conversion or vice versa for spreadsheets data processing using server side .NET APIs.
Aspose.Cells for .NET
Overview
Byte Array is helpful for data processing or storing. You can convert XLSX file to Byte Array as well as a Byte Array to XLSX document using C# language. In order to convert XLSX to byte array, we’ll use
API that offers different features for document manipulation and conversion using .NET platform.
How to Convert XLSX to Byte Array via C#
It is easy for the developers to load & convert XLSX files to byte array for further manipulation tasks in just a few lines of code.
- Include the namespace in your class file
- Load input XLSX File using Workbook
- Initialize MemoryStream object
- Convert stream data to byte array
- Process data as of your requirement
System Requirements
Just make sure that system have Microsoft Windows or a compatible OS with .NET Framework, .NET Core, Windows Azure, Mono or Xamarin Platforms as well as development environment like Microsoft Visual Studio.
- Install from command line as
nuget install Aspose.Cellsor via Package Manager Console of Visual Studio withInstall-Package Aspose.Cells. - Alternatively, get the offline MSI installer or all DLLs in a ZIP file from downloads
This sample code shows XLSX to byte array C# Conversion
Workbook workbook = new Workbook("sourceFile.xlsx");
//Save the workbook in memory stream
MemoryStream ms = new MemoryStream();
workbook.Save(ms, SaveFormat.Xlsx);
//Read bytes from memory stream
byte[] byte_array = new byte[ms.Length];
ms.Read(byte_array, 0, byte_array.Length);
// Process the memory stream byte array data as of your requirement
XLSX What is XLSX File Format?
XLSX is well-known format for Microsoft Excel documents that was introduced by Microsoft with the release of Microsoft Office 2007. Based on structure organized according to the Open Packaging Conventions as outlined in Part 2 of the OOXML standard ECMA-376, the new format is a zip package that contains a number of XML files. The underlying structure and files can be examined by simply unzipping the .xlsx file.
Read MoreOther Supported Conversions
You can also convert other file formats into byte array or vice versa including few listed below.