创建/保存Excel文件会导致运行时错误 [英] Creating/Saving Excel file gives run time error

问题描述

在服务器中创建并保存Excel文件，并将该文件传输到客户端计算机在本地计算机上运行良好.但是发布网站后，当我们创建该excel文件时会出现运行时错误.

由于它在本地和服务器上都可以正常工作，因此我们无法识别特定的错误.

我只需要即时帮助...

OP评论:

感谢您的回应....
它在本地以及服务器上都可以正常工作，但是在发布网站后，当客户端访问该网站并尝试下载该excel文件时，它仅显示运行时错误.实际上，我的工作是将数据集转换为excel文件并保存在服务器中，然后将excel文件传输到客户端计算机.如果您说我需要安装Excel，那么我该如何安装Excel.


我也无法知道哪种类型的错误.我可能认为IIS中存在一些读写权限设置问题.我已经通过了这些权限，但是没有得到任何解决方案

Creating and saving Excel file in server and that file transferring to the client machine is working fine in local machine. But after publishing the website, when we create that excel file gives run time error.

Because of it''s working fine in local as well as in server, we can''t recognize the specific error.

I just need immediate help...

OP comment:

Thanx for your response....
It works fine in local as well as server but after publishing website when a client vistis that site and try to download that excel file it shows only Runtime Error. Actually my work is i am converting a dataset to excel file and saves in server then i am trasnfering that excel file to client machine. If you are saying I need to install Excel then how can i install Excel.


I am unable to know which type of error also. I may think there is some read write permission setting problem in IIS. I have already gone through those permissions but i am not getting any solution

推荐答案

您好SunilP，
您的服务器中具有MS Office软件包.如果没有，请安装它.

Hi SunilP,
In your server has MS office package.If not then install it.

这似乎是IIS权限问题.

检查您是否对所访问的文件夹具有适当的读/写权限.

谢谢，
欢呼

This seems to be IIS permission issue.

Check whether you have proper read/write permission of the folde you are accessing.

Thanks,
cheers

授予对您域的全部权限，右键单击，>属性>安全选项卡提供权限，并且必须安装服务器MS Office ...

give the full permission to your domain, right click, > Properties> security tab give the permissions and your server MS Office must be installed...

这篇关于创建/保存Excel文件会导致运行时错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！