// 取得資料表
public SingleExcelEx GetExcelSheet(string ExcelFilename, string SheetName)
{
// 判定檔案是否存在
if (Utility.IsFileExist(ExcelFilename) == false)
{
return(null);
}
// 判定檔案類型是否正確
if (ExcelFilename.Contains(".xls") == false)
{
return(null);
}
// 找詢記憶體
string strKeyWord = string.Format("{0}_{1}", ExcelFilename, SheetName);
if (m_dictMap.ContainsKey(strKeyWord) == false)
{
SingleExcelEx Result = new SingleExcelEx(ExcelFilename, SheetName);
m_dictMap[strKeyWord] = Result;
}
return(m_dictMap[strKeyWord]);
}
// 做檔案轉換
private void Button_Translate_Click(object sender, EventArgs e)
{
if (m_listFilename.Count == 0)
{
MessageBox.Show("請拖檔案進來處理");
return;
}
// 檔案一個一個處理
foreach (string strFilename in m_listFilename)
{
Dictionary <string, SingleExcelEx> dictExcel = ExcelExMgr.instance().GetExcelSheet(strFilename);
List <string> listSheetName = new List <string>(dictExcel.Keys);
foreach (string SheetName in listSheetName)
{
SingleExcelEx Single = dictExcel[SheetName];
// 做存檔的動作 - Server
Single.SaveToJson("../Login/GameData/");
// 做存檔的動作 - Client
Single.SaveToJson("../../SanguoClient/Assets/JsonTxt/");
}
}
MessageBox.Show("轉換成功");
}
