public XmlHandlerTest()
{
string fileDir = @"D:\github\res\TestCase1.xlsx";
ExcelAnalysisByEpplus excelAnalysis = new ExcelAnalysisByEpplus(fileDir);
_tcDic = excelAnalysis.ReadExcel();
}
public TestSuiteGeneratorTest()
{
string fileDir = @"D:\github\TestLinkConverter\TestLinkConverter\bin\Debug\TestCase_20190912105226.xlsx";
ExcelAnalysisByEpplus excelAnalysis = new ExcelAnalysisByEpplus(fileDir);
_tcDic = excelAnalysis.ReadExcel();
}
/// <summary>
/// Excel转换为XML
/// </summary>
/// <param name="fileDir">文件路径</param>
private void ExcelToXml(string fileDir)
{
_ = GoogleAnalyticsTracker.Tracker("Work", "ExcelToXml");
try
{
ExcelAnalysisByEpplus excelAnalysis = new ExcelAnalysisByEpplus(fileDir);
_tcDic = excelAnalysis.ReadExcel();
}
catch (Exception ex)
{
this._logger.Error(ex);
OutputDisplay.ShowMessage(ex.ToString(), Color.Red);
return;
}
}
/// <summary>
/// Excel转换为XML
/// </summary>
/// <param name="fileDir">文件路径</param>
private void ExcelToXml(string fileDir)
{
try
{
ExcelAnalysisByEpplus excelAnalysis = new ExcelAnalysisByEpplus(fileDir);
_tcDic = excelAnalysis.ReadExcel();
XmlHandler xh = new XmlHandler(_tcDic);
xh.WriteXml();
}
catch (Exception ex)
{
this._logger.Error(ex);
OutputDisplay.ShowMessage(ex.ToString(), Color.Red);
return;
}
}
public void SetUp()
{
string filePath = @"E:\Github\TestLinkConverter\Resource\TestCase.xlsx";
this._excelAnalysisByEpplus = new ExcelAnalysisByEpplus(filePath);
}