'************************************************************************* ' ' Licensed to the Apache Software Foundation (ASF) under one ' or more contributor license agreements. See the NOTICE file ' distributed with this work for additional information ' regarding copyright ownership. The ASF licenses this file ' to you under the Apache License, Version 2.0 (the ' "License"); you may not use this file except in compliance ' with the License. You may obtain a copy of the License at ' ' http://www.apache.org/licenses/LICENSE-2.0 ' ' Unless required by applicable law or agreed to in writing, ' software distributed under the License is distributed on an ' "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY ' KIND, either express or implied. See the License for the ' specific language governing permissions and limitations ' under the License. ' '************************************************************************* ' Be sure that all variables are dimensioned: option explicit ' REQUIRED VARIABLES for interface/service tests: ' Required for com.sun.star.xml.sax.XDocumentHandler Global vXMLData As Variant ' Required for procedure CheckImport Global sValue As String ' Required for com.sun.star.document.XImporter: Global oSrcDocument As Object Sub CreateObj() '************************************************************************* ' COMPONENT: ' sc.XMLImporter '************************************************************************* On Error Goto ErrHndl oDoc = utils.createDocument("scalc", cObjectName) oObj = createUnoService("com.sun.star.comp.Calc.XMLImporter") oSrcDocument = oDoc oObj.setTargetDocument(oDoc) sValue = "XMLContentImporter_test" vXMLData = Array( _ Array("start", "office:document-content", _ "xmlns:office", "CDATA", "http://openoffice.org/2000/office", _ "xmlns:text", "CDATA", "http://openoffice.org/2000/text", _ "xmlns:table", "CDATA", "http://openoffice.org/2000/table", _ "office:class", "CDATA", "spreadsheet"), _ Array("start", "office:body"), _ Array("start", "table:table", _ "table:name", "CDATA", sValue), _ Array("end", "table:table"), _ Array("end", "office:body"), _ Array("end", "office:document-content")) Exit Sub ErrHndl: Test.Exception() End Sub Function CheckImport() As Boolean Dim res As Boolean Dim sheets As Object out.log("checking of import...") sheets = oDoc.getSheets() res = sheets.hasByName(sValue) out.log("checking result: " + res) CheckImport() = res End Function