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 /
  • Help Room /
avatar image
0
Question by jay55555 · Jul 06, 2017 at 12:36 AM · script.debugloguntiy3dexcel

Help with displaying Debug.log info to chart on screen when press play. Excel chart to screen of game

I hope this has a simple solution but i am trying to display my chart from excel to the screen of my game. It can be as a GUI or simple text. When i run it the correct information displays at the Debug.log, but now i need it to appear on the screen of the game.

Here is my code, i want to display the Debug.Log info to the game screen.

using UnityEngine; using System.Collections; using System; using System.Data; using System.Data.Odbc;

public class EXCELREADER : MonoBehaviour {

 // Use this for initialization
 void Start()
 {
     
     readXLS(Application.dataPath + "/Book1.xls");
 }

 void OnGui()
 {

 }

 // Update is called once per frame
 void Update()
 {

 }

 void readXLS(string filetoread)
 {
     // Must be saved as excel 2003 workbook, not 2007, mono issue really
     string con = "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=" + filetoread + ";";
     Debug.Log(con);
     string yourQuery = "SELECT * FROM [Fanduel$]";
     // our odbc connector 
     OdbcConnection oCon = new OdbcConnection(con);
     // our command object 
     OdbcCommand oCmd = new OdbcCommand(yourQuery, oCon);
     // table to hold the data 
     DataTable dtYourData = new DataTable("YourData");
     // open the connection 
     oCon.Open();
     // lets use a datareader to fill that table! 
     OdbcDataReader rData = oCmd.ExecuteReader();
     // now lets blast that into the table by sheer man power! 
     dtYourData.Load(rData);
     // close that reader! 
     rData.Close();
     // close your connection to the spreadsheet! 
     oCon.Close();
     // wow look at us go now! we are on a roll!!!!! 
     // lets now see if our table has the spreadsheet data in it, shall we? 

     if (dtYourData.Rows.Count > 0)
     {
         // do something with the data here 
         // but how do I do this you ask??? good question! 
         for (int i = 0; i < dtYourData.Rows.Count; i++)
         {
             //  lets see the column name then the data for that column! 
             Debug.Log(dtYourData.Columns[0].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[0].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[1].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[1].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[2].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[2].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[3].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[3].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[4].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[4].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[5].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[5].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[6].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[6].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[7].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[7].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[8].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[8].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[9].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[9].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[10].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[10].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[11].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[11].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[12].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[12].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[13].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[13].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[14].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[14].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[15].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[15].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[16].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[16].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[17].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[17].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[18].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[18].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[19].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[19].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[20].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[20].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[21].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[21].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[22].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[22].ColumnName].ToString() +
                 "  |  " + dtYourData.Columns[23].ColumnName + " : " + dtYourData.Rows[i][dtYourData.Columns[23].ColumnName].ToString());
     }
     }
 }

}

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

0 Replies

· Add your reply
  • Sort: 

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

108 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 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 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 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

Error at building and executing project. 0 Answers

Keyboards Input not working 1 Answer

Why is my slider going to 100% in this coroutine as soon as it is run?,Why is my slider going to 100% as soon as the method runs? 1 Answer

Assertion failed on expression: 'm_BuffersToBind[shaderType][bind].buffer == NULL' 1 Answer

My downloadHander.Text isnt working 0 Answers


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