In various cases, you may need to export or save the Excel XLSX/XLS files to memory streams. For such cases, this article covers how to export Excel files to FileStream objects dynamically using C#. Moreover, you will learn how to load an Excel file from stream.
C# API to Export Excel Files to Stream
In order to export an Excel file to stream, we’ll use Aspose.Cells for .NET. It is a feature-rich API that lets you create and manipulate Excel files. You can either download the API’s DLL or install it via NuGet.
PM> Install-Package Aspose.Cells
Export an Excel File to Stream in C#
The following are the steps to export an Excel file to stream using C#.
- Load the Excel file using Workbook class.
- Create a new FileStream object.
- Export Excel file to stream using Workbook.Save(FileStream, SaveFormat) method.
The following code sample shows how to export an Excel XLSX file to a FileStream object.
Load Excel File from Stream
Aspose.Cells for .NET also allows you to load the Excel files from stream. The following are the steps to achieve this.
- Create a new FileStream object and load the Excel file into it.
- Create a new Workbook object and initialize it with the FileStream object.
- Perform the desired operations on the Excel file using Workbook object.
The following code sample shows how to load an Excel file from a FileStream.
Get a Free License
You can get a free temporary license and use the API without evaluation limitations.
Conclusion
In this article, you have learned how to export Excel files to stream using C#. Moreover, you have seen how to load the Excel files from the stream dynamically. In addition, you can explore other features of Aspose.Cells for .NET using the documentation. Also, you can ask your questions via our forum.