生成Excel报告 [英] generate an excel report

问题描述

先生，

我正在生成excel报告。当我在我的本地主机上生成它然后它成功生成但是当我在远程服务器上生成时，然后出现身份验证窗口。

sir,
i am generating the excel report . when ever i m generating that on my localhost then it is generate successfully but when ever i m generating on remote server then a authentication windows appear.

theWorkbook.SaveCopyAs(fileName);
theWorkbook.Close(false, fileName, true);
byte[] data = ExportImportUtil.StreamFile(fileName);
File.Delete(fileName);
return data;
response.ContentType = "application/xls";
response.OutputStream.Write(fileContent, 0, fileContent.Length);
response.AddHeader("content-disposition", "attachment;filename=" + fileName);

推荐答案

您好Siddharth，



您正在使用工作簿，我认为这就是为什么您必须完全授予您发布的文件夹。

查看本文提及使用String Writer生成Excel报告。

我认为这将有所帮助

请查看。

http://androidsharp.blogspot.in/2013/07/generate- excel-report-on-button-click.html [ ^ ]

Hi Siddharth,

You are using Workbook and all I think that's why you have to give full permission to your published folder.
Check this article its mentioning about generating excel reports using String Writer.
I think it will be helpful
please check it out.
http://androidsharp.blogspot.in/2013/07/generate-excel-report-on-button-click.html[^]

这篇关于生成Excel报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！