• 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
1
Question by ungoliath · Aug 20, 2010 at 11:56 AM · databasereadexcel

How can I get data from an outside database (specifically excel).

I want to have a bunch of parts whose position updates according to an excel table. The user can press an update button and the positions, sizes, etc will be read from the latest values in the table.

Comment
Add comment · Show 1
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 tingham · Nov 05, 2010 at 07:12 PM 0
Share

Not to split hairs but Excel is a data source, not a database.

2 Replies

· Add your reply
  • Sort: 
avatar image
2

Answer by Herman-Tulleken · Aug 20, 2010 at 02:35 PM

One way to do it is to save the file in the text XML format. From this it should be easy to read in your data using a standard XML parser (such as the one that comes with C#).

Comment
Add comment · 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
2

Answer by tingham · Nov 05, 2010 at 07:15 PM

public List<string[]> parseCSV(string path) { List<string[]> parsedData = new List<string[]>();

try { using (StreamReader readFile = new StreamReader(path)) { string line; string[] row;

   while ((line = readFile.ReadLine()) != null)
   {
     // Handle quoted values or comma-only.
     string splitVar = ( line.indexOf("\",\") &gt; -1 ) ? "\",\"" : "," );
     row = line.Split(splitVar);
     parsedData.Add(row);
   }
 }

} catch (Exception e) { MessageBox.Show(e.Message); }

return parsedData; }

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 tingham · Nov 05, 2010 at 07:16 PM 0
Share

Save your excel file as CSV, quoted values are better.

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.

Welcome to Unity Answers

The best place to ask and answer questions about development with Unity.

To help users navigate the site we have posted a site navigation guide.

If you are a new user to Unity Answers, check out our FAQ for more information.

Make sure to check out our Knowledge Base for commonly asked Unity questions.

If you are a moderator, see our Moderator Guidelines page.

We are making improvements to UA, see the list of changes.



Follow this Question

Answers Answers and Comments

No one has followed this question yet.

Related Questions

Read XLS file with UTF-8 character; 1 Answer

Keeping object data in an excel sheet? 2 Answers

Local database on iOS 1 Answer

Reading an excel file using ExcelReaderFacotry 1 Answer

Unity Sqlite for Android 8.0 0 Answers

  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges