讀取excel文檔内容的方法,不過xls 和xlsx字尾不同,裡邊内容有些許不同。
此方法需要用到Excel.dll
/// <summary>
/// 隻讀Excel方法
/// </summary>
/// <param name="ExcelPath"></param>
/// <returns></returns>
public static void GameReadExcel(string ExcelPath)
{
FileStream stream = File.Open( ExcelPath, FileMode.Open, FileAccess.Read);
//IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);//xlsx
IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);//xls
DataSet result = excelReader.AsDataSet();
int columns = result.Tables[0].Columns.Count;//擷取列數
int rows = result.Tables[0].Rows.Count;//擷取行數
//從第二行開始讀
for (int i = 1; i < rows; i++)
{
for (int j = 0; j < columns; j++)
{
string nvalue = result.Tables[0].Rows[i][j].ToString();
Debug.Log(nvalue);
}
}
}