I am creating an Excel document using OpenXML 2.0 which works fine if we have less data in the file. But for huge amount of data, it is throwing "Isolated Storage Exception" while worksheet.save(). I understand that to save the worksheet with huge
data, IO.Packaging.SparseMemoryStream tries to create the Isolated Storage with user scoped profile. How to resolve this issue? Is there any way to ignore creation of isolated storage for saving huge data and use memory stream only?