NPOI.DotNetCore.ExcelService 1.0.5

#NPOI Excel Service For DotNetCore

You can import or export your excel files easily. This version supports to reading and writing for single sheet only. The library creates binary data of generated excel document for export operation. You can save it on a file system or serve as a file over web. The library ignores save and serv operations and focuses only reading and generation processes.

Also this library support xls and xlsx file formats.

You can send null value for header parameter if you don't want to create a header row. If you set useXLSXFormat parameter as true, the file content will generate Microsoft Excel 2007 or later format. You can serve it with .xlsx extension. Otherwise it will generate as Microsoft Excel 2003 format. So then you can serve it with .xls extension

#byte[] ExportAsExcel(bool useXLSXFormat, string sheetName, IEnumerable<string> header, IEnumerable<IEnumerable<object>> data);

isXLSXFormat parameter is same useXLSXFormat parameter. You should specify imported file's format whatever it is xls or xlsx. If you set skipFistRow parameter as true the first row will ignore

#IEnumerable<IEnumerable<object>> ImportExcel(bool isXLSXFormat, Stream stream, bool skipFistRow);