does anyone knows how to use OWC to manipulate Word documents? I can't seem to find anything about it, and google just gave me Excel related articles. any help? thanks, alex.
does anyone knows how to use OWC to manipulate Word documents? I can't seem to find anything about it, and google just gave me Excel related articles. any help? thanks, alex.
1.OWC (Office Web Components) and MS Project Web Access
Hello, I have to install Ms Project Server on a network where the client PCs don't have Microsoft Office installed. But they have MS Project Professional 2003. OWC (Office Web Components) are needed for Project Web Access to build the Views based ont he OLAP Cube (Analysis services). I was told that a Project licence give the right for an OWC licence. But where can i download these OWC and how to install them ? Thanks for your help,
2.Office 2003 Basic Edition and OWC (Office Web Components)
Office 2003 Basic Edition and OWC (Office Web Components) Hello, should OWC (Office Web Components) work with Excel 2003 from the Basic Edition? Actually, even after re-installing the OWC from CD or the MS download site, they do not work. After de-installing the Office 2003 Basic Edition, and installing Office 2003 Professional, the OWC work fine... Thanks Ernst
3.Exporting Data to Excel using Office Web Components (OWC) in ASP.NET
I have the following cod ******************** SqlDataAdapter sqlAdapter = new SqlDataAdapter() sqlAdapter.SelectCommand = cmd SqlDataReader reader = cmd.ExecuteReader() int numbercols = reader.FieldCount; int row=1; while (reader.Read()) for (int i=0;i<numbercols;i++) { xlsheet.ActiveSheet.Cells[row,i+1] = reader.GetValue(i).ToString() row++ } reader.Close() sqlConnRes = objSQL.CloseSQLconn(sqlConnRes) cmd.Dispose() xlsheet.ActiveSheet.Export("\\\\net_serv\\datarepository\\Templates\\Excel\\test.csv",OWC.SheetExportActionEnum.ssExportActionNone) ******************** When executed I keep getting this error eventhough I have mess with the security rights off this folder. I have no idead to what specific user is wanting the security right for. Please HEL Exception from HRESULT: 0xE004002A. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Exception from HRESULT: 0xE004002A.
4.Impersonation issue With Office Web Component (OWC)
We are trying to initiate an OWC on the server side using the impersonation properties in the connection string (Roles=Role1,Role2;) to connect to an Analysis Service Cube, but it's failing. It looks like when you initiate the OWC on the server side it doesn't have a valid SSPI context. It works fine until you restrict security on the cube. Once a cube is restricted, the component does not bring back any data from it. What we are trying to do is create scheduled reports that are mailed out once a night to the users so the reports will be in their mailbox as soon as they come into work. Some of the dimensions are secured via OLAP Roles and we want the users to be sent "their" view of the data so we add the user's role list to the connection string. All of this has to be done through OWC; we don't think we can use Reporting Services for this because the report formats are stored as an OWC XMLData property definition. Here are the steps that we are doing to accomplish this: 1) The user opens up their web portal - No problem here 2) The user creates a report that they want to see every morning - Still no problem 3) The user then clicks on the subscription button and then fills in the appropriate information. (Daily, weekly, monthly) 4) The report with the user information and time schedule is then saved in a table to be query nightly 5) A process will run nightly and run all the necessary reports for that day - This is where we are having our problem When we try to initiate the OWC on the server and use the person that created the report login information as part of the connection string, it fails. Thinking that the OWC was running under a different impersonation context, we added every possible account on the server to the local admin and OLAP admin group and still no luck. What we are wondering is if this is even possible because when we do this on the client side everything works great. On the server, seems like there is no SSPI context. Thank you, Patrick Gill
5.Office Web Components (OWC) 11 and 64-bit OS
I am having trouble figuring out why some of this VB.NET code does not work on 64-bit OS. Basically, we use MS' interop to speak to the OWC. I have a form (ctlPivot) that holds a pivot table and during the initialization of the form, we do the BeginInit and EndInit methods to initialize the pivot table control: CType(Me.MyPivotTable, System.ComponentModel.ISupportInitialize).BeginInit() Me.MyPivotTable.OcxState=CType(resources.GetObject("MyPivotTable.OcxState"),System.Windows.Forms.AxHost.State) ' at the end: CType(Me.MyPivotTable, System.ComponentModel.ISupportInitialize).EndInit() When that last line is called, it gives me this error: System.Runtime.InteropServices.COMException occurred ErrorCode=-2147221164 Message="Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))" Source="System.Windows.Forms" StackTrace: at System.Windows.Forms.UnsafeNativeMethods.CoCreateInstance(Guid& clsid, Object punkOuter, Int32 context, Guid& iid) at System.Windows.Forms.AxHost.CreateWithoutLicense(Guid clsid) at System.Windows.Forms.AxHost.CreateWithLicense(String license, Guid clsid) at System.Windows.Forms.AxHost.CreateInstanceCore(Guid clsid) at System.Windows.Forms.AxHost.CreateInstance() at System.Windows.Forms.AxHost.GetOcxCreate() at System.Windows.Forms.AxHost.TransitionUpTo(Int32 state) at System.Windows.Forms.AxHost.CreateHandle() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.AxHost.EndInit() at ctlPivot.InitializeComponent() Now, I am not sure if the stack trace is the same path even when it works on 32-bit OS. Are the CreateWithoutLicense and CreateWithLicense methods a clue that maybe something is wrong with the license or does it go through this path no matter what? I can start Excel but I can not activate it as it is a VLK and I think all the keys got used up (the person who set it up is supposed to fix that but for now I am trying to figure out if that matters or if there is something else). If not, what Class is not registered? Any help would be appreciated. All of this works on 32-bit OS so I am not quite sure what could be wrong if it is not the license. Thank you.
6. OWC (office web components) pivottable conected to analysis services fails
7. Printing Excel OWC ( Office Web Components )
8. URGENT Exporting Data to Excel using Office Web Components (OWC) in ASP.NET
Users browsing this forum: No registered users and 66 guest