/// <summary> /// 将数据源导出到Excel中并输出到客户端下载 /// </summary> /// <param name="fileName">文件的名称</param> /// <param name="passWord">工作薄的保护密码</param> /// <param name="errorMessage">导出过程中的错误信息</param> /// <param name="fileFormatType">导出的文件的类型(Excel2007,Excel2003 ...)</param> /// <returns>导出结果,是否成功</returns> public bool ExportToExcel(string fileName, string passWord, ref string errorMessage, FrameWork.Core.Office.FileFormatType fileFormatType) { return(this.ExportToExcel(fileName, passWord, ref errorMessage, fileFormatType, Encoding.Default)); }
/// <summary> /// 将数据源导出到Excel中,并保存到本地路径 /// </summary> /// <param name="filePath">Excel文件导出的路径,需包含文件名称</param> /// <param name="passWord">工作薄的保护密码</param> /// <param name="errorMessage">生成过程中的异常信息</param> /// <param name="fileFormatType">保存的文件的类型(Excel2007,Excel2003 ...)</param> /// <returns>生成的结果</returns> public bool Save(string filePath, string passWord, ref string errorMessage, FrameWork.Core.Office.FileFormatType fileFormatType) { return(this.Save(filePath, passWord, ref errorMessage, Encoding.UTF8, fileFormatType)); }
/// <summary> /// 将数据源导出到Excel中,并保存到本地路径 /// </summary> /// <param name="filePath">Excel文件导出的路径,需包含文件名称</param> /// <param name="passWord">工作薄的保护密码</param> /// <param name="errorMessage">生成过程中的异常信息</param> /// <param name="encoding">导出文件所用的文本编码</param> /// <param name="fileFormatType">保存的文件的类型(Excel2007,Excel2003 ...)</param> /// <returns>生成的结果</returns> public bool Save(string filePath, string passWord, ref string errorMessage, Encoding encoding, FrameWork.Core.Office.FileFormatType fileFormatType) { return(this.SaveAndExport(filePath, passWord, ref errorMessage, fileFormatType, encoding, SaveType.Default)); }
/// <summary> /// 将数据源导出到Excel中并输出到客户端下载 /// </summary> /// <param name="fileName">文件的名称</param> /// <param name="passWord">工作薄的保护密码</param> /// <param name="errorMessage">导出过程中的错误信息</param> /// <param name="fileFormatType">导出的文件的类型(Excel2007,Excel2003 ...)</param> /// <param name="encoding">导出文件所用的文本编码</param> /// <returns>导出结果,是否成功</returns> public bool ExportToExcel(string fileName, string passWord, ref string errorMessage, FrameWork.Core.Office.FileFormatType fileFormatType, Encoding encoding) { return(this.SaveAndExport(fileName, passWord, ref errorMessage, fileFormatType, encoding, SaveType.OpenInExcel)); }