读取Excel

最新推荐文章于 2024-10-28 16:45:52 发布

原创最新推荐文章于 2024-10-28 16:45:52 发布 · 270 阅读

CC 4.0 BY-SA版权

本文介绍了一种在Unity环境中使用C#脚本从Excel文件中读取数据的方法。通过创建FileStream并利用ExcelReaderFactory库，可以将Excel数据转换为DataSet进行处理。此教程涵盖了从打开文件到遍历数据的基本步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using System.IO;
using Excel;
using System.Data;
using UnityEngine.UI;

public class TestExcel : MonoBehaviour {

// Use this for initialization
void Start () {

FileStream stream = File.Open(Application.dataPath + "/Book.xlsx", FileMode.Open, FileAccess.Read);

IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);

DataSet result = excelReader.AsDataSet();

int columns = result.Tables[1].Columns.Count;
int rows = result.Tables[1].Rows.Count;

for (int i = 0; i < rows; i++)
{
for (int j = 0; j < columns; j++)
{
string nvalue = result.Tables[1].Rows[i][j].ToString();
if (nvalue!="")
{
print(nvalue);
}
}
}
excelReader.Close();

}

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

}

//public void CreateExcel()
//{
// HSSFWorkbook wk = new HSSFWorkbook();
//}

//
/*
FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read);

//1. Reading from a binary Excel file ('97-2003 format; *.xls)
IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
//...
//2. Reading from a OpenXml Excel file (2007 format; *.xlsx)
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
//...
//3. DataSet - The result of each spreadsheet will be created in the result.Tables
DataSet result = excelReader.AsDataSet();
//...
//4. DataSet - Create column names from first row
excelReader.IsFirstRowAsColumnNames = true;
DataSet result = excelReader.AsDataSet();

//5. Data Reader methods
while (excelReader.Read())
{
//excelReader.GetInt32(0);
}

//6. Free resources (IExcelDataReader is IDisposable)
excelReader.Close();
*/

}