Index: vhUnitTest/TECH/File/impl/ExcelXml2003Writer.cls.xml
===================================================================
diff -u
--- vhUnitTest/TECH/File/impl/ExcelXml2003Writer.cls.xml	(revision 0)
+++ vhUnitTest/TECH/File/impl/ExcelXml2003Writer.cls.xml	(revision 1276)
@@ -0,0 +1,157 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<Export generator="Cache" version="24">
+<Class name="vhUnitTest.TECH.File.impl.ExcelXml2003Writer">
+<IncludeCode>vhLib.Macro</IncludeCode>
+<Super>vhUnitTest.TestCase</Super>
+
+<Parameter name="XmlDeclaratie">
+<Type>%String</Type>
+<Default><![CDATA[<?xml version="1.0" encoding="UTF-8"?>]]></Default>
+</Parameter>
+
+<Parameter name="WorkbookOpenTag">
+<Type>%String</Type>
+<Default><![CDATA[<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet ">]]></Default>
+</Parameter>
+
+<Parameter name="WorksheetOpenTag">
+<Type>%String</Type>
+<Default><![CDATA[<Worksheet ss:Name="Werkbladnaam"><Table>]]></Default>
+</Parameter>
+
+<Parameter name="WorksheetCloseTag">
+<Type>%String</Type>
+<Default><![CDATA[</Table></Worksheet>]]></Default>
+</Parameter>
+
+<Property name="XmlWriter">
+<Type>%XML.Writer</Type>
+<Private>1</Private>
+</Property>
+
+<Method name="TestLegeWerkboek">
+<Implementation><![CDATA[
+	// Actie
+	Set ExcelWriter = ##class(TECH.File.impl.ExcelXml2003Writer).%New()
+	Do ExcelWriter.ZetWriter( ..XmlWriter )
+	Do ExcelWriter.StartWerkboek()
+	Do ExcelWriter.EindigWerkboek()
+
+	// Controle
+	Set VerwachteString = 
+		..#XmlDeclaratie _ $$$CRLF _
+		"<Workbook xmlns=""urn:schemas-microsoft-com:office:spreadsheet"" xmlns:ss=""urn:schemas-microsoft-com:office:spreadsheet ""/>"
+	
+	Do $$$AssertEquals( VerwachteString, ..XmlWriter.GetXMLString()	)
+]]></Implementation>
+</Method>
+
+<Method name="TestWerkboekMet1LeegWerkblad">
+<Implementation><![CDATA[
+	// Actie
+	Set ExcelWriter = ##class(TECH.File.impl.ExcelXml2003Writer).%New()
+	Do ExcelWriter.ZetWriter( ..XmlWriter )
+	Do ExcelWriter.StartWerkboek()
+	Do ExcelWriter.StartWerkblad("Werkbladnaam")
+	Do ExcelWriter.EindigWerkblad()
+	Do ExcelWriter.EindigWerkboek()
+
+	// Controle
+	Set VerwachteString = 
+		..#XmlDeclaratie _ $$$CRLF _
+		..#WorkbookOpenTag _
+		"<Worksheet ss:Name=""Werkbladnaam""><Table/></Worksheet>" _
+		"</Workbook>"
+	
+	Do $$$AssertEquals( VerwachteString, ..XmlWriter.GetXMLString()	)
+]]></Implementation>
+</Method>
+
+<Method name="TestWerkboekMet1WerkbladMet1Cel">
+<Implementation><![CDATA[
+	// Actie
+	Set ExcelWriter = ##class(TECH.File.impl.ExcelXml2003Writer).%New()
+	Do ExcelWriter.ZetWriter( ..XmlWriter )
+	Do ExcelWriter.StartWerkboek()
+	Do ExcelWriter.StartWerkblad( "Werkbladnaam" )
+	Do ExcelWriter.StartRij()
+	Do ExcelWriter.Cel( "InhoudVanCelA1" )
+	Do ExcelWriter.EindigRij()
+	Do ExcelWriter.EindigWerkblad()
+	Do ExcelWriter.EindigWerkboek()
+
+	// Controle
+	Set VerwachteString = 
+		..#XmlDeclaratie _ $$$CRLF _
+		..#WorkbookOpenTag _
+		..#WorksheetOpenTag _
+		"<Row>" _ ..GeefCelTags("InhoudVanCelA1") _ "</Row>" _
+		..#WorksheetCloseTag _
+		"</Workbook>"
+	
+	Do $$$AssertEquals( VerwachteString, ..XmlWriter.GetXMLString()	)
+]]></Implementation>
+</Method>
+
+<Method name="TestWerkboekMet1WerkbladMet2RijenEn2Kolommen">
+<Implementation><![CDATA[
+	// Actie
+	Set ExcelWriter = ##class(TECH.File.impl.ExcelXml2003Writer).%New()
+	Do ExcelWriter.ZetWriter( ..XmlWriter )
+	Do ExcelWriter.StartWerkboek()
+	Do ExcelWriter.StartWerkblad( "Werkbladnaam" )
+	
+	Do ExcelWriter.StartRij()
+	Do ExcelWriter.Cel( "InhoudVanCelA1" )
+	Do ExcelWriter.Cel( "InhoudVanCelB1" )
+	Do ExcelWriter.EindigRij()
+
+	Do ExcelWriter.StartRij()
+	Do ExcelWriter.Cel( "InhoudVanCelA2" )
+	Do ExcelWriter.EindigRij()
+	
+	Do ExcelWriter.EindigWerkblad()
+	Do ExcelWriter.EindigWerkboek()
+
+	// Controle
+	Set VerwachteString = 
+		..#XmlDeclaratie _ $$$CRLF _
+		..#WorkbookOpenTag _
+		..#WorksheetOpenTag _
+		"<Row>" _ ..GeefCelTags("InhoudVanCelA1") _ ..GeefCelTags("InhoudVanCelB1") _ "</Row>" _
+		"<Row>" _ ..GeefCelTags("InhoudVanCelA2") _ "</Row>" _
+		..#WorksheetCloseTag _
+		"</Workbook>"
+	
+	Do $$$AssertEquals( VerwachteString, ..XmlWriter.GetXMLString()	)
+]]></Implementation>
+</Method>
+
+<Method name="GeefCelTags">
+<FormalSpec>Inhoud:%String</FormalSpec>
+<Private>1</Private>
+<ReturnType>%String</ReturnType>
+<Implementation><![CDATA[	Quit "<Cell><Data ss:Type=""String"">" _ Inhoud _ "</Data></Cell>"
+]]></Implementation>
+</Method>
+
+<Method name="OnBeforeOneTest">
+<FormalSpec>aTestName:%String</FormalSpec>
+<Implementation><![CDATA[
+	Do ..SetupXmlWriterToString()
+	Quit ##super(aTestName)
+]]></Implementation>
+</Method>
+
+<Method name="SetupXmlWriterToString">
+<Private>1</Private>
+<Implementation><![CDATA[
+	Set ..XmlWriter = ##class(%XML.Writer).%New()
+	Set ..XmlWriter.Charset="UTF-8"
+	Do ..XmlWriter.OutputToString()
+]]></Implementation>
+</Method>
+</Class>
+
+
+</Export>