|
|
|
|
|
|
|
|
|
|
|
|
|
|
Integrating Domino with Office 2000 via XML (continued)
For example, Excel XHTML documents will have the following declaration:
<html xmlns:o="urn:schemas.microsoft.com:office/office"
xmlns:x="urn:schemas.microsoft.com:office/excel"
xmlns=urn:w3-org-ns:HTML>
|
This declares three separate namespaces, one each for generic Office names, Excel, and HTML. The last declaration's different in that there's no prefix. This indicates that all tags and parameters without a prefix are assumed to be plain HTML, making coding much simpler, and also allowing XHTML documents to pretend to be HTML documents.
These three namespaces could be used as below:
<o:DocumentProperties>
<o:Created>2000-01-13T12:00:12Z</o:Created>
</o:DocumentProperties>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
</x:Name>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
<table>
<tr><td>Table Cell</td></tr>
</table>
|
Note how the XML names closely match the existing COM document object models for Excel and Office. The tags don't, however, match those used in the preview of XML incorporated into Excel 97. For example, the FORMULA attribute (as used on the <TD> tag) is now known as X:FMLA, but used in the same fashion, as below:
<td align=right x:num x:fmla="=A3+B4-B12">200.12</td>
|
Putting on the Style
When Office documents try to transfer the format of the original document to HTML, they use a mixture of CSS v1, CSS v2, and conditional HTML. This means that a browser that only supports CSS v1 will still be able to show some basic formatting, although not with the precision and variety that a CSS v2 capable browser will display. The conditional HTML involves commented IF and ENDIF statements that select HTML code for specific platforms, to work around the different ways various systems will treat the same HTML code.
While it's possible to create a single Web file containing the HTML, XML, and dataset and have it successfully open into Excel, there's a different method used by Excel when saving files. It'll generate a single master Web page, containing all the XML to describe the workbook. Then it'll separate files into a sub folder for each worksheet, a table of contents in XML called filelist.xml, formatting in stylesheet, CSS, and the workbook tabs in tabstrip.htm, plus images and macro files as required. The master file holds all of this together in two separate ways -- by building a frameset for display in a Web browser and by means of <LINK> tags for the benefit of Excel.
If interactivity has been selected in the file save box, the Web pages are built using the Office Web Components, with the XML for charts or worksheets created as escaped XML parameters for the objects. The code itself isn't included, being a sizable download, but the location of the components can be set as a parameter within the XML document properties. If you create your own Office Web pages from Domino, you have full control of where this location's set, as this example LotusScript code shows:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- Advertisement --
Find unused Lotus Notes groups and clean up your address book
Have you ever wanted to get rid of old Lotus Notes groups that were cluttering up your address book, but you weren't sure if they were used? Find Unused Groups can help.
Find Unused Groups will check your mail and ACL groups to help you determine if they are used, and who uses them.
Learn how to easily clean up your address book. |
-- Advertisement --
Mark your calendar for in-depth Lotus training, May 12-14, Boston
Join experts and peers May 12-14 in Boston for educational and networking events that deliver real-world Lotus training so you can increase productivity and efficiency in your company, advance your skills, and squeeze the most from your current environment. One registration gets you into THE VIEW's Admin2010 and Lotus Developer2010.
Register by December 31 to save $350. |
|
|
|
|
|
|
|
|
|
|
