Wayback Machinekoobas.hobune.stream
May JUN Jul
Previous capture 12 Next capture
2021 2022 2023
1 capture
12 Jun 22 - 12 Jun 22
sparklines
Close Help
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
  • Asset Store
  • Get Unity

UNITY ACCOUNT

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account
  • Blog
  • Forums
  • Answers
  • Evangelists
  • User Groups
  • Beta Program
  • Advisory Panel

Navigation

  • Home
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
    • Blog
    • Forums
    • Answers
    • Evangelists
    • User Groups
    • Beta Program
    • Advisory Panel

Unity account

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account

Language

  • Chinese
  • Spanish
  • Japanese
  • Korean
  • Portuguese
  • Ask a question
  • Spaces
    • Default
    • Help Room
    • META
    • Moderators
    • Topics
    • Questions
    • Users
    • Badges
  • Home /
avatar image
0
Question by Reaksmey-Rt · Sep 16, 2015 at 12:03 PM · unity 5loadingreadreading data

How Can I read data from excel 2010 in unity 5 (64 Bits)?

Dear Sir/Madam! Recently I have a problem to load /Read Data from Microsoft Excel 2010 to use in Unity 5.1.2p1(64 bits). So please help me to solve this problem. I hope I can find good answer in this problem with good example to me . Thank you all your reply back to me!

Comment
Add comment
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

1 Reply

· Add your reply
  • Sort: 
avatar image
0

Answer by DoTA_KAMIKADzE · Sep 17, 2015 at 04:23 PM

As far as I understood you want to read tables from .xlsx format, if that is correct then it was quite some time ago that I worked with excel files and so I'm not really going to give you examples from top of my head, so I'll just give you few links.

First of all there is "Microsoft way" - using Microsoft.Office.Interop.Excel library, HERE I found an example for you, you can also use any search engine to find other examples, there should be enough of them on the internet. The real problem with "Microsoft way" is that in order for that one to work you'll need the actual MS Office itself installed on machine that is going to use that code, otherwise it simply ain't going to work.

Now when I needed to support work of one program, I used to work on, with Excel import/export I used NPOI library. They used to be HERE and now it seems like they're primarily THERE instead. I remember that I found other once as well, but for some reason I've chosen NPOI, probably because it worked well, was and currently is licensed under Apache 2.0 license (which is great).

Also when I was searching for "Microsoft way" example I stumbled upon OLEDB solution. I can't really remember if I tried that way back then or not, so there is not much I could say about that one.

Comment
Add comment · Show 1 · Share
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image Reaksmey-Rt · Sep 18, 2015 at 05:02 AM 0
Share

thank you for your Answer. I got it from research on this link :http://forum.unity3d.com/threads/how-can-i-get-data-from-excel.57967/ (for excel 2003) and (correct to excel 2010, Unity 5.1.2):http://answers.unity3d.com/questions/923013/load-data-from-excel-with-odbc-doesnt-work-in-unit.html.

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this Question

Answers Answers and Comments

31 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

How to load a large text asset with minimum to no lag. 2 Answers

Issues with my loading screen 0 Answers

unity 3d loading data from json problem?! 1 Answer

Loading Asset Bundles on iOS device 3 Answers

Confused about intermediate string reading. 1 Answer


Enterprise
Social Q&A

Social
Subscribe on YouTube social-youtube Follow on LinkedIn social-linkedin Follow on Twitter social-twitter Follow on Facebook social-facebook Follow on Instagram social-instagram

Footer

  • Purchase
    • Products
    • Subscription
    • Asset Store
    • Unity Gear
    • Resellers
  • Education
    • Students
    • Educators
    • Certification
    • Learn
    • Center of Excellence
  • Download
    • Unity
    • Beta Program
  • Unity Labs
    • Labs
    • Publications
  • Resources
    • Learn platform
    • Community
    • Documentation
    • Unity QA
    • FAQ
    • Services Status
    • Connect
  • About Unity
    • About Us
    • Blog
    • Events
    • Careers
    • Contact
    • Press
    • Partners
    • Affiliates
    • Security
Copyright © 2020 Unity Technologies
  • Legal
  • Privacy Policy
  • Cookies
  • Do Not Sell My Personal Information
  • Cookies Settings
"Unity", Unity logos, and other Unity trademarks are trademarks or registered trademarks of Unity Technologies or its affiliates in the U.S. and elsewhere (more info here). Other names or brands are trademarks of their respective owners.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges