joexi/excel4unity

Excel for Unity. Provides both read and write with .xls and .xlsx

excel4unity's Issues

Errors in 2018.3

Assembly 'Assets/Editor/EPPlus/EPPlus.dll' will not be loaded due to errors:
Unable to resolve reference 'PresentationCore'. Is the assembly missing or incompatible with the current platform?

NotSupportedException: Encoding 437 data could not be found

Getting this message on build solution, not in editor. Any ideas on how to fix this?
Using .Net 4.x

Full error:
NotSupportedException: Encoding 437 data could not be found. Make sure you have correct international codeset assembly installed and enabled. at System.Text.Encoding.GetEncoding (System.Int32 codepage) [0x0023f] in <437ba245d8404784b9fbab9b439ac908>:0 at System.Text.Encoding.GetEncoding (System.String name) [0x00012] in <437ba245d8404784b9fbab9b439ac908>:0 at Ionic.Zip.ZipInputStream._Init (System.IO.Stream stream, System.Boolean leaveOpen, System.String name) [0x0002b] in <88f42ade62d2458191abd1eb579a2317>:0 at Ionic.Zip.ZipInputStream..ctor (System.IO.Stream stream, System.Boolean leaveOpen) [0x00006] in <88f42ade62d2458191abd1eb579a2317>:0 at Ionic.Zip.ZipInputStream..ctor (System.IO.Stream stream) [0x00000] in <88f42ade62d2458191abd1eb579a2317>:0 at (wrapper remoting-invoke-with-check) Ionic.Zip.ZipInputStream..ctor(System.IO.Stream) at OfficeOpenXml.Packaging.ZipPackage..ctor (System.IO.Stream stream) [0x00051] in <88f42ade62d2458191abd1eb579a2317>:0 at OfficeOpenXml.ExcelPackage.ConstructNewFile (System.String password) [0x000c8] in <88f42ade62d2458191abd1eb579a2317>:0 at OfficeOpenXml.ExcelPackage..ctor (System.IO.FileInfo newFile) [0x0001e] in <88f42ade62d2458191abd1eb579a2317>:0 at ExcelHelper.LoadExcel (System.String path) [0x00006] in <b7648d4347ba4b2ea7dd3f9b97628b28>:0 at ExcelFetcher.Read1 () [0x00008] in <e5300bf1b7cb438ca26562f095c1aa2e>:0 at ExcelFetcher.chooseFile1 () [0x0006e] in <e5300bf1b7cb438ca26562f095c1aa2e>:0 at UnityEngine.Events.InvokableCall.Invoke () [0x00010] in <6a27f5ccf1f84e47b130b28f8d65abee>:0 at UnityEngine.Events.UnityEvent.Invoke () [0x00022] in <6a27f5ccf1f84e47b130b28f8d65abee>:0 at UnityEngine.UI.Button.Press () [0x0001c] in <e8a2dc6582244d7b914eb753ab444fa8>:0 at UnityEngine.UI.Button.OnPointerClick (UnityEngine.EventSystems.PointerEventData eventData) [0x00009] in <e8a2dc6582244d7b914eb753ab444fa8>:0 at UnityEngine.EventSystems.ExecuteEvents.Execute (UnityEngine.EventSystems.IPointerClickHandler handler, UnityEngine.EventSystems.BaseEventData eventData) [0x00007] in <e8a2dc6582244d7b914eb753ab444fa8>:0 at UnityEngine.EventSystems.ExecuteEvents.Execute[T] (UnityEngine.GameObject target, UnityEngine.EventSystems.BaseEventData eventData, UnityEngine.EventSystems.ExecuteEvents+EventFunction1[T1] functor) [0x00063] in :0
UnityEngine.DebugLogHandler:Internal_LogException(Exception, Object)
UnityEngine.DebugLogHandler:LogException(Exception, Object)
UnityEngine.Logger:LogException(Exception, Object)
UnityEngine.Debug:LogException(Exception)
UnityEngine.EventSystems.ExecuteEvents:Execute(GameObject, BaseEventData, EventFunction1) UnityEngine.EventSystems.StandaloneInputModule:ReleaseMouse(PointerEventData, GameObject) UnityEngine.EventSystems.StandaloneInputModule:ProcessMousePress(MouseButtonEventData) UnityEngine.EventSystems.StandaloneInputModule:ProcessMouseEvent(Int32) UnityEngine.EventSystems.StandaloneInputModule:ProcessMouseEvent() UnityEngine.EventSystems.StandaloneInputModule:Process() UnityEngine.EventSystems.EventSystem:Update()

assembly reference not found /mobile support ????

Hi i am using Excel4Unity in my unity android project where i am exporting gradle of unity project and i am getting error of missing assembly reference

Assets\Excel4Unity\Excel.cs(4,7): error CS0246: The type or namespace name 'OfficeOpenXml' could not be found (are you missing a using directive or an assembly reference?)

Assets\Excel4Unity\ExcelHelper.cs(3,7): error CS0246: The type or namespace name 'OfficeOpenXml' could not be found (are you missing a using directive or an assembly reference?)

Assets\Excel4Unity\Excel.cs(16,18): error CS0246: The type or namespace name 'ExcelWorkbook' could not be found (are you missing a using directive or an assembly reference?)

