读取Excel
来源:互联网 发布:java cpu占用高 分析 编辑:程序博客网 时间:2024/06/05 16:44
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();
*/
}
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();
*/
}
阅读全文
0 0
- 读取excel
- EXCEL读取
- 读取excel
- 读取excel
- 读取Excel
- 读取Excel
- 读取excel
- 读取excel
- excel读取
- 读取Excel
- 读取excel
- 读取excel
- excel读取
- excel读取
- Excel 读取
- 读取excel
- Excel读取
- 读取excel
- 进程池线程池
- Java连接Oracle(标准方式)
- Centos 7.3 基于HTTP配置本地局域网YUM
- 当删除Servers后Java resources中出现错误
- date 格式化
- 读取Excel
- 玲珑杯 1124
- unity 通过使用 photon networking Pun 实现 HTC Vive VR的多人联网。进阶版 《一》
- OK6410驱动之led(只用指定的设备号)
- org.apache.ibatis.builder.IncompleteElementException: Could not find result map xxMapper.
- 如何构建前端代码
- 第三方库编译启示
- 《Effective C++》(五)
- 如何更改matlab启动时的默认路径?