Tip

Display Live Web-Enabled Domino Data in your Excel Spreadsheet

How to always display live Web-enabled Domino data in your Excel spreadsheet. No Script is required although it is implied in Example 1) below to demonstrate this tip.

This is ideal for setting up charts and graphs, that will pick up live data from your secure Web-enabled Domino database.


1) Create a form/view that displays the data you need in a table.
Note: Must be in a table, this is how Excel recognizes the data.

Example 1:
Create a form that is populated by WebQueryOpen, calculating figures from other data in the database and displying it in a table.

Example 2:
Create a view that displays all the data you wish to export. Set it to display as HTML.

2) Open Excel

3) Use Menu Options, DATA -> Get External Data -> New Web Query

4) Fill in the URL of the data you want to export (Note: if you browse to the page, it will automatically pull in the URL for you)

5) Click OK.

This will now import your data, and from here, graphs, charts, etc. can be created.

6) Right click on the data once it has been imported.

7) Select Data Range properties. In here you can select to re-import this data every time the file is opened. I was prompted to logon each time the Excel file tried to open a secure page, but I make no personal guarantees for this.

8) Save all the reports, charts, graphs and formatting you require, because the next time you open that file, the live data will be imported, after suitable connection and security delays. The WebQueryOpen runs every time you access that form.

Voila, Live Excel Import from Secure Domino database.

This was first published in March 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.