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