Integrating Domino with Office 2000 via XML (Page 5)

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

Home
EasyPrint
News details

Articles-only

Twitter Feed

Integrating Domino with Office 2000 via XML (continued)


Print |<xml>|

Print |<o:OfficeDocumentSettings>|

Print |<o:DownloadComponents/>|

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

Print |</o:OfficeDocumentSettings>|

Note: Remember that the vertical bar (i.e., the | character) is used in LotusScript as a multi-line delimiter. But it also is very useful as the string delimiter when you want to include quotes in your strings (as you would when generating HTML).

In addition to lots of new tags and attributes, Office introduces a whole set of CSS tags specific to its own documents. These tags won't be interpreted by browsers (although Microsoft may introduce this for Internet Explorer). All such tags begin with the mso- prefix (e.g. "mso-number-format: general" or "mso-protection:locked visible"). These two tags illustrate the way Office uses CSS both in its traditional use: to format text, and to pass settings specific to an application, such as cell protection for spreadsheets.

Here's an illustration of the styles for <TD> items (the tag for each cell of an HTML table) which has the following styles:


td {mso-style-parent:style0; padding:0px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; 	text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; 	vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}

Any of these styles can be overridden or set inside ordinary HTML tags. To change your heading font to Verdana, for instance, you'd use the following:


	<TH style='font-family:Verdana'>

The bare bones
The internal structure of a single Excel XHTML document should follow the outline we'll describe in the next few sections. First of all, switch off the Domino HTTP header, so that you have full control over the resulting Web document:


Print |Content-Type: text/plain|Print |Content-Type: text/html|

Now you're going to create an <HTML> tag with the XML namespaces. If you intend to create custom Office document properties, be sure to include the namespace for dt, the datatype schema:


Print |<html xmlns:o="urn:schemas-microsoft-com:office:office"|

Print |xmlns:x="urn:schemas-microsoft-com:office:excel"|

Print |xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"|

Print |xmlns="http://www.w3.org/TR/REC-html40";>|

Create the HTML header, with META tags to identify the document as an Excel Web file:


Print |<head>|

Print |<meta http-equiv=Content-Type content="text/html; charset=windows-1252">|

Print |<meta name=ProgId content=Excel.Sheet>|

Print |<meta name=Generator content="Microsoft Excel 9">|