public void Export(ExcelData excelData)
{
var info = excelData.Table;
if (info == null)
{
return;
}
List <string> desc, types, keys;
Filter(info, out desc, out types, out keys);
string tableName = desc[0];
List <List <string> > appendDesc = new List <List <string> >();
if (GlobalSetting.ServerAppendNote)
{
appendDesc.Add(desc);
}
if (GlobalSetting.ServerAppendType)
{
appendDesc.Add(types);
}
OleDbExcel.RemoveFirstColumu(ref appendDesc);
OleDbExcel.RemoveFirstColumu(ref info);
ExcelConvert excelConvert = new ExcelConvert();
excelConvert.Export(GlobalSetting.ServerOutputPath + "/" + tableName + "_Server.xlsx", "Server", info, types, appendDesc);
}
public bool Load()
{
if (File.Exists(_filePath))
{
_table = OleDbExcel.GetExcelData(_filePath);
if (_table != null)
{
_tableName = _table[0][0];
return(true);
}
}
return(false);
}
public void Export(ExcelData excelData)
{
List <List <string> > info = excelData.Table;
if (info == null)
{
return;
}
//忽略列数
OleDbExcel.RemoveFirstColumu(ref info);
List <string> desc, keys, types;
Filter(info, out desc, out types, out keys);
//转换为lua
new LuaConvert().Export(excelData.TableName, GlobalSetting.ClientOutputPath, info, desc, types, keys);
}
