OpenOffice学习笔记二创建一个Openoffice文档

好了代码如下.我不废话了

package ansj.sun.os;

import ooo.connector.BootstrapSocketConnector;

import com.sun.star.beans.PropertyValue;
import com.sun.star.beans.XPropertySet;
import com.sun.star.container.XEnumeration;
import com.sun.star.container.XEnumerationAccess;
import com.sun.star.frame.XComponentLoader;
import com.sun.star.frame.XController;
import com.sun.star.frame.XModel;
import com.sun.star.lang.XComponent;
import com.sun.star.lang.XMultiComponentFactory;
import com.sun.star.sheet.XCellAddressable;
import com.sun.star.sheet.XCellRangesQuery;
import com.sun.star.sheet.XSheetCellRanges;
import com.sun.star.sheet.XSpreadsheet;
import com.sun.star.sheet.XSpreadsheetDocument;
import com.sun.star.sheet.XSpreadsheetView;
import com.sun.star.sheet.XSpreadsheets;
import com.sun.star.table.XCell;
import com.sun.star.uno.UnoRuntime;
import com.sun.star.uno.XComponentContext;

public class ConnOpenOffice {
	public static void main(String[] args) {
		try {
			// 连接OpenOffice
			String oooExecFolder = "C:/Program Files/OpenOffice.org 3/program/";
			XComponentContext xRemoteContext = BootstrapSocketConnector
					.bootstrap(oooExecFolder);

			System.out.println("Connected to a running office ...");

			XMultiComponentFactory xRemoteServiceManager = xRemoteContext
					.getServiceManager();

			Object desktop = xRemoteServiceManager.createInstanceWithContext(
					"com.sun.star.frame.Desktop", xRemoteContext);

			XComponentLoader xComponentLoader = (XComponentLoader) UnoRuntime
					.queryInterface(XComponentLoader.class, desktop);

			PropertyValue[] loadProps = new PropertyValue[0];

			XComponent xSpreadsheetComponent = xComponentLoader
					.loadComponentFromURL("private:factory/scalc", "_blank", 0,
							loadProps);

			XSpreadsheetDocument xSpreadsheetDocument = (XSpreadsheetDocument) UnoRuntime
					.queryInterface(XSpreadsheetDocument.class,
							xSpreadsheetComponent);

			XSpreadsheets xSpreadsheets = xSpreadsheetDocument.getSheets();
			xSpreadsheets.insertNewByName("MySheet", (short) 0);
			com.sun.star.uno.Type elemType = xSpreadsheets.getElementType();

			System.out.println(elemType.getTypeName());
			Object sheet = xSpreadsheets.getByName("MySheet");
			XSpreadsheet xSpreadsheet = (XSpreadsheet) UnoRuntime
					.queryInterface(XSpreadsheet.class, sheet);
			XCell xCell = xSpreadsheet.getCellByPosition(0, 0);
			xCell.setValue(21);
			xCell = xSpreadsheet.getCellByPosition(0, 1);
			xCell.setValue(21);
			xCell = xSpreadsheet.getCellByPosition(0, 2);
			xCell.setFormula("=sum(A1:A2)");

			XPropertySet xCellProps = (XPropertySet) UnoRuntime.queryInterface(
					XPropertySet.class, xCell);
			xCellProps.setPropertyValue("CellStyle", "Result");

			XModel xSpreadsheetModel = (XModel) UnoRuntime.queryInterface(
					XModel.class, xSpreadsheetComponent);
			XController xSpreadsheetController = xSpreadsheetModel
					.getCurrentController();
			XSpreadsheetView xSpreadsheetView = (XSpreadsheetView) UnoRuntime
					.queryInterface(XSpreadsheetView.class,
							xSpreadsheetController);
			xSpreadsheetView.setActiveSheet(xSpreadsheet);

			// *********************************************************
			// example for use of enum types
			xCellProps.setPropertyValue("VertJustify",
					com.sun.star.table.CellVertJustify.TOP);

			// *********************************************************
			// example for a sequence of PropertyValue structs
			// create an array with one PropertyValue struct, it contains
			// references only
			loadProps = new PropertyValue[1];

			// instantiate PropertyValue struct and set its member fields
			PropertyValue asTemplate = new PropertyValue();
			asTemplate.Name = "AsTemplate";
			asTemplate.Value = new Boolean(true);

			// assign PropertyValue struct to array of references for
			// PropertyValue
			// structs
			loadProps[0] = asTemplate;

			// load calc file as template
			// xSpreadsheetComponent = xComponentLoader.loadComponentFromURL(
			// "file:///c:/temp/DataAnalysys.ods", "_blank", 0, loadProps);

			// *********************************************************
			// example for use of XEnumerationAccess
			XCellRangesQuery xCellQuery = (XCellRangesQuery) UnoRuntime
					.queryInterface(XCellRangesQuery.class, sheet);
			XSheetCellRanges xFormulaCells = xCellQuery
					.queryContentCells((short) com.sun.star.sheet.CellFlags.FORMULA);
			XEnumerationAccess xFormulas = xFormulaCells.getCells();
			XEnumeration xFormulaEnum = xFormulas.createEnumeration();

			while (xFormulaEnum.hasMoreElements()) {
				Object formulaCell = xFormulaEnum.nextElement();
				xCell = (XCell) UnoRuntime.queryInterface(XCell.class,
						formulaCell);
				XCellAddressable xCellAddress = (XCellAddressable) UnoRuntime
						.queryInterface(XCellAddressable.class, xCell);
				System.out.println("Formula cell in column "
						+ xCellAddress.getCellAddress().Column + ", row "
						+ xCellAddress.getCellAddress().Row + " contains "
						+ xCell.getFormula());
			}

		} catch (java.lang.Exception e) {
			e.printStackTrace();
		} finally {
			System.exit(0);
		}
	}
}