Our dev team is wanting to create a scheduled agent that will run on our Domino server and create an excel object out on an external file share. Will the server have to have Excel installed or are their dll sets or api sets that I can install instead? Thanks.
Subject: Export from Notes to Excel
Kevin,
No, you won’t need to load Excel on the server. Create a sample of your Excel file and then save it as a WebPage. View the source, and then use this same format in Lotusscript ‘print’ statements. This will allow the file to be generated and then viewed on a machine with Excel loaded. You can have the script email the file, etc.
’ Write Excel Header.
Print #fileNum%, | <html xmlns:o=“urn:schemas-microsoft-com:office:office” |
Print #fileNum%, | xmlns:x=“urn:schemas-microsoft-com:office:excel” |
Print #fileNum%, | xmlns=“HTML 4.01 Specification”> |
Print #fileNum%, | |
Print #fileNum%, | |
Print #fileNum%, | |
Print #fileNum%, | |
Print #fileNum%, | <!–[if gte mso 9]> |
Subject: RE: Export from Notes to Excel
John,Any chance that you could post a sample of the rest of the XML that you so graciously provided for the Header. A simple “Hello World” to Excel would do.
Regards
Rolf Pfotenhauer
Subject: RE: Export from Notes to Excel
Rolf - Is this what you’d like to see? Basically, all I did was type ‘Hello World’ in Excel cell ‘A1’ and then saved the spreadsheet as a WebPage. Open the newly created webpage and view the source. Then all you need to do is write the source-code to a file using ‘Print’ statements. You can change the background colors, fonts, etc. and then view the source to assist in your programming of the spreadsheet. The nice thing about this is that you don’t need Excel loaded on the server to create the file. Please let me know if you have any questions.
John
+++++++++++++++++++++++++++++++++++++++++++++++
<html xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:x=“urn:schemas-microsoft-com:office:excel”
xmlns=“HTML 4.01 Specification”>
<![if supportMisalignedColumns]>
<![endif]>
| Hello
World |
Subject: RE: Export from Notes to Excel
Yeh, thanks John.
I tried what you said, it works all right but you have somethings missing.
The first few lines of my code looks like this—>
<?xml version="1.0"?><Workbook xmlns=“urn:schemas-microsoft-com:office:spreadsheet”
xmlns:o=“urn:schemas-microsoft-com:office:office”
xmlns:x=“urn:schemas-microsoft-com:office:excel”
xmlns:ss=“urn:schemas-microsoft-com:office:spreadsheet”
xmlns:html=“HTML 4.01 Specification”>
RPfotenhauer
RPfotenhauer
2004-08-11T05:24:48Z
Any reason for the difference?
Regards
Rolf Pfotenhauer
Subject: RE: Export from Notes to Excel
Rolf,
It really doesn’t matter if you have a few more 'tag’s than I do. I’m using Office 2003 and when I saved the webpage, I saved only the worksheet and not the workbook, since I was only using one worksheet of the workbook (maybe that could be the problem). As long as it displays on the screen as you’d like, I’d go ahead and use the code that is generated for you.
Please let me know if you have any other questions/problems.
John
Subject: RE: Export from Notes to Excel
Hi all,
I’m using this method to generate excel report and it works great.
Problem I’m facing is when I first time click on the button to generate report (in Excel), it works fine, but when I click second time it does not open it in new window, it tries to open it in same window.
How can I control this method to open new Excel every time the agent is executed.
Please help.
Regards,
Sid