1<?xml version="1.0" encoding="UTF-8"?> 2<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd"> 3<script:module xmlns:script="http://openoffice.org/2000/script" script:name="sc_XMLExporter" script:language="StarBasic"> 4 5 6'************************************************************************* 7' 8' Licensed to the Apache Software Foundation (ASF) under one 9' or more contributor license agreements. See the NOTICE file 10' distributed with this work for additional information 11' regarding copyright ownership. The ASF licenses this file 12' to you under the Apache License, Version 2.0 (the 13' "License"); you may not use this file except in compliance 14' with the License. You may obtain a copy of the License at 15' 16' http://www.apache.org/licenses/LICENSE-2.0 17' 18' Unless required by applicable law or agreed to in writing, 19' software distributed under the License is distributed on an 20' "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 21' KIND, either express or implied. See the License for the 22' specific language governing permissions and limitations 23' under the License. 24' 25'************************************************************************* 26 27 28 29 30 31' Be sure that all variables are dimensioned: 32option explicit 33 34 35' REQUIRED VARIABLES for interface/service tests: 36 37' Required for com.sun.star.lang.XInitialization: 38 Global aInitArgs() As Variant 39 40' Required for com.sun.star.document.XFilter: 41 Global oFilterDescriptor As Variant 42 43' Required for com.sun.star.document.XExporter: 44 Global oSrcDocument As Object 45 46 47Sub CreateObj() 48 49'************************************************************************* 50' COMPONENT: 51' sc.XMLExporter 52'************************************************************************* 53On Error Goto ErrHndl 54 Dim initArgs(0) As Object 55 Dim oMSF As Object 56 Dim filter As Variant 57 Dim printXML As Boolean 58 Dim Tag1, Tag2, Tag3, Tag4, Tag5, Tag6, Tag7, Tag8 As Variant 59 Dim expString As String 60 Dim oSheets As Object 61 Dim oSheet As Object 62 63 printXML = true 64 expString = "NewNameOfSheet" 65 oMSF = getProcessServiceManager() 66 oDoc = utils.createDocument("scalc", cObjectName) 67 oDocHandler = oMSF.createInstanceWithArguments("basichelper.DocumentHandler", Array(printXML)) 68 69 Tag1 = Array("office:document") 70 Tag2 = Array("office:meta") 71 Tag3 = Array("office:settings") 72 Tag4 = Array("office:script") 73 Tag5 = Array("office:styles") 74 Tag6 = Array("office:body") 75 Tag7 = Array("table:table") 76 Tag8 = Array("table:table", "table:name", expString) 77 filter = Array( _ 78 Array("TagExists", Tag1, Tag8), _ 79 Array("TagEnclosed", Tag2, Tag1), _ 80 Array("TagEnclosed", Tag3, Tag1), _ 81 Array("TagEnclosed", Tag4, Tag1), _ 82 Array("TagEnclosed", Tag5, Tag1), _ 83 Array("TagEnclosed", Tag6, Tag1), _ 84 Array("TagEnclosed", Tag7, Tag6) _ 85 ) 86 87 oDocHandler.initialize(filter) 88 89 initArgs(0) = oDocHandler 90 aInitArgs = initArgs() 91 oObj = oMSF.createInstanceWithArguments("com.sun.star.comp.Calc.XMLExporter", initArgs()) 92 93 oSheets = oDoc.getSheets() 94 oSheet = oSheets.getByIndex(0) 95 oSheet.setName(expString) 96 97 oObj.setSourceDocument(oDoc) 98 99 Dim aFilterDescr(0) As New com.sun.star.beans.PropertyValue 100 aFilterDescr(0).Name = "FilterName" 101 aFilterDescr(0).Value = "scalc: StarOffice XML (spreadsheet)" 102 oFilterDescriptor = aFilterDescr() 103 104 oSrcDocument = oDoc 105 106Exit Sub 107ErrHndl: 108 Test.Exception() 109End Sub 110 111Global oDocHandler As Object 112 113Function checkFilter() As Boolean 114 checkFilter = oDocHandler.getByName("XMLIsCorrect") 115 Out.Log(oDocHandler.getByName("XMLCode")) 116End Function 117</script:module> 118