public Form1()
{
InitializeComponent();
pathList = FilePathController.PathList();
AddEvent();
}
public void ReadWrite(string readPath, string savePath)
{
if (!IsAvalidPath(readPath, savePath))
{
return;
}
ReadExcelClass readExcelClass = new ReadExcelClass();
List <DataTableClass> dataTableClassList = readExcelClass.Read(readPath);
{ // 导出 CSV
Dictionary <int, List <List <string> > > dataDic = AnalysisCSVClass.AnalysisExcel(dataTableClassList);
WriteCSVClass writeCSVClass = new WriteCSVClass();
writeCSVClass.CreateCSV(dataDic, savePath);
}
{ // 导出 XML
Dictionary <int, List <List <string> > > dataDic = AnalysisXMLClass.AnalysisExcel(dataTableClassList);
WriteXmlClass writeXmlClass = new WriteXmlClass();
writeXmlClass.CreateXML(dataDic, savePath);
}
{ // 导出 CS
Dictionary <string, StringBuilder> fileStringBuilderDic = AnalysisCS.Analysis(dataTableClassList);
WriteCSClass writeCSClass = new WriteCSClass();
writeCSClass.SaveCsToFile(fileStringBuilderDic, savePath);
}
FilePathController.ReplacePathFile(readPath, savePath);
}
