Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jul 04, 2012 05:30 PM by Brian_Burgit
Jul 01, 2012 12:58 PM|LINK
I have a web page that displays a DataGrid and now the customer wants there to be an option to open that data as an Excel file. I am able to create the Excel file and save it to the server, but cannot figure out how to open it. I did get a solution working
in VS, but that uses Interop. I’ve read on various forums where Microsoft does not recommend that, and in addition, I cannot find the dll to copy to my web server to even attempt to get that to work. Shouldn’t there be an easy way to just open an existing
Excel file? Does anyone provide similar functionality, and if so, how did you get it to work?
Jul 01, 2012 01:24 PM|LINK
work with something similar to content-type setting. i guess ms-excel is the syntax to achieve the post task. Also the post is as basis with no truth to solution. past did recalled and putting it to you. chekc
Jul 02, 2012 09:02 AM|LINK
I noticed your questions and it seemed to me that you need to display the data in Excel file (import data from datagrid to Excel ), and don't want to use Interop. Then why not you use Olebd(As Excel is a database technically, but that not allow format operation )
or find free API or components for this?
Jul 04, 2012 05:30 PM|LINK
I've tried a couple of free API solutions but got various errors with each. I am currently trying to use Process.Start("file.xls"). This also works in my dev environment. However, the website is hosted at GoDaddy and running it there gives me this security
The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file
I tried setting the trust level to Full in the web.config file, but I can't accress the machine.config file at GoDaddy to allow an override for this setting.