Click here to Skip to main content
14,241,216 members

SharePoint

 
QuestionSharePoint Online Pin
Member 1198207313-Sep-15 22:44
memberMember 1198207313-Sep-15 22:44 
AnswerMessage Closed Pin
28-Oct-15 0:08
memberMember 1209387328-Oct-15 0:08 
AnswerMessage Closed Pin
28-Oct-15 0:17
memberMember 1209387328-Oct-15 0:17 
AnswerRe: SharePoint Online Pin
SAM_India23-Nov-15 15:39
memberSAM_India23-Nov-15 15:39 
QuestionCan anyone help me create a pleading in Infopath for Sharepoint? Pin
Member 1197803713-Sep-15 4:55
memberMember 1197803713-Sep-15 4:55 
AnswerMessage Closed Pin
28-Oct-15 0:21
memberMember 1209387328-Oct-15 0:21 
QuestionSharepoint 2010 and 2013 validating excel document before uploading into document librarry Pin
Afelete12312-Aug-15 2:46
memberAfelete12312-Aug-15 2:46 
AnswerRe: Sharepoint 2010 and 2013 validating excel document before uploading into document librarry Pin
DanielBrownAU13-Sep-15 14:24
professionalDanielBrownAU13-Sep-15 14:24 
Event Handler Checking data within Excel file

This is quite a complex task and will require some time and effort to create.

You would need a way for the event handler to read and inspect the excel file on the server, this would require excel to be installed on the server where your custom event handler and open the file, navigate it and do whatever checking you want on the data. However, as I said, this can be complex.

Once the excel file has been validated or rejected, you could then cancel the document upload, via the ItemAdding event /Staus property (https://msdn.microsoft.com/EN-US/library/microsoft.sharepoint.speventpropertiesbase.status.aspx[^]).

Some sites to get you started:
* Faster MS Excel Reading using Office Interop Assemblies[^]
* https://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel(v=office.15).aspx[^]

NOTES:
* The Office Interop can often be a trap for memory leaks
* Follow the 'double .' rule, If its more than 1 dot, it belongs in its over variable and its own disposing!

i.e
var wb = Excel.WorkSheet.Workbook;

should be:

var WorkSheet = ExcelObj.WorkSheet;
var workbook = WorkShee.WorkBook;



This allows for such things as:

workbook.Close();
workbook.Dipose();
WorkSheet.Close();
WorkSheet.Dipose();


Which will prevent a bunch of memory leaks and ensure there are not excel.exe's hanging around after your process has finsihed. Memory clean up is important when working with the office interop!

NOTE: Code samples as just that, samples and are not expected to work.

2. Instant Messaging
This is possible depending on what instant messaging system you use. In the past I have written such code for OCS, LCS and Lync.

In essence, you would have an event handler, which sends messages to a custom service, which is/acts as a Bot, which then sends an IM to the person you wish it to (this information would be sent from the event handler, to the custom service).

* https://msdn.microsoft.com/en-us/library/office/dn454839.aspx[^]
* https://code.msdn.microsoft.com/lync/[^]
* https://msdn.microsoft.com/en-us/library/office/dn454840.aspx[^]

Hope this helps!
Daniel Brown


modified 13-Sep-15 20:34pm.

QuestionGenerating site map in SharePoint Online Pin
Member 1189967610-Aug-15 11:39
memberMember 1189967610-Aug-15 11:39 
SuggestionRe: Generating site map in SharePoint Online Pin
Richard MacCutchan10-Aug-15 21:58
protectorRichard MacCutchan10-Aug-15 21:58 
AnswerMessage Closed Pin
28-Oct-15 0:22
memberMember 1209387328-Oct-15 0:22 
QuestionProgrammatically delete users from all site collections Pin
Member 308518516-Jul-15 3:52
memberMember 308518516-Jul-15 3:52 
AnswerRe: Programmatically delete users from all site collections Pin
Rsharepoint25-Nov-15 15:25
memberRsharepoint25-Nov-15 15:25 
QuestionHow to Apply Master page programmatically for a wiki page created programmatically Pin
Balajinarni14-Jun-15 20:00
memberBalajinarni14-Jun-15 20:00 
QuestionSearch is giving intermittent results in Sharepoint 2010 production environment. Pin
Member 1083323324-Apr-15 1:21
memberMember 1083323324-Apr-15 1:21 
AnswerMessage Closed Pin
28-Oct-15 0:24
memberMember 1209387328-Oct-15 0:24 
QuestionSharePoint 2013 Workflow Suspends Pin
Sakti Mohapatra23-Apr-15 2:15
memberSakti Mohapatra23-Apr-15 2:15 
Answer[REPOST] Pin
Sascha Lefèvre23-Apr-15 2:36
professionalSascha Lefèvre23-Apr-15 2:36 
QuestionError occurred in deployment step 'Activate Features': Pin
Mohd Tahir23-Apr-15 1:33
professionalMohd Tahir23-Apr-15 1:33 
AnswerRe: Error occurred in deployment step 'Activate Features': Pin
Sascha Lefèvre23-Apr-15 2:25
professionalSascha Lefèvre23-Apr-15 2:25 
AnswerRe: Error occurred in deployment step 'Activate Features': Pin
lakshmi prasad sirigiri6-Jul-15 19:54
memberlakshmi prasad sirigiri6-Jul-15 19:54 
AnswerRe: Error occurred in deployment step 'Activate Features': Pin
Member 1048483424-Aug-15 23:44
professionalMember 1048483424-Aug-15 23:44 
GeneralPeople picker not able to resolve users stored in sdf file on identity server Pin
Manish Chauhan6-Apr-15 23:58
memberManish Chauhan6-Apr-15 23:58 
QuestionIs it possible to have drill down in graphs and combinational graphs in Sharepoint 2013 using dashboard designer. Pin
Member 115864066-Apr-15 22:14
memberMember 115864066-Apr-15 22:14 
AnswerRe: Is it possible to have drill down in graphs and combinational graphs in Sharepoint 2013 using dashboard designer. Pin
nrramesh16-Apr-15 12:04
membernrramesh16-Apr-15 12:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.