office

How can I expose an Office file using Silverlight?

I'd like to expose Office (Excel, Word) files from a web site. I understand Office 14 now provides Silverlight components to view/edit Office files. What do I need to setup on my web site to use these components? ...

Best way to create programmatically Office document previews viewable in a browser?

Several possibilities come to mind: Convert to Flash (using a software like print2flash) - but that's very brittle as it requires using a print driver... Convert to SVG (using a software like svgmaker) - but that requires a plugin in Explorer Convert to HTML using the Office API - but that's only viewable in Explorer Ideally the outp...

How do I make an editable UNION query?

In the course of a complex database structure, I need to provide the user with a means of editing data stored in a series of tables. Although all the data types are the same, they don't line up 1:1 in their names. To alleviate this, I created a query that maps the original names (which come from outside reports) to the internally-used ...

To check whether Office is installed in a server

How do I programmatically find whether MS OFfice is installed in a list of server in a Windows Network. ...

MS Word Viewer C# .NET automation....

Is it possible to automate the following: referencing MS Word Viewer to open a document programatically and then print it? C# ideally Im guessing if it is possible to open it then more than likely it will be possible to print it. I've tried adding a reference to COM Object in Visual Studio .. MS Office 11 / 12 Object Library but MS Wo...

Getting back to the same instance of Outlook 2007?

Hello! My problem is that I assigned a shortcut to Outlook like this: "C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE" and this worked fine and just like I wanted it to: when pressing the key I came back to this oneandonly instance of Outlook all the time. Then something happened and I lost this behavior with the shortcut key,...

Convert docx to xlsx

Hello, I am writting .NET application that generates reports in docx. One of the last requirements I've got was - generate also these reports in xlsx format. So, is there any simple way to convert docx to xlsx format? I haven't found any solution or utility/library. One of the ideas was to use Microsoft.Office.Interop Copy/Paste method...

Office integration (Word) - intercepting save

I am planning to implement a small in-house document management system. It must have a web GUI for managing a remote folder structure stored in a database. In these folders are word documents stored (physically as blob in a database). Whenever a user clicks on a document link, a word binary is downloaded via browser and (hopefully) opene...

Library that takes Microsoft Office files (word/excel/ppt) and renders images of them?

I'm building a webapp, and I need the ability for users to view Word/Excel/PPT files in the browser (these files are stored server-side). This is to offer them a quick way to preview the document without needing to download it and launch Microsoft Office. Pretty much looking for the "View" feature for email attachments in GMail. I'm a...

Diagnosing an OLEDB exception when Quering Excel 2010

To query an excel sheet via SQL, I used to use either: Dim excelConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strPath + ";Extended Properties=""Excel 8.0;IMEX=1;HDR=YES;""" or Dim excelConnectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " + strPath + ";Extended Properties=""Ex...

C# Accessing Excel Worksheet

Is this the correct way to access a MS Office Excel 2007 file? String connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + file_path + ";Extended Properties=Excel 8.0;"; If so, how do I access a certain worksheet and insert rows? Links are also welcomed. ...

Excel OleConnection Insert Statements

How would insert a row into an excel document. This is what I have. String connString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + file_path + ";Extended Properties=Excel 8.0;"; DataTable dt = new DataTable(); DataSet ds = new DataSet(); OleDbConnection conn = new OleDbConnection(connString); ...

Creating Excel or Excel compatible Spreadsheets on the server side in C#

I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed (and they don't want to buy it)....

Word VBA Section break character in

How can you detect if the selection you have contains or is the section break character? At the moment I select a page , collapse to the end , I want to know if the end of the page contains a section break or not. I was going to use a method where I compare the section number at the end of the page , then move two characters forward , ...

Read/write Excel 2007 password-protected documents

What method does Office 2007 use for encryption (when choosing Encrypt and setting a password from Office menu)? My C# app needs to create and read encrypted Excel 2007 files (.xlsx). It is important that these files remain accessible from Excel, so I must use Microsoft's encryption method, can't brew my own. Normal Excel 2007 file is ...

XPS to Doc(x) Conversion via .Net?

Good morning, does anyone know of a (native) .net way to convert xps documents to docx or finally to a normal (non wordml) .doc? As in not using office automation and rather some native (3rd party) .net library that might help me there? Basically the xps > doc transformation will take place on a server with multiple concurrently runnin...

VSTO: Event for Word Doc's Content/Text Changes?

Good afternoon, does anyone know whether it's possible to handle content changes or more precisely whether there's an event for that... one that would notify me if a document's content has been changed (ideally at what position/range etc)? Cheers and thanks, J ...

Installing open XML sdk on 64-bit Windows 2003

I intend to use the Open XML Format SDK 2.0 on 64-bit Windows Server 2003. I have IIS running in 32-bit emulation mode. How should I install the Open XML MSI? Should I leave the default options for installation path? ...

Developing Word add-ins for Macintosh

I have an add-in for Word 2007 developed using VS2008/.NET 3.5. What do I need to do in order for Mac users to use this add-in with their Word 2008? (or did MS made sure it would be impossible to do...) Thanks guys, you saved me a lot of time. ...

Need JET 4.0 Drivers

I am using an ExcelProvider with Microsoft.Jet.OLEDB.4.0 and am getting the Cannot Find Installable ISAM from the production machine. Windows Server 2003. I've searched and search for this download. I've Office installed on the Dev machine, so I'm sure that's why it works fine on my end. But I can't install Office on the Production m...