Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

export view to excel

Status
Not open for further replies.

vani1

Programmer
May 20, 2007
1
IN
How to export view to excel using agents
 
It might be easier to get the Notes odbc files from notes.net and them import views from excel instead of pushing them out from notes.
 
Actually I forgot, you can pretty easily export views into 1-2-3. from there you can convert them to excel. So you'd use @command([FileExport];filetype; filename)

filetype would be "lotus 1-2-3 worksheet".
filename has to include full path information

I use R4, so unless they've updated this functionality in R5 (if you are using R5) to include excel, I'd still go with the pull to excel vs. push from notes. Since any of your three filetypes allowed for views would require additional manual input.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top