Search DominoPower's 11,964 Lotus-related article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Twitter Feed Click here for the Twitter feed.
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.


1  ·  2  ·  3  ·  4  ·  5  ·  6  ·  7  ·  Next »
Other articles you might like
Home > Internet Technologies > XML (11 articles)
   How to create a Web service to extract data from XML documents
   Building an XML based Content Management System using Lotus Domino: wrapping it up
   Building an XML based Content Management System using Lotus Domino: overview of the content administration system
Home > Microsoft Technologies > Office (7 articles)
   DAMO deep-six: is there a future for Outlook/Domino integration?
   Quick guide to using the Microsoft Outlook 2002 Connector with a Domino server
   How to easily connect Notes and Microsoft Office
Home > Lotus Technologies > Domino (77 articles)
   More about Domino log files
   Why your log.nsf might not be purging properly
   Sloppy analysis at the core of another Domino vs. SharePoint report
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Recent DominoPower Articles
It's time for Lotus to double-down on Linux and open source
Back to basics with Notes: what you can do now
Back to basics with Notes: what are the basics?
Back to basics with Notes
Smart Upgrade bug in Domino 8.5.1 (and some work-around tips)
Hands-on with XPages and the Lotus Solutions Catalog
A tool for migrating Exchange to Domino
Latest Lotus Headlines
IBM Lotus Quickr for WebSphere Portal 8.5 - Various Notes on Administration
Attachment Viewer on Steroids
Admin tip: Predictor, a pregnancy test for your Domino server
Lotus Traveler Webinar
Domino 8.5.1 mail routing problem solved
A small tip for upgrading your XPages apps from 8.5.1 to 8.5.2
What is in your plugin_customization.ini?
>> Read all the news
More from the ZATZ journals
Computing Unplugged: Smartphone smarts for a mobile world
David Gewirtz Online: CNN commentary and analysis
OutlookPower: The strange case of Outlook losing notes and requiring passwords
-- Advertisement --

Learn Notes and Domino 8 at your place and pace!
Learn Notes and Domino in your office and/or home! TLCC's highly acclaimed distance learning courses for users, developers, and admins will enhance your career and your resume.

The many included activities and demos will make you a pro! Expert instructor help is a click away.

Click here to try a FREE demo course!!

-- Advertisement --

Want the top Lotus experts by your side without paying hefty consulting fees?
Look no further.

Like having a team of consultants by your side -- ones who have all the answers and never make mistakes -- THE VIEW gives you immediate access to field-tested instruction, guidance, and best practices from the brightest Lotus professionals around.

See the new instruction, advice, and best practices added to THE VIEW this week.

ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
Copyright © 1998-2010, ZATZ Publishing. All rights reserved worldwide.
Editor's Login