Create new Worbook with Excel Services

Question

I want to generate an Excel File with SharePoint. I can make a refernce to ExcelServices an want to use the funtion NewWorkbook. But i get the error : Soap Exception: You do not have appropriate permissions to create a new workbook in the specified location

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.

Answer 1

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