please help me out

What type of license is this?

Hi,

It seems that Excel4Unity is nice tool. I'd like to use to import/export Excel with Unity.
Anyway, would you tell me what type of license is this?
I wish you note the license on the document page.

Thanks.

how to fix error 437 when use IL2CPP Build?

unity version 2020.3.15f2
Epplus.dll version 4.1.0.0
Is running perfect when use mono mode.(just need cope some I18N.*.dll to build folder)
but if buid using IL2CPP i get the 437 error,what did i miss?(NotSupportedException: Encoding 437 data could not be found. )

1. I tryed creat link.xml file in unity project Asset folder.

<linker>
    <assembly fullname="I18N">
        <type fullname="I18N.Common" preserve="all"/>
        <type fullname="I18N.Common.ByteEncoding" preserve="all"/>
        <type fullname="I18N.Common.Handlers" preserve="all"/>
        <type fullname="I18N.Common.Manager" preserve="all"/>
        <type fullname="I18N.Common.MonoEncoder" preserve="all"/>
        <type fullname="I18N.Common.MonoEncoding" preserve="all"/>
        <type fullname="I18N.Common.Strings" preserve="all"/>
    </assembly>

    <assembly fullname="I18N.West">
        <type fullname="I18N.West" preserve="all"/>
        <type fullname="I18N.West.ENCwindows_1252" preserve="all"/>
        <type fullname="I18N.West.CP1252" preserve="all"/>
        <type fullname="I18N.West.ENCibm437" preserve="all"/>
        <type fullname="I18N.West.CP437" preserve="all"/>
    </assembly>
</linker>

2. I tryed .Net4.x and .NET Standard2.0
3. I tryed add I18N.*.dll to Build folder.(copy from C:\Program Files\Unity\Hub\Editor\Unity2020.3.15f2\Editor\Data\MonoBleedingEdge\lib\mono\unity or unityjit folder)

ExcelPackage Constructor infinite waiting on Android

The ExcelPackage Constructor is infinitely looping on Android can you please solve it?
Thank you

"Requested value 'baseline' was not found" when loading excel file

Hello, I have this error when trying to open an excel file:

ArgumentException: Requested value 'baseline' was not found. System.Enum+EnumResult.SetFailure (System.Enum+ParseFailureKind failure, System.String failureMessageID, System.Object failureMessageFormatArgument) (at <695d1cc93cca45069c528c15c9fdd749>:0) System.Enum.TryParseEnum (System.Type enumType, System.String value, System.Boolean ignoreCase, System.Enum+EnumResult& parseResult) (at <695d1cc93cca45069c528c15c9fdd749>:0) System.Enum.Parse (System.Type enumType, System.String value, System.Boolean ignoreCase) (at <695d1cc93cca45069c528c15c9fdd749>:0) OfficeOpenXml.Style.ExcelFont.get_VerticalAlign () (at <88f42ade62d2458191abd1eb579a2317>:0) OfficeOpenXml.Style.ExcelFont.get_Id () (at <88f42ade62d2458191abd1eb579a2317>:0) OfficeOpenXml.ExcelWorkbook.get_MaxFontWidth () (at <88f42ade62d2458191abd1eb579a2317>:0) OfficeOpenXml.ExcelWorksheet.get_DefaultColWidth () (at <88f42ade62d2458191abd1eb579a2317>:0) OfficeOpenXml.ExcelColumn..ctor (OfficeOpenXml.ExcelWorksheet Worksheet, System.Int32 col) (at <88f42ade62d2458191abd1eb579a2317>:0) OfficeOpenXml.ExcelWorksheet.LoadColumns (System.Xml.XmlTextReader xr) (at <88f42ade62d2458191abd1eb579a2317>:0) OfficeOpenXml.ExcelWorksheet.CreateXml () (at <88f42ade62d2458191abd1eb579a2317>:0) OfficeOpenXml.ExcelWorksheet..ctor (System.Xml.XmlNamespaceManager ns, OfficeOpenXml.ExcelPackage excelPackage, System.String relID, System.Uri uriWorksheet, System.String sheetName, System.Int32 sheetID, System.Int32 positionID, OfficeOpenXml.eWorkSheetHidden hide) (at <88f42ade62d2458191abd1eb579a2317>:0) OfficeOpenXml.ExcelWorksheets..ctor (OfficeOpenXml.ExcelPackage pck, System.Xml.XmlNamespaceManager nsm, System.Xml.XmlNode topNode) (at <88f42ade62d2458191abd1eb579a2317>:0) OfficeOpenXml.ExcelWorkbook.get_Worksheets () (at <88f42ade62d2458191abd1eb579a2317>:0) Excel..ctor (OfficeOpenXml.ExcelWorkbook wb) (at Assets/Excel4Unity/Editor/Excel4Unity/Excel.cs:17) ExcelHelper.LoadExcel (System.String path) (at Assets/Excel4Unity/Editor/Excel4Unity/ExcelHelper.cs:13)

The excel file has been generated by another third party tool. The interesting thing is that opening the file and saving it (without changing anything) resolves this issue.

Do you have any idea what can cause this bug?