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.
ADVANCED WEB DESIGN COURSE
Linking Domino to Excel via XML
By Jeffrey R. Burrows

Doubtless, you've heard the hype from Microsoft. Excel 2000 [we've also heard it called Excel '99] will be able to save and load worksheets from the Web, with no loss of function or format, thanks partly to a technology called XML (eXtensible Markup Language).

What you may not have heard is that some XML functionality is available right now with Excel 97. This functionality can easily be exploited by Domino developers, opening up a whole new avenue for Notes information distribution.

This article will show you a -- in few simple steps -- how to turn a Lotus Notes view into an XML-equipped Web page. This new page can not only be viewed by a Web browser, but opened by Excel 97 -- complete with formulas and summed columns. Further, you'll see how to take one small XML step to condense large amounts of information into flexible Excel pivot tables, and how to use Web agents to work around limitations of Notes views.

The basics
When a standard Notes view is presented to a Web browser by the Domino server, it has been converted on the fly into an HTML table. The key here is to take direct control over that conversion procedure, creating the HTML directly in the view, rather than dynamically by the Domino task.

Views have one major limitation in the current Domino server -- they are automatically broken down into individual Web pages. The number of lines in each snapshot can be set only once for every database on the server. These snapshots have two consequences -- only small spreadsheets can be delivered as Web pages using views (up to the default lines-per-view setting in the HTTP section of the Name and Address Book Server document) and you must supply your own navigation icons in custom views to move back and forward between pages

The view method will be used here to demonstrate the principles of HTML (and XML) customization. For spreadsheets beyond the size of a snapshot, an alternative method, using agents, will be used, building on these basic principles.

Web tables
Tables in HTML have a simple structure, composed mostly of table (<TABLE>), row (<TR>), header (<TH>) and data (<TD>) tags, as in this example:-

<TABLE>
<TR><TH>Quarter<TH>Earnings<TH>Profit
<TR><TD>Q198<TD>30000<TD>5000
<TR><TD>Q298<TD>42000<TD>8000
</TABLE>


1  ·  2  ·  3  ·  4  ·  5  ·  Next »
Other articles you might like
Home > Strategies > Interoperability (15 articles)
   A Sametime plugin for Trillian
   Integrating Twitter with an IBM internal social network
   Fun with Sametime and Skype
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
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