Integrating Domino with Office 2000 via XML (Page 6)

Search DominoPower's 11,441 Lotus-related article archive

Home
EasyPrint
News details

Articles-only

Twitter Feed

Integrating Domino with Office 2000 via XML (continued)

Next comes the XML code, describing the structure of the Office document:


Print |<xml>|

Optionally set some of the basic Document Properties, such as author, company, etc.:


Print |<o:DocumentProperties>|

Print |<o:Created>| & Format$(Now,"YYYY-MM-DDTHH:TT:SSZ") & |</o:Created>|

Print |<o:Author>Jeffrey R Burrows</o:Author>|

Print |<o:Keywords>Excel,XML,Oracle,DECS,Domino,Notes,DominoPower,LotusScript</o:Keywords>|

Print |</o:DocumentProperties>|

Optionally set some of the available generic Office document properties. This is where the location of the Office Web Components files is supplied so that client browsers without the components can download them:


Print |<o:OfficeDocumentSettings>|

Print |<o:DownloadComponents/>|

Print |<o:LocationOfComponents HRef="http://www.myserv.com/o2000/msowc.cab";/>|

Print |</o:OfficeDocumentSettings>|

Optionally set some custom properties. These are common to all Office documents:


Print |<o:CustomDocumentProperties>|

Print |  <o:FinCode dt:dt="string">| & cgiFinCode$ & |</o:FinCode>|

Print |  <o:SQL dt:dt="string">| & Query$ & |</o:SQL>|

Print |  <o:DominoServer dt:dt="string">| & session.CommonUserName & |</o:DominoServer>|

Print |  <o:DominoVersion dt:dt="string">| & session.NotesVersion & |</o:DominoVersion>|

Print | </o:CustomDocumentProperties>|

Next, define the Workbook and each sheet within it:


Print |<x:ExcelWorkbook>|

Print |  <x:ExcelWorksheets>|

Print |   <x:ExcelWorksheet>|

Print |    <x:Name>Enterprise Data via Domino and XML</x:Name>|

Print |<x:WorksheetOptions>|

Print |<x:DoNotDisplayZeros/>|

Print | <x:Selected/>|

Print | <x:Panes>|

Print |  <x:Pane>|

Print |   <x:Number>1</x:Number>|

Print |   <x:ActiveRow>1</x:ActiveRow>|

Print |   <x:ActiveCol>1</x:ActiveCol>|

Print |  </x:Pane>|

Print | </x:Panes>|

Print | <x:ProtectContents>True</x:ProtectContents>|

Print | <x:ProtectObjects>False</x:ProtectObjects>|

Print | <x:ProtectScenarios>False</x:ProtectScenarios>|

Print |</x:WorksheetOptions>|

Print |</x:ExcelWorksheet>|

Print |</x:ExcelWorksheets>|

Print |</x:ExcelWorkbook>|

Print |</xml>|

Print |</head>|

Now create the plain HTML file for viewing by the Web browser, including any additional XML attributes to be passed to Office (e.g., "x:fmla" to specify an Excel formula and CSS formatting for use by browsers and Excel):