phucnh1993
commented
4 years ago 
I run on K8S and use NPOI read file Excel from a Stream
My Code:
var checkFile = true;
ISheet sheet;
IFont font;
using (MemoryStream ms = new MemoryStream())
{
var data = Convert.FromBase64String(file.FileBase);
await ms.WriteAsync(data, 0, data.Length);
ms.Position = 0;
var temp = Path.GetExtension(file.FileName);
if (Path.GetExtension(file.FileName).Equals(".xls"))
{
var book = new HSSFWorkbook(ms);
font = book.CreateFont();
sheet = book.GetSheet("Sheet1");
}
else
{
var book = new XSSFWorkbook(ms);
font = book.CreateFont();
sheet = book.GetSheet("Sheet1");
}
int rowIndex = 1;
IRow rowData;
font.Color = HSSFColor.Red.Index;
var listThread = new List
Use NPOI in dotnet core web api to create excel file. The memory usage of the website is always rising.