Convert XLSM to byte array via C#
Native and high performance Microsoft Excel XLSM 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 XLSM file to Byte Array as well as a Byte Array to XLSM document using C# language. In order to convert XLSM to byte array, we’ll use
API that offers different features for document manipulation and conversion using .NET platform.
How to Convert XLSM to Byte Array via C#
It is easy for the developers to load & convert XLSM files to byte array for further manipulation tasks in just a few lines of code.
- Include the namespace in your class file
- Load input XLSM 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 XLSM to byte array C# Conversion
Workbook workbook = new Workbook("sourceFile.xlsm");
//Save the workbook in memory stream
MemoryStream ms = new MemoryStream();
workbook.Save(ms, SaveFormat.Xlsm);
//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
XLSM What is XLSM File Format?
Files with XLSM extension is a type of Spreadsheet files that support Macros. From application point of view, a Macro is set of instructions that are used for automating processes. A macro is used to record the steps that are performed repeatedly and facilitates performing the actions by running the macro again. Macros are programmed with Microsoft’s Visual Basic for Applications (VBA) from within the Excel Workbook using the Visual Basic Editor and can be run/debug directly from there.
Read MoreOther Supported Conversions
You can also convert other file formats into byte array or vice versa including few listed below.