Read openoffice ods file using CreateOpenXmlReader in C#

Jan 13, 2015 at 10:53 AM
I tried the The following code to read the office spreadsheet.
try
                        {
                            string extension = Path.GetExtension(File1.PostedFile.FileName);
                            switch (extension.ToLower())
                            {
     case ".xls":
                                    excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
                                    break;
                                case ".xlsx":
                                    excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
                                    break;
                                case ".ods":
                                    excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream); 
                                    break;
                            }
                    }
                    catch (Exception ex)
                    {
                    }

It works fine for .xsl and .xlsx files but not working for openoffice .ods files. Can anyone confirm whether this supports openoffice or someother alternate needs to be try for this?