public static int GetExcelData(string excelFileName, ExcelData exceldata ,string excelpath) { DBExcelHelper test = new DBExcelHelper(excelFileName); if (test.LoadExcelFile()) { Logger.InfoFormat("Read Excel File Name :{0}" ,excelFileName ); foreach (Sheetdata sheetdata in exceldata.sheetDatalist) { test.ClearData(); int result = test.GetContent(sheetdata.sheetName); Logger.InfoFormat("Get Sheet Content :{0}", sheetdata.sheetName); if (0 == result) { string outfilename = Directory.GetCurrentDirectory() + excelpath + "temp/" + exceldata.GetFileName() + "." + sheetdata.sheetName + ".txt"; SaveExcelData(outfilename, test.outstring); } } test.Close(); } return 0; }