1:Excel表方便策划配置数据,但是跨平台读取不方便
2:Excel表转Json,方便跨平台读取
源码下载:https://download.youkuaiyun.com/download/LinZhonglong/12762704
Excel表读取
所需文件:excel.dll 和 ICSharpCode.SharpZipLib.dll (文末云盘链接)
//读取Excel表数据
DataRowCollection collect = ExcelAccess.ReadExcel(“excel表名”, “excel sheet表名”);
for (int i = 1; i < collect.Count; i++)
{
if (collect[i][1].ToString() == "") continue;
{
“i行 0列” =collect[i][0].ToString(),//行列数据
“i行 1列” = collect[i][1].ToString(),
“i行 2列”= collect[i][2].ToString(),
“i行 3列” = collect[i][3].ToString(),
};
}
static DataRowCollection ReadExcel(string excelName, string sheetName)