Search DominoPower's 11,320 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
Lotusphere 2010: mobility and collaboration
2010: A Lotusphere of change
Five trends for 2010
DominoPower TV Episode 1: Inside a strategy session with Teamstudio
More about Domino log files
Say goodbye to the Uh-Ohs. Long live the Tens.
Why your log.nsf might not be purging properly
Latest Lotus Headlines
SnTT: XPages Blank Calendar Control (Part 2), adding data
Have your Lotus Notes calendar display multiple time zones
Sample Database for Microsoft Office and Lotus Symphony Integration
Symphony 3.0 beta signals another attack on Office
Enabling DAOS on a database - new recommendation
Need your opinion on some new policy settings for Mail
Sometimes IBM Lotus Domino HTTP RPC Agents aren't the answer...
>> Read all the news
More from the ZATZ journals
Computing Unplugged: The iPad: Apple's latest heartbreaker
David Gewirtz Online: CNN commentary and analysis
OutlookPower: Running auto-respond rules when Outlook is closed
-- 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.
-- Advertisement --

Integrate your Notes Applications with Microsoft Office and Symphony
Integra for Notes Integrates Microsoft Office and/or IBM Lotus Symphony
Requires NO change to the design of the appliation or Installations of DLL's and EXE's
  • Integra is a ready to use solution, enhance static reports with Excel data analysis, pivot tables, macros
  • User friendly aproach, using a point and click access to features
  • Reports from any Lotus Notes databases
  • Runs reports through a Notes client, web browser and scheduled basis
  • Allows use of LotusScript for advanced data manipulation
  • Enables self service reporting capabilities to end-users


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