Excel file creation won't work on IL2CPP

Questions & Answers
1

Hello! So, since Google Play now only lets to publish apps that have 64bit version included (that is IL2CPP), I have to change from Mono to that. The problem is, I use excel file creation plugin in my app (NPOI), which doesn’t seem to work on IL2CPP. I also tried EPPlus plugin - same thing (works on Mono, doesn’t on IL2CPP). I was wondering what is the source of this problem, and could it be fixed in any way? Here’s the error I get on IL2CPP:

NullReferenceException: Object reference not set to an instance of an object.
at NPOI.XSSF.UserModel.XSSFFactory.CreateDocumentPart (NPOI.POIXMLRelation descriptor) [0x00000] in <00000000000000000000000000000000>:0
at NPOI.POIXMLDocumentPart.CreateRelationship (NPOI.POIXMLRelation descriptor, NPOI.POIXMLFactory factory, System.Int32 idx, System.Boolean noRelation) [0x00000] in <00000000000000000000000000000000>:0
at NPOI.XSSF.UserModel.XSSFWorkbook.OnWorkbookCreate () [0x00000] in <00000000000000000000000000000000>:0
at Sections+d__264.MoveNext () [0x00000] in <00000000000000000000000000000000>:0
at UnityEngine.SetupCoroutine.InvokeMoveNext (System.Collections.IEnumerator enumerator, System.IntPtr returnValueAddress) [0x00000] in <00000000000000000000000000000000>:0
at UnityEngine.Events.UnityEvent.Invoke () [0x00000] in <00000000000000000000000000000000>:0
at UnityEngine.EventSystems.ExecuteEvents.Execute[T] (UnityEngine.GameObject target, UnityEngine.EventSystem

2

I suspect the problem is managed byte code stripping. With IL2CPP, byte code stripping is always enabled. Byte code stripping removed unused IL code from managed assemblies. Is this NPOI library uses reflection to access some of its code, managed code stripping may have removed code that it needs.

You can use a link.xml file in the Unity project to tell the managed code stripping system to avoid stripping any code from this library. See Unity - Manual: Managed code stripping for details.

3

Thanks so much! It is working as intended now.

4

Thank you so very very much. you saved me