/// <summary>
/// 正常导出
/// </summary>
/// <param name="path"></param>
/// <param name="para"></param>
/// <param name="updatesheet">数据表类对象</param>
/// <returns></returns>
public string ExportExcel(string path, QueryParameters para, IGenerateSheet updatesheet)
{
string[] num = path.Split('\\');
string filename = num[num.Length - 1];
string savepath = string.Empty;
try
{
if (System.IO.File.Exists(path))
{
using (FileStream stream = new FileStream(path, FileMode.Open, FileAccess.Read))
{
IWorkbook readworkbook = new XSSFWorkbook(stream);
stream.Close();
readworkbook = updatesheet.GenerateSheet(readworkbook, para);
savepath = SaveFile(readworkbook, filename, para);
}
}
else
{
SystemLog.GetInstance().Info("导出错误：模板信息不存在！");
}
}
catch (Exception e)
{
SystemLog.GetInstance().Error(e);
}
return(savepath);
}
/// <summary>
/// 正常导出
/// </summary>
/// <param name="path"></param>
/// <param name="para"></param>
/// <param name="updatesheet">数据表类对象</param>
/// <returns></returns>
public string ExportExcel(string path, QueryParameters para, IGenerateSheet updatesheet)
{
string[] num = path.Split('\\');
string filename = num[num.Length - 1];
string savepath = string.Empty;
try
{
if (System.IO.File.Exists(path))
{
using (FileStream stream = new FileStream(path, FileMode.Open, FileAccess.Read))
{
IWorkbook readworkbook = new XSSFWorkbook(stream);
stream.Close();
readworkbook = updatesheet.GenerateSheet(readworkbook, para);
savepath = SaveFile(readworkbook, filename, para);
}
}
else
{
SystemLog.GetInstance().Info("导出错误：模板信息不存在！");
}
}
catch (Exception e)
{
SystemLog.GetInstance().Error(e);
}
return savepath;
}