Read excel file from a stream

It seems i found a soultion to the problem myself.

http://www.codeplex.com/ExcelDataReader

This library seems to work nicely and it takes a stream to read the excel file.

ExcelDataReader reader = new ExcelDataReader(ExcelFileUpload.PostedFile.InputStream);

This can be done easily with EPPlus.

//the excel sheet as byte array (as example from a FileUpload Control)byte[] bin = FileUpload1.FileBytes;//gen the byte array into the memorystreamusing (MemoryStream ms = new MemoryStream(bin))using (ExcelPackage package = new ExcelPackage(ms)){    //get the first sheet from the excel file    ExcelWorksheet sheet = package.Workbook.Worksheets[1];    //loop all rows in the sheet    for (int i = sheet.Dimension.Start.Row; i <= sheet.Dimension.End.Row; i++)    {        //loop all columns in a row        for (int j = sheet.Dimension.Start.Column; j <= sheet.Dimension.End.Column; j++)        {            //do something with the current cell value            string currentCellValue = sheet.Cells[i, j].Value.ToString();        }    }}

SpreadsheetGear can do it:

SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbookSet().Workbooks.OpenFromStream(stream);

You can try it for yourself with the free evaluation.

Disclaimer: I own SpreadsheetGear LLC