Hello to all
Please can you assist me.
I would like to know if you need anything more in domino designer to code for creating microsoft Excel documents via exporting view from notes? Extra program or not.
Heinrich
Subject: Microsoft Excel and Notes
No extra program is required, except Excel of course. As long as Excel is installed, its COM classes will be there an you can use them to do the job.
Subject: Microsoft Excel and Notes
Hello Heinrich,
I am not sure this will help you, but we have 2 products called “SWING InOffice” & “SWING Integrator” that will allow you to transfer data from a Notes document to a Word/Excel document and convert to PDF (if required) all in one automatic process. The transfer from Notes to Word/Excel is done through templates and mapped fields.
Also our products can attach automatically any type of files.
InOffice & Integrator are the only tool for Lotus Notes that provides MS Office integration and PDF conversion in a single package, removing the need for an external PDF tool.
Take a look at: www.swingsoftware.com
A free 15 day trial is available.
Subject: RE: Microsoft Excel and Notes
Thanks. Just as a question, how wil I go about writing the code I can currently only program in formulas and not lotusscript
Subject: RE: Microsoft Excel and Notes
You will need to learn both LotusScript and enough Visual Basic for applications to understand how the Excel Object model works. No other way!
Subject: RE: Microsoft Excel and Notes
If you only need to export data and “exporting” it via Domino (rather than Notes) is an option: Embedd a view in a page (or a form to subselect) and change the content type to application/vnd.ms-excelWhen a user opens a link to the page/form the containing table (the view) will be loaded into Excel including HTML formatting. To exercise maximum control you might want to play with passthru html.
Hth
stw
Subject: RE: Microsoft Excel and Notes
After scouring the forums extensively for a solution to this very issue - how to get Excel on the web to do the same thing as Excel from the Notes Client using LotusScript - I found the best solution was to use JScript. Of course this only works for IE users, but if you’d like to see what I did and try to translate it to VB, I’ll be glad to share.
Subject: RE: Microsoft Excel and Notes
I embedded a view into a page. Created a link to open the page. I am prompted to open or save the excel file. I choose open and excel opens. Sheet is named with my page name. No data is loaded into excel.
Am I missing something.
Thanks.
Subject: RE: Microsoft Excel and Notes
Hello everyone,
For the past couple of weeks, I too am trying to display some Excel data on a webpage through LotusScript.
I tried OLE but it is not supported on the OS that we are using. So had to look for other options and decided to use jexcelApi.
When the agent (which is being invoked through the WebQueryOpen event of a form) is executed through IE, I get the error message “No such path or directory.” for the excel file that i have mentioned in the agent.
But when I “Run” the agent through the “Agent” menu, it correctly prints the cell value in the Java Debug Console.
There is no problem with the compilation of the program.
Has it got something to do with the absolute path of the file I am using. Or could it be some firewall which is blocking the access to the local C Drive?
Please help me with this,
Thanks in advance,
Visha
Subject: RE: Microsoft Excel and Notes
TLCC offers several free on-line courses, including Beginning LotusScript for Notes Domino 6. (And even though it’s for release 6, I’m sure at least 90% of the content will be applicable to any release.) You can find more info here:
Subject: Microsoft Excel and Notes
Hi everyone,
If you intend to run your code from the Notes Client (as Agent or Action Button) you can use LotusScript.
I suggest you to search on this forum for Import/Export from/in MS Excel to make an idea. Then, you can check:
for more information about the Excel objects.
If you like to use your code as an Agent that is running on server (or for Web apps) you can consider to use a Java third party library that allows you to obtain an Excel file without running MS Excel on the server.
Here is one “open source” library:
http://www.andykhan.com/jexcelapi/index.html
The only thing that you have to do in order to use the Excel API is to import the jar file in your agent.
Have fun!
Subject: RE: Microsoft Excel and Notes
For Excel output on the web, you don’t need any third-party tools. You can do it straight from a Notes view/viewtemplate or use a LotusScript or Java agent’s output directly, using the correct content-type (“application/vnd.excel”) and the alternate HTML-like table syntax. See this article over at Jake Howlett’s Codestore.net:
http://codestore.net/store.nsf/area/896DC837C32DEEFE80256B1D006C128E?OpenDocument