I want to generate an Excel File using SharePoint. I can make a reference to ExcelServices and want to use the function NewWorkbook.
But I am getting the error which say
Soap Exception: You do not have appropriate permissions to create a new workbook in the specified location
The following is the code :
ExcelService es = new ExcelService(); Status outStatus; es.Credentials = System.Net.CredentialCache.DefaultCredentials; string sessionId = es.NewWorkbook(@"http://Site/Libary/test.test", null, null, out outStatus);
The libary: http:/Site/Libary is an trusted file location.