Update Xcel Spreadsheet from Lotus Notes

HCL Domino Domino Forum
1

I need a script that updates an xcel Spreadsheet from selected notes documents values in a view. The script must update the Xcel file in the background once it get the match key e.g ID number form the selected doc in a notes view.

I’ve searched…and all the scripts I’m getting are only fro exporting data to Excel and not updating existing data.

Plz help

2

Subject: Update Xcel Spreadsheet from Lotus Notes

Have a look at my post here:

http://www-10.lotus.com/ldd/nd6forum.nsf/DateAllThreadedweb/85d0bc6aadd8c5de8525743a003704f4?OpenDocument

But replace:

xlWorkSheet.Add

with

xlWorkSheet.Add(“\networkshare\sheet.xls”)

This will then open an existing sheet. Form there it’s up to you what you do with it