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;
}
