I am trying to figure out if the disclaimer below still applies to the .NET Framework 4.0:Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
I was under the impression that the new version of the Framework uses some magic to avoid PIA deployment and somehow one is allowed to manipulate Interop objects ... I do not know enough to figure this on my own. The simple question is: is it possible to open an Excel workbook from within an ASP.NET page, change something in it, save it and do not blow anything in the process?
I would like to generate word reports on the web server. My web host does not have office installed, and from what I've read it´s not recommended to use word on the server.
Now, I just recently found this out, and I more or less counted on the reporting stuff being quite simple to set up.
This is what I need.
The user logs in and uploads data, changes it, calculates it and so on. When this is done he will need to generate a report, although preferably in a format he can edit (like maybe adding a comment or a logo or whatever).
How do I do this? This really needs to look professional so features like page breaks and other kinds of formatting is needed.
It is sufficient if the document is generated and not opened on the server. I think I can require the user to have office installed locally in order to actually open the document and maybe print it. But the content must be generated from the sql database.
I created a web application in which I am generating a ms-word document using Microsoft.Office.Interop.Word dll. The application is running fine in the visual studio but when I tried to run on IIS 5.0 through virtual directory then its giving the following error -
Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80070005.
In my application I have taken reference of Microsoft Word 12.0 Object Library, but its coming as Microsoft.Office.Interop.Word dll, this interop dll is just a wrapper of the actual word COM dll. But I have to register the actual word COM dll. so my problem is to find -
1) The path of the original word dll(COM)
2) How to register this dll, either using regsvr32 or to register on IIS.
When this html code is saved as .html file and browsed, we get a file download dialog box. I wantt this to be automated instead of manually browsing in a web browser.
I want to test my site using selenium which is an automated test tool where we have to code, and in my scenario I have excel file which I want to download but on download box there is save button but i want to know how to click on Save button ...
I have an object on my asp.net page hosting a Silverlight xap (in my particular case it is in an IFrame, but I'm curious about regular objects as well). I can find the element in UI Spy, but the name just says "Silverlight Control". Trying to find that AutomationElement in my automated test is unsuccessful (control is null every time). Is there a setting in the Silverlight code or in the html that would help? How can I distinguish it if there are multiple Silverlight controls on the same page?
I am developing the Windows Live@edu SSO integration with asp.net custom code.It uses the DLL called "System.Management.Automation" for executing Windows powershell v2.0 commands for connecting Outlook Live Apps.It works fine in localhost,but during deployment in Windows server 2008 , it shows error called
Could not load type 'System.Management.Automation.Runspaces.PSSession' from assembly 'System.Management.Automation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'."
I have an old COM+ object that we've used to create AD user accounts with information from our HR system. This process has been broken since a recent upgrade, so I'm attempting to modify the object to point to a new DC and a new inforamtion store during mailbox creation. After modifying the code I am unable to get an account to be crated and the following error appears:error '8007202f' Automation error A constraint violation occurredI am not a developer and I know that this is a long shot but if anyone has any insight into if this is an AD issue or one with VB 6, any help at all would be greatly appreciated. I think this is the relevent code but again, I'm an admin not a developer:
I've got a website that needs to create an Excel File using the Excel object library and then makes it available for download by the user.This of course works fine in my dev environment on my local machine. I getCould not load file or assembly 'office, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
The machine is running 64 bit Windows 2008 Server, and the version of office is 2003 SP3 (yes I know its old, but it does run normally). I'm thinking its a registration issue, but I don't know how to register Excel with the site in IIS 7.0.The development machine (on which everything runs fine), is an XP box. I've noticed that Excel is installed to a different path on the Server 'C:Program Files (x86)Microsoft OfficeOFFICE11' as opposed to 'C:Program FilesMicrosoft OfficeOFFICE11' on the XP box.
I am trying to work with the Windows clipboard and Office Interop in an ASP.NET web application.Everything works well on my local machine running XP (i have created a Windows application first which ran perfectly well on local machine). Then I have executed it on a server running Windows Server 2003 and it worked there as well.Then I made a ASP.NET sample project and it worked on my local machine. However when this time I deployed it at the server, after banging my head with permissions, it started giving me this exception which i have no idea why it is doing this:
System.Runtime.InteropServices.COMException (0x80048240): Shapes (unknown member): Invalid request. Clipboard is empty or contains data which may not be pasted here. at Microsoft.Office.Interop.PowerPoint.Shapes.Paste()
Is the problem with any sort of permissions again on clipboard? If yes, how can I grant appropriate permissions?
I want create my output in excel file. But in server i cannot install office, its too costly i am developing it with vishual studio2005 with vb. so anybody can give the solution for this.
I am currently working on a project where I need to secure access to downloadable files. The solution I want to implement is to have two buttons next to each document. One that says Editable and the other read-only (depending on the users permission they will see one of these or both). The editable will work normally with the browser dialogue opening to say open / save the document. That is the easy part. The read-only button needs to open the document without caching anything (in temporary internet files) on the client's machine for security reasons or give the ability to save it to their local machine.
The best Idea I have for this is to convert the document to HTML on the fly and then redirect the user to this page. We can then turn caching off on the site so the HTML isn't cached (I know they can then right-click and save the HTML or copy the text,etc.. but that is deemed acceptable). Does anyone have an alternative solution than this (or have an easy way this can be achieved)? I don't want to install Office on the web server or pay heavily for a third-party tool like Aspose.
In my asp.net page, I am creating excel file using Office.Interop and saving. The application works correctly in my local. When I am deploying in Win 2003 server I am getting below Error. I don't have excel installed in server.
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005
I am creating a pivot table excel sheet in my ASP .NET web application using Microsoft Office Interop Excel 12.0 components. It is creating the excel file correctly, when i run it from my Visual Studio 2008 in Debug/Release mode.
But when i deploy the solution in IIS 7, first i got some permission issues, which i resolved by giving permission in the DCOMCNFG file. Now i am getting the following error, when trying to open the Excel file:
[code]....
These are the code which i used to open and close the excel application object
I would like to build a Shared Documents Library in ASP .Net and SQL Server but I have a problem, the customer wants to open the documents (stored in SQL Server) in Office UI and when save it, the document should be saved directly in database like SharePoint Server.
I've been researched on web since last week and I didn't found any answer or specific technology to do this.
I wrote some code about sending mail, Task, Appoinment etc. For example you can add someone to your outlook contact list over asp.net page. Every thing is ok on my local machine. But if I publish my application to a server I can not add noone on my outlook.
I've got an ASP 4.0 website running on IIS 7.0 . Part of the web site creates an Excel document using C#, due to company policy I'm stuck with Excel 2003. I've noticed that when I deploy the site and use the part that creates the Excel file, its running Excel application object with the login of the user accessing the site. This causes problems with access rights to the Server.
How do I set the server up to run the Excel application using a fixed account? I've got the Application pool running under one, and I thought that would solve the problem, but it doesn't seem to.
I am developing a document reference system which has a treeview control on the left with the document titles. Once a node is clicked the corresponding document loads in an iframe to the right of the tree. Everything works perfect if the document is in pdf format but word and other office documents don't display the way the client would want. They would like the document to resize the way that the pdf's do inside the iframe.
I am faced with a rather tricky issue. I am developing a web application that resides beneath a web site. The web application is actually meant for the employees of the company owning the web site. The employees can access the web app from the login facility on the site.
The situation demands that an employee must be able to login to the app only from the office machines and not from anywhere outside. I thought of a logic where in the IP address of the machine in which the employee sits will be stored against the employee profile and when he logs in, the authentication will check for user credentials as well as whether he is logging from the designated IP. If not he is not allowed access to the app even if the login credentials where correct.
I am not sure if this is a good way, because I feel tricky persons can give the same IP of the office machine in another machine, say at home and the logic is broken. Can somebody provide me a better way of solving the issue. I am using ASP.Net login control for user login.