private void CreateTxtFromExcel(object sender, RoutedEventArgs e)
{
System.Data.DataSet ds;
string inPath = Assist.RootPath + "Excel/";
try
{
Assist.GetObjPaths(".xlsx", inPath).ForEach(delegate(string path)
{
ds = Assist.ExcelToData(path);
Assist.ExcelToTxt(path, ds);
});
MessageBox.Show(".excel -> .txt 完成！");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Txt2Xml(object sender, RoutedEventArgs e)
{
System.Data.DataTable dt;
string inPath = Assist.RootPath + "Txt/";
string filePath = "";
try
{
Assist.GetObjPaths(".txt", inPath).ForEach(delegate(string path)
{
filePath = path;
dt = Assist.TxtToData(path);
Assist.TxtToXML(path, dt);
});
MessageBox.Show("Txt -> Xml (for Server) 完成！");
}
catch (Exception ex)
{
MessageBox.Show(filePath + "," + ex.Message);
}
}