Import lotus notes view data from Excel
I need to import frequently data from some Lotus notes views into my Excel Sheets, I want to know if they are a macro or a vb script which could do that.
Software/Hardware used:
Software/Hardware used:
ASKED:
October 29, 2008 3:18 PM
UPDATED:
November 6, 2008 1:50 PM
Answer Wiki:
Not sure if this helps. It would run from Notes, rather than in Excel.
<a href="http://www.bluestream.org/Domino/ExportToExcelViaNotes.htm">http://www.bluestream.org/Domino/ExportToExcelViaNotes.htm</a>
Otherwise, this is a non-script solution available on Domino Power.
<a href="http://www.dominopower.com/issues/issue199810/excel001.html">http://www.dominopower.com/issues/issue199810/excel001.html</a> - 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.
Search openntf.org for code that will do that.
The other choice is to select the docs in the view and copy as a table (r7 & up). You can then paste it into excel.
If this is to be done all the time then you can use NotesODBC and have excel pull the data as ODBC, this lets you just do it in excel and not have to export or use com to write directly to excel
To see all answers submitted to the Answer Wiki: View Answer History.
Thank you! It is not exactly what I’m looking for but it is very interesting, I will try the Lotus Notes view into an XML.
I may have some code that could be used, only it will require Win32 clients only. Most of it is done via COM. Another option, if you are familiar with SQL is to use the NotesSQL driver and connect to your DB via SQL within Excel. I believe here though, you work with the form or the view as a table.
Thanks for all yours tips, I’m not familiar with ODBC or SQL or COM but I think that my solution is there Actually I need to select docs in view and copy as table and then paste it into excel, but I have 4 table to update like that each time, so I need something to be more efficient. Which of your suggestion is easiest to apply for my case?