Search DominoPower's 10,675 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 (6 articles)
   Quick guide to using the Microsoft Outlook 2002 Connector with a Domino server
   How to easily connect Notes and Microsoft Office
   How to query Domino from within Excel
Home > Lotus Technologies > Domino (69 articles)
   Centralised email encryption at the Domino server level
   Getting the Domino server time with @Now
   When the email flood inundates the Domino Server
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
What to look for in a Domino-based document management solution
Understanding Domino.doc end-of-life options
When the debugger won't debug hidden code that isn't hidden
What to do if the LotusScript debugger won't single-step over code
Top 10 ways to launch and build a Lotus consulting practice (with a little help from the Beatles)
Troubleshooting an OpenSuse Notes install
Incident report: denial of service attack against ConnectedPhotographer.com
Latest Lotus Headlines
SnTT - Enabling ALL the bells and whistles!
Tivoli Data protection causes Domino to crash
Fun when running DB2 CLP scripts
Introducing Flippr, the easy way to admin Quickr
DXL and fake security
Using search forms in IBM Workplace Collaborative Learning 2.7
Schmidt, Freed, and Gering on the OVF Toolkit
>> Read all the news
More from the ZATZ journals
Computing Unplugged: Eight steps to successful and reliable home backups
David Gewirtz Online: CNN commentary and analysis
OutlookPower: Can Outlook run when it's not running (and other mysteries)?
-- 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 --

Sophisticated Meets Simple For Document Management
Share. Control. Manage.
Documents, emails, and content in the context of how work is done. Native to Lotus Domino. The User Experience unseen for Lotus Domino. Do more with less. Really.

See the possibilities Docova unleashes for Lotus Domino.
ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
Copyright © 1998-2009, ZATZ Publishing. All rights reserved worldwide.
Editor's Login