Email:   


Home
In This Issue
Email a Friend
EasyPrint
Click here for the RSS feed's XML code. This is not a browser URL.


MICROSOFT OFFICE INTEGRATION
Integrating Domino with Office 2000 via XML
By Jeffrey R. Burrows

Back in the October 1998 issue of DominoPower (see http://www.dominopower.com/issues/issue199810/excel001.html), I previewed for you some of the features Microsoft would deliver with Office 2000 using XML technology, and showed how some of that power could be exploited right away with Excel 97. The article demonstrated how it was possible to dynamically create an HTML spreadsheet from a Lotus Notes view, suitable for viewing by any Web browser, but with Domino-generated additional Excel specific functionality built into it -- features such as cross-tabs and totals based on formulae rather than sums hard-coded in HTML.

Well, Office 2000 has been delivered, XML's a much bigger splash than it was in late 1998, and you might be wondering what new levels of integration you can bring to your intranet sites. In this article I'll explain what Microsoft has actually delivered with Office 2000, and how you can go about marrying its power to that of Domino. Don't be alarmed by all the "X-onyms" -- the article doesn't presume too much acquaintance with XML or the hundreds of new acronyms arising around it.

Web documents in 2000
The major new feature of Office 2000 is that almost all of its functions can be supported in HTML documents, whereas previously a proprietary binary format was used. This might seem a minor change, but the potential for Office intranet use is enormous. While it's true that Office 97 could read and write HTML (with the help of an add-on or two), the resulting Web files lost a great deal of the rich content of an Office document, producing plain HTML sufficient for browser display but insufficient for re-using the document in Office.

For example, if you saved an Excel 97 sheet in HTML format, all the formulae would be lost, as would macros, templates, advanced cell formatting options, and anything else other than a basic HTML table, with the same text, numbers, and some basic coloring and layout that a good Web browser could understand. If another Excel user were to open the HTML file, she'd load only the text, numbers, and layout that the browser could read. Lacking formulae, the sheet would no longer automatically recalculate macros and much of the cell formatting would be lost. The situation in Word and PowerPoint would be similar. PowerPoint slides, for example, would come back in as single large image files, rather than separate graphics and text bullets, so text couldn't be edited and would have to be airbrushed out and retyped.





[ Next ]

-- Advertisement --

2-Minute Tutorials
How do I...

  • integrate MS Office or OpenOffice with Notes?
  • create cross-tab reports and charts?
  • print serial letters and mailing labels?
  • create PDFs in Lotus Notes?


Check out the 2-minute tutorials here.
-- Advertisement --

DEPARTMENT CALENDAR - MANAGE AND SHARE A COMMON CALENDAR WITH YOUR TEAMS
Are you responsible for improving your organization's Group Calendaring tool? Have you been tasked to find a true group calendar tool with Itinerary, Time-Off, Sign In/Out and Bulletins/Events module that seamlessly integrates with Domino calendaring?

If so, Logic Springs Technologies will make answering these questions a whole lot easier!

Learn how by visiting us at: http://www.departmentcalendar.com

Copyright © 1998-2008, ZATZ Publishing. All rights reserved worldwide.