i have a view in which i want to update one field value in veery documentin which that field contains different values for every document
those values are in excel sheet
can any help for coding…
Subject: how to update values in view with values from excel sheet
You will have to provide more info
What is the key on the document and the excel sheet/table/data range?
Very vaguely…you will need to write and agent to loop through the rows in Excel, then find the corresponding document in the Notes view using GetDocumentByKey and then update/save the NotesDocument
Subject: RE: how to update values in view with values from excel sheet
i have 500 documents in aview
key is employee name (ename) that is in first column in view
so based on this key iwant to update every employee casual leaves that is retrived from excel sheet
in excel sheet first row is employee name third row is casual leaves values