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

Question

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.

Answer 1

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#).

Add comment · Share

Answer 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;
}

Add comment · Show 1 · Share

tingham · Nov 05, 2010 at 07:16 PM 0

Share

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

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

2 Replies

Your answer

Welcome to Unity Answers

Follow this Question

Related Questions