Azure Serverless Computing Cookbook - Second Edition

Reading Excel data from the stream

Perform the following steps:

1. Create a class named EPPLusExcelManager and paste in the following code. This class has a method named ReadExcelData, which uses a library named EPPlus to read the data from the Excel file (.xlsx extension). It reads each row, creates an Employee object for each row, and then returns an employee collection. We will create the Employee class in a moment:

class EPPLusExcelManager { public List<Employee> ReadExcelData(Stream stream) { List<Employee> employees = new List<Employee>(); //FileInfo existingFile = new FileInfo("EmployeeInformation.xlsx"); using (ExcelPackage package = new ExcelPackage(stream)) { ExcelWorksheet ExcelWorksheet = package.Workbook.Worksheets[0]; for (int ...