C#操作openoffice writer文档

</pre>主要的功能是实现对openoffice writer文档的新建、保存、插入表格、图片等<pre name="code" class="csharp">//References are: you can find them in the GAC or in the 3.x sdk 
//cli_basetypes.dll 
//cli_cppuhelper.dll 
//cli_oootypes.dll 
//cli_uno.dll 
//cli_ure.dll 
//cli_uretypes.dll 

using System; 
using System.Collections; 
using System.Runtime.InteropServices; 
using System.Text; 
//For Marshal and Registry 
using Microsoft.Win32; 
/* 
* Add all needed CLI namespaces to the current class. 
*/ 
using unoidl.com.sun.star.lang; 
using unoidl.com.sun.star.uno; 
using unoidl.com.sun.star.bridge; 
using unoidl.com.sun.star.frame; 
using unoidl.com.sun.star.text; 
using uno.util; 

namespace OOOCLI 
{ 
    class OpenOfficeApp 
    { 
        //Define a file name. Change this to an existing path! 
        private static string FileName = @"F:\odtfiles\test.odt"; 
        
            public static void OOOStart() 
        { 
            // ***********************    Connection 
            //Necessary with OOO3 and NetFramework less than 3.5 (see: 
            //   http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/ProUNO/CLI/CLI_Language_Binding 
            // & http://blog.nkadesign.com/2008/net-working-with-openoffice-3/ . 
            InitOpenOfficeEnvironment(); 

            //From Lars Behrmann: OpenOffice programming with C# / .net http://www.opendocument4all.com/ 
            
            // ***********************    First Steps to Load a document 
            //Call the bootstrap method to get a new ComponentContext object. 
            //If OpenOffice isn't already started this will start it and then return the ComponentContext. 
            unoidl.com.sun.star.uno.XComponentContext localContext = uno.util.Bootstrap.bootstrap(); 

            //Get a new service manager of the MultiServiceFactory type 
            //we need this to get a desktop object and create new CLI objects. 
            unoidl.com.sun.star.lang.XMultiServiceFactory multiServiceFactory = (unoidl.com.sun.star.lang.XMultiServiceFactory)localContext.getServiceManager(); 
            
            //Create a new Desktop instance using our service manager 
            //Notice: We cast our desktop object to XComponent loader 
            //so that we could load or create new documents. 
            XComponentLoader componentLoader =(XComponentLoader)multiServiceFactory.createInstance("com.sun.star.frame.Desktop"); 
            
            //Create a new blank writer document using our component loader object. 
            XComponent xComponent = componentLoader.loadComponentFromURL( 
            "private:factory/swriter", //a blank writer document 
            "_blank", 0, //into a blank frame use no searchflag 
            new unoidl.com.sun.star.beans.PropertyValue[0]);//use no additional arguments. 

            // ***********************    Working with text 
            // -------------------      First and simple Method 
            //Cast our component to a the XText interface 
            
            //and write some simple text into document. 
           // ((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().setString("Hello I'm the first text!"); 

            // From sdk WriterDemo.vb translate and enhanced to C# by Marc FEGLI http://pagesperso-orange.fr/hffm/index.html 
            // -------------------      Second and complete Method 
            Cast our component to a the XText interface: Create a text object 
            XText xText = ((XTextDocument)xComponent).getText(); 
            XSimpleText xSimpleText = (XSimpleText)xText; 

            //Create a cursor object 
            XTextCursor xCursor = xSimpleText.createTextCursor(); 
            // C# characters for Backspace ... "\r" and "\n" 
            //Inserting some Text 
            xText.insertString(xCursor, "The first line in the newly created text document." + "\r", false); 

            //Create instance of a text table with 4 columns and 4 rows 
            object objTextTable = null; 
            objTextTable = ((XMultiServiceFactory)xComponent).createInstance("com.sun.star.text.TextTable"); 
            XTextTable xTextTable = (XTextTable)objTextTable; 
            xTextTable.initialize(4, 4); 
            xText.insertTextContent(xCursor, xTextTable, false); 


            //Set the table background color 
            // Get XPropertySet interfaces from Table object 
            unoidl.com.sun.star.beans.XPropertySet xPropertySetTable = (unoidl.com.sun.star.beans.XPropertySet)objTextTable; 
            xPropertySetTable.setPropertyValue("BackTransparent", new uno.Any(false)); 
            xPropertySetTable.setPropertyValue("BackColor", new uno.Any(0xccccff)); 

            //Get first row 
            unoidl.com.sun.star.table.XTableRows xTableRows = xTextTable.getRows(); 
            uno.Any anyRow = default(uno.Any); 
            anyRow = ((unoidl.com.sun.star.container.XIndexAccess)xTableRows).getByIndex(0); 

            //Set a different background color for the first row 
            // Get XPropertySet interface from Row object 
            unoidl.com.sun.star.beans.XPropertySet xPropertySetFirstRow = (unoidl.com.sun.star.beans.XPropertySet)anyRow.Value; 
            xPropertySetFirstRow.setPropertyValue("BackTransparent", new uno.Any(false)); 
            xPropertySetFirstRow.setPropertyValue("BackColor", new uno.Any(0x6666aa)); 
            
            //Fill the first table row 
            //Delegate Methods: see insertIntoCell 
            insertIntoCell("A1", "FirstColumn", xTextTable); 
            insertIntoCell("B1", "SecondColumn", xTextTable); 
            insertIntoCell("C1", "ThirdColumn", xTextTable); 
            insertIntoCell("D1", "SUM", xTextTable); 

            //Fill the remaining rows 
            xTextTable.getCellByName("A2").setValue(22.5); 
            xTextTable.getCellByName("B2").setValue(5615.3); 
            xTextTable.getCellByName("C2").setValue(-2315.7); 
            xTextTable.getCellByName("D2").setFormula("sum <A2:C2>"); 

            xTextTable.getCellByName("A3").setValue(21.5); 
            xTextTable.getCellByName("B3").setValue(615.3); 
            xTextTable.getCellByName("C3").setValue(-315.7); 
            xTextTable.getCellByName("D3").setFormula("sum <A3:C3>"); 

            xTextTable.getCellByName("A4").setValue(121.5); 
            xTextTable.getCellByName("B4").setValue(-615.3); 
            xTextTable.getCellByName("C4").setValue(415.7); 
            xTextTable.getCellByName("D4").setFormula("sum <A4:C4>"); 

            //Change the CharColor and add a Shadow 
            // Get XPropertySet interface from Cursor object 
            unoidl.com.sun.star.beans.XPropertySet xPropertySetCursor = (unoidl.com.sun.star.beans.XPropertySet)xCursor; 
            xPropertySetCursor.setPropertyValue("CharColor", new uno.Any(255)); 
            xPropertySetCursor.setPropertyValue("CharShadowed", new uno.Any(true)); 

            //Create a paragraph break 
            xSimpleText.insertControlCharacter(xCursor, unoidl.com.sun.star.text.ControlCharacter.PARAGRAPH_BREAK, false); 

            //Inserting colored Text. 
            xSimpleText.insertString(xCursor, " This is a colored Text - blue with shadow" + "\r", false); 

            //Create a paragraph break 
            xSimpleText.insertControlCharacter(xCursor, unoidl.com.sun.star.text.ControlCharacter.PARAGRAPH_BREAK, false); 

            //Create a GraphicObject. 
            object objGraphicObject = null; 
            objGraphicObject = ((unoidl.com.sun.star.lang.XMultiServiceFactory)xComponent).createInstance("com.sun.star.text.GraphicObject"); 

            unoidl.com.sun.star.text.XTextContent xGraphicObject = (unoidl.com.sun.star.text.XTextContent)objGraphicObject; 

            //Set the size of the GraphicObject 
            unoidl.com.sun.star.awt.Size GraphicObjectSize = new unoidl.com.sun.star.awt.Size(5000, 5000); 
            ((unoidl.com.sun.star.drawing.XShape)xGraphicObject).setSize(GraphicObjectSize); 

            //Set anchortype 
            unoidl.com.sun.star.beans.XPropertySet xPropertySetGraphicObject = (unoidl.com.sun.star.beans.XPropertySet)xGraphicObject; 
            xPropertySetGraphicObject.setPropertyValue("AnchorType", new uno.Any(typeof(unoidl.com.sun.star.text.TextContentAnchorType), unoidl.com.sun.star.text.TextContentAnchorType.AS_CHARACTER)); 

            //Set Picture path: 
            // First Method with OOO notation for Windows Notation see PathConverter method 
            xPropertySetGraphicObject.setPropertyValue("GraphicURL", new uno.Any("file:///C:/test.jpg")); 
            
            //insert the GraphicObject 
            xText.insertTextContent(xCursor, xGraphicObject, false); 

            //Create a TextFrame. 
            object objTextFrame = null; 
            objTextFrame = ((unoidl.com.sun.star.lang.XMultiServiceFactory)xComponent).createInstance("com.sun.star.text.TextFrame"); 

            unoidl.com.sun.star.text.XTextFrame xTextFrame = (unoidl.com.sun.star.text.XTextFrame)objTextFrame; 

            //Set the size of the frame 
            unoidl.com.sun.star.awt.Size FrameSize = new unoidl.com.sun.star.awt.Size(15000, 400); 
            ((unoidl.com.sun.star.drawing.XShape)xTextFrame).setSize(FrameSize); 

            //Set anchortype 
            unoidl.com.sun.star.beans.XPropertySet xPropertySetFrame = (unoidl.com.sun.star.beans.XPropertySet)xTextFrame; 
            xPropertySetFrame.setPropertyValue("AnchorType", new uno.Any(typeof(unoidl.com.sun.star.text.TextContentAnchorType), unoidl.com.sun.star.text.TextContentAnchorType.AS_CHARACTER)); 

            //insert the frame 
            xText.insertTextContent(xCursor, xTextFrame, false); 

            //Get the text object of the frame 

            unoidl.com.sun.star.text.XText xFrameText = xTextFrame.getText(); 

            unoidl.com.sun.star.text.XSimpleText xFrameSimpleText = (unoidl.com.sun.star.text.XSimpleText)xFrameText; 

            //Create a cursor object 
            unoidl.com.sun.star.text.XTextCursor xFrameCursor = xFrameSimpleText.createTextCursor(); 

            //Inserting some Text 
            xFrameSimpleText.insertString(xFrameCursor, "The first line in the newly created text frame.", false); 
            xFrameSimpleText.insertString(xFrameCursor, "\r" + "With this second line the height of the frame raises.", false); 

            //Create a paragraph break 
            xSimpleText.insertControlCharacter(xFrameCursor, unoidl.com.sun.star.text.ControlCharacter.PARAGRAPH_BREAK, false); 

            //Change the CharColor and add a Shadow 
            xPropertySetCursor.setPropertyValue("CharColor", new uno.Any(65536)); 
            xPropertySetCursor.setPropertyValue("CharShadowed", new uno.Any(false)); 

            //After we insert our text, we cast our component to XStorable to save it onto the harddisk 
            ((XStorable)xComponent).storeToURL(PathConverter(FileName),          //Convert the file path into a OpenOffice path 
            //no additional arguments 
            new unoidl.com.sun.star.beans.PropertyValue[0]); 
            Console.WriteLine("Your first OpenOffice document is saved!"); 
            Console.ReadLine(); 
        } 
        private static void insertIntoCell(string sCellName, string sText, unoidl.com.sun.star.text.XTextTable xTable) 
        { 
            unoidl.com.sun.star.table.XCell xCell = xTable.getCellByName(sCellName); 

            unoidl.com.sun.star.text.XSimpleText xSimpleTextCell = (unoidl.com.sun.star.text.XSimpleText)xCell; 

            unoidl.com.sun.star.text.XTextCursor xCursor = xSimpleTextCell.createTextCursor(); 

            unoidl.com.sun.star.beans.XPropertySet xPropertySetCursor = (unoidl.com.sun.star.beans.XPropertySet)xCursor; 

            xPropertySetCursor.setPropertyValue("CharColor", new uno.Any(0xffffff)); 
            xSimpleTextCell.insertString(xCursor, sText, false); 
        } 
        /// <summary> 
        /// Convert into OO file format 
        /// </summary> 
        /// <param name="file">The file.</param> 
        /// <returns>The converted file</returns> 
        private static string PathConverter(string file) 
        { 
            try 
            { 
                file = file.Replace(@"\", "/"); 
                return "file:///"+file; 
            }catch(System.Exception ex) 
            { 
                throw ex; 
            } 
        } 

        private static void InitOpenOfficeEnvironment() 
        { 
            //from http://blog.nkadesign.com/2008/net-working-with-openoffice-3/ 
            string baseKey = null; 
            // OpenOffice being a 32 bit app, its registry location is different in a 64 bit OS 
            if ((Marshal.SizeOf(typeof(IntPtr)) == 8)) 
            { 
                baseKey = "SOFTWARE\\Wow6432Node\\OpenOffice.org\\"; 
            } 
            else 
            { 
                baseKey = "SOFTWARE\\OpenOffice.org\\"; 
            } 

            // Get the URE directory 
            string key = (baseKey + "Layers\\URE\\1"); 
            RegistryKey reg = Microsoft.Win32.Registry.CurrentUser.OpenSubKey(key); 
            if ((reg == null)) 
            { 
                reg = Registry.LocalMachine.OpenSubKey(key); 
            } 
            string urePath = (string)reg.GetValue("UREINSTALLLOCATION"); 
            reg.Close(); 
            urePath = System.IO.Path.Combine(urePath, "bin"); 
            // Get the UNO Path 
            key = (baseKey + "UNO\\InstallPath"); 
            reg = Microsoft.Win32.Registry.CurrentUser.OpenSubKey(key); 
            if ((reg == null)) 
            { 
                reg = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(key); 
            } 
            string unoPath = (string)reg.GetValue(null); 
            reg.Close(); 

            string path = null; 
            path = string.Format("{0};{1}", System.Environment.GetEnvironmentVariable("PATH"), urePath); 
            System.Environment.SetEnvironmentVariable("PATH", path); 
            System.Environment.SetEnvironmentVariable("UNO_PATH", unoPath); 
        } 
    } 

    } 

转载地址：http://www.oooforum.org/forum/viewtopic.phtml?t=94558