本文整理汇总了C#中IWorkbook.SaveToStream方法的典型用法代码示例。如果您正苦于以下问题：C# IWorkbook.SaveToStream方法的具体用法？C# IWorkbook.SaveToStream怎么用？C# IWorkbook.SaveToStream使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IWorkbook的用法示例。
在下文中一共展示了IWorkbook.SaveToStream方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: RenderXLSheet
/// <summary>
/// Renders the XL sheet.
/// </summary>
/// <param name="workbook">The workbook.</param>
private void RenderXLSheet(IWorkbook workbook)
{
// Stream the Excel spreadsheet to the client in a format
// compatible with Excel 97/2000/XP/2003/2007.
HttpContext.Current.Response.Clear();
if (!string.IsNullOrEmpty(strFileType))
{
if (strFileType.ToLowerInvariant().Equals("csv"))
{
//text/csv
//string attachment = "attachment; filename=SearchResults.csv";
//HttpContext.Current.Response.ContentType = "text/csv";
//HttpContext.Current.Response.AddHeader("Content-Disposition", attachment);
//workbook.SaveToStream(HttpContext.Current.Response.OutputStream, FileFormat.CSV);
string attachment = "filename=SearchResults.csv";
HttpContext.Current.Response.ContentType = "application/force-download";
HttpContext.Current.Response.AddHeader("Content-Disposition", attachment);
workbook.SaveToStream(HttpContext.Current.Response.OutputStream, FileFormat.CSV);
}
else if (strFileType.ToLowerInvariant().Equals("excel"))
{
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=SearchResults.xls");
workbook.SaveToStream(HttpContext.Current.Response.OutputStream, FileFormat.Excel8);
HttpContext.Current.Response.End();
}
else
{
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=SearchResults.xls");
workbook.SaveToStream(HttpContext.Current.Response.OutputStream, FileFormat.Excel8);
HttpContext.Current.Response.End();
}
}
else
{
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=SearchResults.xls");
workbook.SaveToStream(HttpContext.Current.Response.OutputStream, FileFormat.Excel8);
HttpContext.Current.Response.End();
}
}