How to reading large .XLSX files (80MB and up) using NPOI .

[mahetamayur]

I am using XSSFWorkbook from Stream.
Error Message:
Exception of type 'System.OutOfMemoryException' was thrown.
Stack Trace :
Exception of type 'System.OutOfMemoryException' was thrown. at System.String.CtorCharArrayStartLength(Char[] value, Int32 startIndex, Int32 length) at System.Xml.XmlTextReaderImpl.ReadAttributeValue() at System.Xml.XmlLoader.LoadAttributeNode() at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace) at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc) at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace) at System.Xml.XmlDocument.Load(XmlReader reader) at System.Xml.XmlDocument.Load(Stream inStream) at NPOI.XSSF.UserModel.XSSFSheet.Read(Stream is1) at NPOI.XSSF.UserModel.XSSFSheet.OnDocumentRead() at NPOI.XSSF.UserModel.XSSFWorkbook.OnDocumentRead() at NPOI.POIXMLDocument.Load(POIXMLFactory factory) at NPOI.XSSF.UserModel.XSSFWorkbook..ctor(Stream is1)

[tonyqus]

80M for a Excel file is too much. Xlsx is a zip file and if you unzip it, you will see what's the real size of these openxml files.