OpenNTF.org - Create and show an MS Excel Gr

OpenNTF Code Bin

Edit Document Code By Date > Code Document

About This Code

Brief Description:

Create and show an MS Excel Graph in a Lotus Notes Dialog

Rating:

Not Rated Yet

Contributor:

Thomas Adrian

Category:

Application

Type:

Example Code

Document Release:

Notes Version:

R7.x

Last Modified:

10 May 2007

OpenNTF Disclaimer

All of the program code and information presented in the OpenNTF.org Code Bin are provided "as-is", and should be used at your own risk. OpenNTF.org make no express or implied warranty about anything in the Code Bin, and OpenNTF.org will not be responsible or liable for any damage caused by the use or misuse of anything from this site. OpenNTF.org makes no guarantees about anything. Please thoroughly test all of the knowledge and code you find here before you attempt to use them in your production environment.

Code / Description

This animation show what you can expect when you download the database

Thomas
http://www.notessidan.se

Usage / Example

Code Attachments

exgraph.nsf (512 Kbytes)

Comments

Posted by Patrick Kwintensson on 05/11/2007 08:25:22 AMNo RESUME - error

above message I get...

Posted by Thomas Adrian on 05/13/2007 06:52:11 AMError

Ok, I am a programmer , but I cannot help you if you only provide a general LS error. No resume doesn't tell me anything about what's gone wrong.
- What version of Notes are you running
- What version of Windows are you running
- What version of Excel are you running
- Try to figure out by adding errorhandling what row in the script that causes the error.
- Any other infornation that could be relevant
The more information you give me, the higher chance it is to solve it
Please note: The code given is for developers, If you are not a developer you will have very little use of this application.
- Thomas

Posted by Patrick Kwintensson on 05/14/2007 02:55:07 AMdon't shoot the piano-player

Hej I am just posting that I get a message when I run the application. Since I do not have such an exotic configuration I believe it might also occur at others:
Excel 2003 SP2
Domino 7.01
Windows XP Professional
The database is in my data directory.
I believe the error must be somewhere with the connection to Excel.

Posted by Kaushal J Naik on 05/16/2007 12:05:18 AMNO RESUME

On running the code, I am getting the message box displaying "NO RESUME" message. This is due to the error handling that has been done in the code.
On checking the error, it says "DXL importer operation failed 23".
The error is in the CreateDocument function. The error gets generated while executing the "Call importer.procss" line.
Request you to help me in resolving the error.
Thanks a lot in advance.
Kaushal.

Posted by Ken Hawkins on 09/18/2007 11:46:03 AMNo Resume . . .

I accidentally re-created the error message previously posted. It occurred when I elected to not "Start trusting the signer . . . " as the ECL alerts popped the first time I clicked the action button.
I decided to stop and sign the database with my ID. After that the graph opened without error.
Hope this helps,
Ken