unity3d 如何设置Excel,一个单元格两种格式。(目...
Unity读取Excel表格数据文件.xls或.xlsx。
方法有:
1. 利用已有的 Unity Excel 个你到 Asset Store 上搜索 Excel 就能找到。或者在 download.csdn.net/detail/u014630768/7723569 下载
2. 利用第三方的操作 Excel 的 .NET 库,把 DLL 导入进 Unity 工程并调用它的功能。比如 ExcelDataReader、EPPlus
unity3d 可以读取excel么
Unity读取Excel表格数据文件.xls或.xlsx。
方法有:
1. 利用已有的 Unity Excel 个你到 Asset Store 上搜索 Excel 就能找到。或者在 download.csdn.net/detail/u014630768/7723569 下载
2. 利用第三方的操作 Excel 的 .NET 库,把 DLL 导入进 Unity 工程并调用它的功能。比如 ExcelDataReader、EPPlus
u3d可以读取excel中的数据吗
using UnityEngine;
using System.Collections;
using System.Data.Odbc;
using System.Data;
public class TestTable : MonoBehaviour
{
private readonly string FILENAME = " TestTable.xls";
[System.Serializable]
public class TestInfo
{
public int id;
public string content;
}
public TestInfo[] testInfoList;
private bool tableReload = false;
public bool TableReload
{
set { tableReload = value; }
get { return tableReload; }
}
public void Load()
{
if (Application.platform == RuntimePlatform.WindowsEditor)
{
ReadInfo();
tableReload = true;
}
}
public void ReadInfo()
{
string fileName = PathForDocumentsFile("/Resources/Data/" FILENAME);
string con = "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=" fileName ";"; // 必存后缀名.xls的
string query = "SELECT * FROM [Sheet1$]";
OdbcConnection oCon = new OdbcConnection(con);
OdbcCommand oCmd = new OdbcCommand(query, oCon);
DataTable dtData = new DataTable("MyData");
oCon.Open();
OdbcDataReader rData = oCmd.ExecuteReader();
dtData.Load(rData);
rData.Close();
oCon.Close();
int Count = 0;
for (int i = 0; i < dtData.Rows.Count; i )
{
int Num = 0;
if (int.TryParse(dtData.Rows[i][0].ToString(), out Num))
{
Count ;
}
}
testInfoList = new TestInfo[Count];
for (int i = 0; i < dtData.Rows.Count; i )
{
int Num = 0;
if (int.TryParse(dtData.Rows[i][0].ToString(), out Num))
{
TestInfo Info = new TestInfo();
Info.id = int.Parse(dtData.Rows[i][0].ToString());
Info.content = dtData.Rows[i][1].ToString();
testInfoList[i] = Info;
}
}
}
public int GetTotalCount()
{
return testInfoList.Length;
}
public TestInfo GetTestInfo(int id)
{
foreach (TestInfo Info in testInfoList)
{
if (Info.id == id) return Info;
}
return null;
}
public string PathForDocumentsFile(string fileName)
{
return Application.dataPath fileName;
}
}
unity 32位 打包exe后读取不到到Excel文件怎么办
using UnityEngine;
using System.Collections;
using System.Data.Odbc;
using System.Data;
public class TestTable : MonoBehaviour
{
private readonly string FILENAME = " TestTable.xls";
[System.Serializable]
public class TestInfo
{
public int id;
public string content;
}
public TestInfo[] testInfoList;
private bool tableReload = false;
public bool TableReload
{
set { tableReload = value; }
get { return tableReload; }
}
public void Load()
{
if (Application.platform == RuntimePlatform.WindowsEditor)
{
ReadInfo();
tableReload = true;
}
}
public void ReadInfo()
{
string fileName = PathForDocumentsFile("/Resources/Data/" FILENAME);
string con = "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=" fileName ";"; // 必存后缀名.xls的
string query = "SELECT * FROM [Sheet1$]";
OdbcConnection oCon = new OdbcConnection(con);
OdbcCommand oCmd = new OdbcCommand(query, oCon);
DataTable dtData = new DataTable("MyData");
oCon.Open();
OdbcDataReader rData = oCmd.ExecuteReader();
dtData.Load(rData);
rData.Close();
oCon.Close();
int Count = 0;
for (int i = 0; i < dtData.Rows.Count; i )
{
int Num = 0;
if (int.TryParse(dtData.Rows[i][0].ToString(), out Num))
{
Count ;
}
}
testInfoList = new TestInfo[Count];
for (int i = 0; i < dtData.Rows.Count; i )
{
int Num = 0;
if (int.TryParse(dtData.Rows[i][0].ToString(), out Num))
{
TestInfo Info = new TestInfo();
Info.id = int.Parse(dtData.Rows[i][0].ToString());
Info.content = dtData.Rows[i][1].ToString();
testInfoList[i] = Info;
}
}
}
public int GetTotalCount()
{
return testInfoList.Length;
}
public TestInfo GetTestInfo(int id)
{
foreach (TestInfo Info in testInfoList)
{
if (Info.id == id) return Info;
}
return null;
}
public string PathForDocumentsFile(string fileName)
{
return Application.dataPath fileName;
}
}
关于在unity里写excel的问题 求大神来解答一下。
using UnityEngine;
using System.Collections;
using System.Data.Odbc;
using System.Data;
public class TestTable : MonoBehaviour
{
private readonly string FILENAME = " TestTable.xls";
[System.Serializable]
public class TestInfo
{
public int id;
public string content;
}
public TestInfo[] testInfoList;
private bool tableReload = false;
public bool TableReload
{
set { tableReload = value; }
get { return tableReload; }
}
public void Load()
{
if (Application.platform == RuntimePlatform.WindowsEditor)
{
ReadInfo();
tableReload = true;
}
}
public void ReadInfo()
{
string fileName = PathForDocumentsFile("/Resources/Data/" FILENAME);
string con = "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=" fileName ";"; // 必存后缀名.xls的
string query = "SELECT * FROM [Sheet1$]";
OdbcConnection oCon = new OdbcConnection(con);
OdbcCommand oCmd = new OdbcCommand(query, oCon);
DataTable dtData = new DataTable("MyData");
oCon.Open();
OdbcDataReader rData = oCmd.ExecuteReader();
dtData.Load(rData);
rData.Close();
oCon.Close();
int Count = 0;
for (int i = 0; i < dtData.Rows.Count; i )
{
int Num = 0;
if (int.TryParse(dtData.Rows[i][0].ToString(), out Num))
{
Count ;
}
}
testInfoList = new TestInfo[Count];
for (int i = 0; i < dtData.Rows.Count; i )
{
int Num = 0;
if (int.TryParse(dtData.Rows[i][0].ToString(), out Num))
{
TestInfo Info = new TestInfo();
Info.id = int.Parse(dtData.Rows[i][0].ToString());
Info.content = dtData.Rows[i][1].ToString();
testInfoList[i] = Info;
}
}
}
public int GetTotalCount()
{
return testInfoList.Length;
}
public TestInfo GetTestInfo(int id)
{
foreach (TestInfo Info in testInfoList)
{
if (Info.id == id) return Info;
}
return null;
}
public string PathForDocumentsFile(string fileName)
{
return Application.dataPath fileName;
}
}