joexi / excel4unity Goto Github PK
View Code? Open in Web Editor NEWExcel for Unity. Provides both read and write with .xls and .xlsx
Excel for Unity. Provides both read and write with .xls and .xlsx
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. )
<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>
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+EventFunction
1[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()
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.
The ExcelPackage Constructor is infinitely looping on Android can you please solve it?
Thank you
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
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?
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?
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.