R – What event is triggered when a document is saved in a Document Library in SharePoint

excelsharepoint

We have a document list that contains Excel sheets, the documents that are in the list have to be processed. The processing code is triggered by the EventReceiver.

Until know we used the ItemCheckedIn event, but this isn't triggered when the user just saves a document from within Excel. I have tried to use the ItemUpdated event, but that doesn't seem to work either.

So I'm wondering whether there is an event that is triggered when a user saves the document from within Excel.

Best Answer

There are Before and After events when updating/adding list items. Here is a comprehensive list of all of those events:

Before Events

ItemAdding
ItemUpdating
ItemDeleting

After Events

ItemAdded
ItemUpdated
ItemDeleted
ItemAttachmentAdded
ItemAttachmentDeleted
ItemCheckedIn
ItemCheckedOut
ItemFileConverted
ItemFileMoved
ItemUncheckedOut

Related Solutions

Excel – Is it possible to force Excel recognize UTF-8 CSV files automatically

Alex is correct, but as you have to export to csv, you can give the users this advice when opening the csv files:

Save the exported file as a csv
Open Excel
Import the data using Data-->Import External Data --> Import Data
Select the file type of "csv" and browse to your file
In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier)
Change the Delimiter to comma
Select where to import to and Finish

This way the special characters should show correctly.

Python – Pandas: Looking up the list of sheets in an excel file

You can still use the ExcelFile class (and the sheet_names attribute):

xl = pd.ExcelFile('foo.xls')

xl.sheet_names  # see all sheet names

xl.parse(sheet_name)  # read a specific sheet to DataFrame

see docs for parse for more options...

Best Answer

Related Solutions

Excel – Is it possible to force Excel recognize UTF-8 CSV files automatically

Python – Pandas: Looking up the list of sheets in an excel file

Related Topic