SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

This is a shot in the dark but have you checked that excel services have been setup properly?

http://technet.microsoft.com/en-us/library/ee424405.aspx

a simple guide

http://blah.winsmarts.com/2007-3-sharepoint_2007__excel_services_-_a_quick_introduction.aspx

hope it point you into the right direction

share|improve this answer

In this case the cause of the problem is in path parameter. The path is a path to a SharePoint document library, not a file ("Remarks" section in article https://msdn.microsoft.com/en-us/library/microsoft.office.excel.server.webservices.excelservice.newworkbook(v=office.14).aspx)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.