EXCEL不能从asp.net页获得许可 [英] EXCEL cannot have permission from asp.net page

问题描述

大家好，

我的asp.net网站面临一些困难.我的网页之一接受Excel模板(通过上传Excel文件)并从中读取所有数据，并同时插入到SQL数据库中.

此过程在本地主机上运行顺利，但是当我将其上载到Web服务器中时(我将Web服务器设置在另一台计算机中)，问题就开始了.我的Web服务器已经安装了Microsoft Office2007.

可以上传Excel模板，但是不能将所有数据插入SQL数据库.

我使用Microsoft.Office.Interop.Excel组件进行Excel读写.出乎我的意料，权限问题.我不知道如何在Web服务器中为Microsoft excel设置权限.

请帮我

最佳Rgds，
Beginner

Hi all,

I face a little bit difficulty for my asp.net website. One of my web pages accept Excel template (By Uploading Excel File) and read all the data from it and insert into the SQL Database at the same time.

This process is smoothly running with the localhost but when i upload it inside the web server(i set the Webserver in another computer), the problem started. my web server is already installed Microsoft Office 2007.

Excel Template uploading is OK but all the data cannot be inserted into SQL database.

I use Microsoft.Office.Interop.Excel component for Excel reading and writing. as my expectation, permission problem. i don''t know how to set up permission in web server for microsoft excel.

Pls, Help Me

Best Rgds,
beginner

推荐答案

必须在Web服务器上安装Office，互操作才能正常工作.

不建议在生产服务器上使用Office Excel interop来查看非Office Excel读写器(它们更快并且使用更少的资源).

Office must be installed on your Web Server for the interop to work.

It is unadvised to use Office Excel interop on your production server look into non office Excel readers and writers (which are faster and use less resources).

这篇关于EXCEL不能从asp.net页获得许可的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！