First "Hello World" code sample with the Excel Services APIs!

Excel Services coding example

Microsoft Excel 2007 (nee Excel 12) — Tue, 28 Mar 2006 09:44:25 GMT

For those of you interested in programming Excel Services, check out this blog.
One of the developers...

re: First "Hello World" code sample with the Excel Services APIs!

Paolo — Thu, 30 Mar 2006 02:10:32 GMT

Thank you for this nice code preview.
(Just a linguistic note: the plural of Latin word "status" is "status" (4th declension, not 2nd declension) ;-).

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Fri, 31 Mar 2006 03:08:33 GMT

But it's not as funny. :)

How to add support for External Workbook References to Excel Services

Cum Grano Salis — Tue, 02 May 2006 21:18:40 GMT

Excel Services does not support External Workbook References. I show how you can use a UDF to get similar functionality.

SPS 2007 y Excel Services - DevDays Andino 2006

Blog de P@blo - [MVP - Windows Server Customer Experience] — Tue, 30 May 2006 23:19:04 GMT

Durante la preparación de las sesiones para el evento DevDays Andino 2006, cuyos temas principales fueron...

re: First "Hello World" code sample with the Excel Services APIs!

Prasad — Wed, 07 Jun 2006 07:00:24 GMT

I copied the assemblies Microsoft.Office.Excel.Server.WebServices and Microsoft.SharePoint to my pc from the maching where Office Server is installed.I added the references to these in my console application.But at runtime it throws an error at the line where i am instantiating the ExcelService class saying that it could not load the assembly Microsoft.Office.Excel.Server.Is there any assembly by this name?

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Wed, 07 Jun 2006 09:46:11 GMT

Prasad:

Read the part in the article about "Creating the form and importing Excel Services API". You dont need to copy these assemblies - just use VS to create a proxy to the web-services.

re: First "Hello World" code sample with the Excel Services APIs!

Prasad — Wed, 07 Jun 2006 11:38:12 GMT

Hi Shahar

I have added the Web Refernece of the ExcelService web service in my console application.However I dont find any class by the name ExcelService in the instantiated proxy class.Instead I find the class ExcelServiceSoap.Although this contains a method called OpenWorkBook,the signature of the method is entirely different from what is given above eg and also in the msdn example which corresponds to the ExcelService class in the assembly Microsoft.Office.Excel.Server.WebServices.

re: First "Hello World" code sample with the Excel Services APIs!

Prasad — Wed, 07 Jun 2006 11:38:59 GMT

Moreover I am using Office Server 2007 Beta 2.

re: First "Hello World" code sample with the Excel Services APIs!

Prasad — Wed, 07 Jun 2006 11:46:35 GMT

Thanks!
I realized my mistake.I had put the reference of the ExcelCalculation Server/ExcelService.asmx in my console application.

Server-side Excel: changing the face of financial apps?

benjaminm's blog — Mon, 12 Jun 2006 19:47:25 GMT

re: First "Hello World" code sample with the Excel Services APIs!

KieuAnh — Mon, 21 Aug 2006 07:07:06 GMT

I need comment code

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Tue, 22 Aug 2006 01:28:54 GMT

KieuAnh:

Not sure what it is you want. Can you elaborate?

re: First "Hello World" code sample with the Excel Services APIs!

DotNetInterop — Thu, 07 Sep 2006 19:38:52 GMT

A related post - this one shows a Java application connecting with Excel Services via the web service interface. -Dino

Office 2007 Developer Resources

Martin Parry — Wed, 13 Sep 2006 16:11:05 GMT

This post is a list of useful resources for developers working with the 2007 Microsoft Office&nbsp;System...

re: First "Hello World" code sample with the Excel Services APIs!

Tyler — Sat, 16 Sep 2006 03:17:49 GMT

Shahar,

Can you comment if the CalculateA1 function is working. I have a namedrange cell with a Rand() function in it. When I open the workbook and try to CalculateA1 the cell with the rand() function it doesnt seem to update. Any ideas? I am not running the tech refresh.

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Sat, 16 Sep 2006 11:34:43 GMT

Tyler,

The reason you are not seeing anything change is that Excel Services optimizes the recalculation - it will not let a user recalc more than once per 5 minutes. This is configurable inside the Trusted Location - there's a setting called "Volatile function lifetime" or something similar that you can use to adjust the 5min. Setting it to zero will make it so that every recalc will realy recalc. Note that reducing this setting will impact performance as it will require Excel Services to recalculate more often.

In B2TR, there's a slight change (as far as I remember) - a manual recalc will ignore the volatile cache time and actually do a recalc.

Pre-requisites

LuisBE on Services — Fri, 29 Sep 2006 08:45:31 GMT

Instead of re-hashing information I've found elsewhere I figured a pre-reqs post would be good.
One...

Pre-requisites

LuisBE on Services — Tue, 31 Oct 2006 03:50:22 GMT

Instead of re-hashing information I've found elsewhere I figured a pre-reqs post would be good. One of

re: First "Hello World" code sample with the Excel Services APIs!

Rohit — Wed, 15 Nov 2006 13:45:35 GMT

A very neatly explained example.

Great work!!!

re: First "Hello World" code sample with the Excel Services APIs!

Amarnath reddy — Thu, 16 Nov 2006 11:16:28 GMT

Hi,

I have tryied this example.Iam able to gat the data from the excel but unable to write the data into the excel by using "SetCellA1" property.

anyone can help on this.

Thanks&Regards,

Amar...

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Thu, 16 Nov 2006 11:22:27 GMT

What error are you getting? Can you share the code you are running?

re: First "Hello World" code sample with the Excel Services APIs!

Amarnath reddy — Thu, 16 Nov 2006 11:41:43 GMT

Hi Shahar,

Iam not getting any error.i folowed the same steps which u have given.

this is the code which iam writing data into the excel which is in Sharepoint server 2007 using excel webservices.

Code:

---------

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Try

Dim mystat() As MyExcelWebReference.Status

Dim targetpath As String

Using es As New MyExcelWebReference.ExcelService()

targetpath = "http://SharepointServer/ExcelServices/Amar/Shared%20Documents/Amar.xlsx"

es.PreAuthenticate = True

es.Credentials = System.Net.CredentialCache.DefaultCredentials

sessionid = es.OpenWorkbook(targetpath, String.Empty, String.Empty, status)

If (sessionid = "") Then

MsgBox("Error in Opening Workbook")

Else

es.SetCellA1(sessionid, "Sheet1", "A1", "Amar")

End If

es.CloseWorkbook(sessionid)

End Using

Catch ex As Exception

MsgBox(ex.Message)

End Try

End Sub

---------

End Code

Please look into this and give me the code sample.

Thanks&Regards,

Amar...

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Thu, 16 Nov 2006 12:01:56 GMT

Oh.

Are you expecting to see the value change inside the Excel workbook inside sharepoint?

re: First "Hello World" code sample with the Excel Services APIs!

Amarnath Reddy — Thu, 16 Nov 2006 12:39:21 GMT

Hi Shahar,

Thanks for the fast response...

yes i want to write some data into the excel located in the share point server 2007.

can you give me the points.

Thanks&Regards,

Amar....

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Thu, 16 Nov 2006 12:56:04 GMT

Ezcel Services is not an authoring environment. It was not meant in this version to "Save Back" to the SP server.

It's still possible, but requires a few more steps.

1. Call the GetWorkbook() method on the proxy to get back a byte array represnting your workbook.

2. Use the SharePoint OM to save that byte array back to the server.

re: First "Hello World" code sample with the Excel Services APIs!

Amarnath reddy — Thu, 16 Nov 2006 13:06:30 GMT

Thanks Shahar,

please can you give me the sample code steps for this.

once again thanks for the response.

Regards,

Amar...

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Thu, 16 Nov 2006 13:26:47 GMT

I can, but it may actually take me a little while to do this. Don't have time for posting articles right now and while it's not complex, it's a fair amount of code.

Until I get to do it, I suggest you search for information on how to use the SPFile.SaveBinary() method and take a look at the GetWorkbook() method of Excel Services.

re: First "Hello World" code sample with the Excel Services APIs!

AmarnathReddy — Thu, 16 Nov 2006 13:34:43 GMT

Thanks for the info..

I will check the details...

Regards,

Amar...

re: First "Hello World" code sample with the Excel Services APIs!

Amarnath Reddy — Fri, 17 Nov 2006 09:21:20 GMT

Hi All,

I need some syntax to know the Active excelsheet name which i have opened using excel webservices.

please give me the code samples for that.

i want to see the active sheet neme when i open the excel in "view in browser" option in sharepoint server.

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Fri, 17 Nov 2006 09:29:23 GMT

Can you elaborate on "i want to see the active sheet neme when i open the excel in "view in browser" option in sharepoint server"?

Not sure I undestand what you mean.

re: First "Hello World" code sample with the Excel Services APIs!

Amarnath Reddy — Fri, 17 Nov 2006 09:42:42 GMT

Hi Shahar,

I have published my excel sheet into the sharepoint server 2007.

in that sheet in one cell i have placed one formula(i.e udf function) to get the activesheet name.

now when i want to go and see the excel in "view in browser" option in Sharepoint server 2007t then i want to get the active sheet name in the given cell whare i have given the formaula.

please help me out on this.

Regards,

Amar...

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Fri, 17 Nov 2006 10:01:57 GMT

What is the UDF that returns the ActiveSheet name exactly? I wasn't aware that we supported something like that.

(Which, of course, does not mean much, since there are many Excel functions I am not aware of. :))

re: First "Hello World" code sample with the Excel Services APIs!

Amarnath Reddy — Fri, 17 Nov 2006 10:05:58 GMT

Hi Shahar,

I need one excel inbuilt funtion to get the Activesheet name.

that only i want to write in the UDF to get the Active sheet name.

Regards,

Amar..

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Fri, 17 Nov 2006 10:29:58 GMT

There is no such feature.

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Fri, 17 Nov 2006 10:33:20 GMT

Can you explain what you need it for? It may help us in a future release.

re: First "Hello World" code sample with the Excel Services APIs!

Amarnath Reddy — Fri, 17 Nov 2006 10:34:08 GMT

Hi Shahar,

Thanks...

Regards,

Amar...

re: First "Hello World" code sample with the Excel Services APIs!

Anirudh — Mon, 29 Jan 2007 12:45:50 GMT

Hi,

I used the information in this blog to work with the excel services API within MOSS 2007 and was able to do a variety of activities with the exposed web service.

I am trying to access the same web service from a RTM Project Server website. The website exposes the particular webservice but I cannot add the reference itself. The Add Reference button is disabled and I get the following error messages:

The document at the url http://litware:104/_vti_bin/ExcelService.asmx?wsdl was not recognized as a known document type.

The error message from each known type may help you fix the problem:

- Report from 'DISCO Document' is 'Root element is missing.'.

- Report from 'WSDL Document' is 'There is an error in XML document (0, 0).'.

- Root element is missing.

- Report from 'XML Schema' is 'Root element is missing.'.

Is this an issue specific to Project Server RTM?

I then tried to access the excelservice webservice(the wsdl) of a RTM MOSS 2007 website and got the following error:

Unable to cast COM object of type 'System.__ComObject' to interface type 'EnvDTE.IVsExtensibility'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{3C536122-57B1-46DE-AB34-ACC524140093}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

When I tried to add this webservice it allowed me but w/o the wsdl document.

I've never faced such problems with the Beta2 versions of MOSS.

I haven't found any info on these issues elsewhere and so any help would be appreciated.

re: First "Hello World" code sample with the Excel Services APIs!

Vandana — Mon, 29 Jan 2007 15:41:02 GMT

How does a workflow work in Excel services?Basically i would like to know how the excel workbooks published on to the server behave when a workflow is started.Will the documents be visible to particular user only after it is approved by the initiatir or some other approver?

Thanks,

Vandana

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Mon, 29 Jan 2007 19:26:34 GMT

Anirudh:

As for the first question: Excel Services is only enabled on the Enterprise version of MOSS. As far as I know, Project server is a different SKU that does not support it.

For more help on that, you can try accessing the forums: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1208&SiteID=1

As for the second question: What is it that you are doing exactly when you say "I then tried to access the excelservice webservice of a RTM MOSS 2007 website"? Where do you get that COM error you describe?

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Mon, 29 Jan 2007 19:28:11 GMT

Vandana:

It all depends on what workflow you apply to the document library in question. There is no inherent process that happens for Workbooks on the server.

re: First "Hello World" code sample with the Excel Services APIs!

Vandana — Tue, 30 Jan 2007 09:12:58 GMT

Hi,

Thanks for the reply.I need bit more clarification on workflows.

I have used approval workflow which routes the documenst thru all the workflow participants.

whai i feel is once a document is approved then only it should go to next level for further processing.

but i find no such restriction in excel services.Is there any locking mechanism either thru custom workfkows or with predefined workflows wherein a workbook is viewed only if it approved by a particular user?

Thanks,

Vandana

re: First "Hello World" code sample with the Excel Services APIs!

Anirudh — Tue, 30 Jan 2007 10:31:28 GMT

Hi Shahar,

First off thanks for the prompt reply!

Well its a disappointment if exceservices is not supported for project server, because even the project web access websites created under Project Server offer that excelservice webservice,i.e. you can see it when you try to add the web reference.

However it doesn't let you add this reference(button disabled) and the errors are printed in the web service despcrription txtbox.

The document at the url http://litware:104/_vti_bin/ExcelService.asmx?wsdl was not recognized as a known document type.

The error message from each known type may help you fix the problem:

- Report from 'DISCO Document' is 'Root element is missing.'.

- Report from 'WSDL Document' is 'There is an error in XML document (0, 0).'.

- Root element is missing.

- Report from 'XML Schema' is 'Root element is missing.'.

After that I tried to access a webservice of a MOSS RTM site (on the same machine) and got the COM error.I got a workaround for that(it was a site specific error)

That was not the main issue; I really needed the excelserviceAPI for Project server. Are you sure it is not supported?

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Tue, 30 Jan 2007 21:13:25 GMT

Anirudh,

I am double-checking. But I think Excel Services comes only as part of the enterprise version.

Vandana,

I sent an email in the internal alias to see if something comes up.

Both:

Consider using the Excel Services forums (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1208&SiteID=1) for questions such as this - you will get more eyes on them.

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Tue, 30 Jan 2007 21:23:45 GMT

Anirudh,

Excel Services only comes as part of the MOSS for Internet Sites or the Enterprise packages. For more info, please follow this link:

http://office.microsoft.com/en-us/help/HA101978031033.aspx

re: First "Hello World" code sample with the Excel Services APIs!

Amarnath Reddy — Thu, 01 Feb 2007 08:11:37 GMT

Hi All,

I have created a approval workflow and i have added approvers name as administrator,spuser1 and i have assighned the work flow to the test document.after that i have loged in to the sharepoint server as another user.when i want to open the test document without approving the document logedin user able to open and edit the document but it should display some type of message like "it is not yet approved by the administrator workflow is in process".

is there any locking is available for the document when workflow is processing.

please anybody can give the flow of the work flow and approval steps and workflow conifiguration.

regards,

Amar...

re: First "Hello World" code sample with the Excel Services APIs!

Amarnath Reddy — Wed, 21 Mar 2007 08:50:44 GMT

Hi All,

I want to know how to auto schdule my excel files in sharepoint server 2007.is there any provision given by sharepoint server 2007 to schdule the files and also programatically how can set the schduler.In sharepoint there is one dll i.e Microsoft.SharePoint.SPSchedule

how can we work on this iam not clear.can anybody can send sample code and help on this.

Thanks&Regards,

Amar..

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Wed, 21 Mar 2007 14:02:24 GMT

Can you explain what "Auto Scheduling" means? What's the expected behavior? What do you want them to auto schecule to?

re: First "Hello World" code sample with the Excel Services APIs!

Sasya — Fri, 11 May 2007 08:15:58 GMT

Hi Sahar,

While opening the workbook I am getting "The file that you selected could not be found. Check the spelling of the file name and verify that the location is correct" error, but the path of the excel that I am giving is correct. How can I resolve this.

Can we refresh the document that is stored in Sharepoint under Excel trusted Location by calling Refresh method that is available with Excel services workbook? Is this possible?

re: First "Hello World" code sample with the Excel Services APIs!

Sasya — Fri, 11 May 2007 18:19:46 GMT

I am getting the Error while opening the workbook, error is "You do not have permissions to open this file on Excel Services." The excel file that I am opening is in trusted location in sharepoint. Do we need to give any permissions to that document in sharepoint document library.

How do I can resolve this?

Here is the full code

ExcelService currentService = new ExcelService();

string targetPath = "http://localhost/Documents/TestDoc.xlsx";

Status[] outStatus;

currentService.Credentials = System.Net.CredentialCache.DefaultCredentials;

string sessionId = currentService.OpenWorkbook(targetPath, "en-US", "en-US", out outStatus);

Thanks in Advance,

Sasya

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Sun, 13 May 2007 17:53:29 GMT

Can you choose "View in WebBrowser" in the drop down on the file?

re: First "Hello World" code sample with the Excel Services APIs!

Sasya — Mon, 14 May 2007 06:52:36 GMT

View in WebBrowser" in the drop down on the file is working from Sharepoint document library.

But I am getting the error while accessing using Excel web services.

How do I resolve this error?

Thanks,

Sasya

re: First "Hello World" code sample with the Excel Services APIs!

Sasya — Mon, 14 May 2007 07:31:26 GMT

The excel sheet that I am trying to access from Excel Service also has Data Connections, which are used to pull data from database(SQL server).

Thanks

Sasya

re: First "Hello World" code sample with the Excel Services APIs!

Sasya — Mon, 14 May 2007 10:12:45 GMT

Hi,

I am using Excel services for refreshing the excel sheet and then trying to save refreshed document to the Sharepoint library.Below is the thing that I am trying out:

1. Opening the workbook from Sharepoint trusted location.

2. Refreshing the excel report(Has Pivot Tables and Pivot Charts).

3. Writing refreshed data to an external file.

Here is the code:

ExcelService currentService = new ExcelService();

string targetPath = "http://localhost/Documents/EmpDept.xlsx";

Status[] outStatus;

currentService.Credentials = System.Net.CredentialCache.DefaultCredentials;

string sessionId = currentService.OpenWorkbook(targetPath, "en-US", "en-US", out outStatus);

currentService.Refresh(sessionId, "Employees");

byte[] contents = currentService.GetWorkbook(sessionId, WorkbookType.FullWorkbook, out outStatus);

using (BinaryWriter binWriter =

new BinaryWriter(File.Open(@"C:\Test.xlsx", FileMode.Create)))

{

binWriter.Write(contents);

}

currentService.CloseWorkbook(sessionId);

I have modified my data source by adding new records,

But even after the refresh also the excel report is not getting refreshed. When I check Text.xls it is as same as the Source excel and not updated with the latest data from data source.

When I refreh the Connection from Excel the sheet is getting refreshed with the latest data from my datasource.

Is there anything I am missing here?

Any help will be appreciated.

Regards,

Sasya

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Mon, 14 May 2007 10:39:34 GMT

Sasya:

RE: Failure of EWA

What's the error you are saying?

RE: Api question.

Hmm. That's very strange.

1. What does the connection shunt information to? (PivotTable?)

2. What happens if you call .RefreshAll() instead of .Refresh()?

re: First "Hello World" code sample with the Excel Services APIs!

Sasya — Mon, 14 May 2007 13:25:51 GMT

Thanks for the response,

ConnectionString Info:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=SolutionMetaData;Data Source=xxxx;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=Test;Use Encryption for Data=False;Tag with column collation when possible=False

CommandType:Table

CommandText:DataBase.TableName(Sample.Employees)

From C# Code for Excel Services:

If I call .Refresh by passing in second parameter as empty then it will refresh all the connections(Source:MSDN) I have tried the one below, but still it doesn't refresh.

currentService.Refresh(sessionId, "");

If I am refreshing the report from Excel client by using Refresh or RefreshAll from Connections Tab I am able to see the updated report in excel. But which is not happening from Excel web services.

Thanks,

Sasya

re: First "Hello World" code sample with the Excel Services APIs!

SL — Mon, 14 May 2007 16:59:10 GMT

I have a problem opening a workbook from a remote machine using Excel web services.

I am getting the following error:

URL authorization failed for the request

I am using the default credentials for Excel web services in code.

from X machine I am calling openworkbok for the url on machine MySite

URL passed in as parameter for OpenWorkBook is :http://MySite/Reports/Salaries.xlsx

Thanks in advance

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Mon, 14 May 2007 17:01:36 GMT

SL:

Can you navigate to http://MySite/_vti_bin/ExcelServices.asmx

re: First "Hello World" code sample with the Excel Services APIs!

SL — Mon, 14 May 2007 17:45:55 GMT

If I try to access the url http://MySite/_vti_bin/ExcelServices.asmx I am getting the error from machine x as well as machine Mysite, and Just it is displaying that an Error has occurred.

In eventViewer I didnt see any message related to that.

But on Mysite I can view http://MySite/Reports/Salaries.xlsx without any error in WebBrowser by clicking View in WebBrowser link in the dropdown in Document library.

But If I am accessing ExcelServices.asmx on MySite machine with http://localhost/_vti_bin/ExcelServices.asmx, I am able to access it without any error.

And in IIS for Office Server Web Services is configured with both Annonymous and Windows authentication.

MySite/_vti_bin/ExcelServices.asmx is also configured with both Annonymous and Windows authentication.

Thanks,

re: First "Hello World" code sample with the Excel Services APIs!

Sasya — Mon, 14 May 2007 18:16:19 GMT

Sahara,

I have strucked with the Data refresh problem using Excel services using C# code. It is not working as documented in MSDN if my document has data connections to external data sources.

Thanks in Advance,

Sasya

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Mon, 14 May 2007 18:22:15 GMT

Sasya,

If you choose the "Refresh All Connections" from the EWA toolbar does it work?

(So, load the file in EWA and select the "Refresh ALL" and see if you get the new information you expect).

re: First "Hello World" code sample with the Excel Services APIs!

Ira Levin — Mon, 14 May 2007 19:04:34 GMT

SL,

Excel Services API isn't accessible to anonymuos users, so you either must authenticate by supplying a network credentials (e.g. CredentialsCache.DefaultCredentials), or if you'd like you can modify the permissions of the anonymous user so that it has the "UseRemoteApi" permission. You can alter the permissions of the anonymous user from OM, or you can grant anonymous users full access to websites.

I hope this helps.

re: First "Hello World" code sample with the Excel Services APIs!

SL — Tue, 15 May 2007 07:05:35 GMT

Hi Levin,

Here is the code that I am using:

ExcelService currentService = new ExcelService();

string targetPath = "http://MySite/Reports/Salaries.xlsx";

Status[] outStatus;

currentService.Credentials = System.Net.CredentialCache.DefaultCredentials;

string sessionId = currentService.OpenWorkbook(targetPath, "en-US", "en-US", out outStatus);

currentService.Refresh(sessionId, "");

byte[] contents = currentService.GetWorkbook(sessionId, WorkbookType.FullWorkbook, out outStatus);

In my code I am using CredentialsCache.DefaultCredentials, but still OpenWorkBook is throwing out an error. And annonymous access in IIS is configured with Service account.

And I have tried running this code from the machine MySite, I am still getting the error.

Regards,

re: First "Hello World" code sample with the Excel Services APIs!

Majeti — Wed, 23 May 2007 17:56:46 GMT

Hi Anirudh,

if you have created a site collection then use the url reference as:

http://<server>/sites/<sitename>/_vti_bin/excelservice.asmx

Regards

Majeti

re: First "Hello World" code sample with the Excel Services APIs!

Sush — Fri, 06 Jul 2007 13:36:07 GMT

Hi All,

I have deployed a web application which uses excel web service on a sharepoint site. I have some named items on the excel sheet. How can i programatically get the list of all the named items/parameters defined in there.

Regards,

Sush

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Mon, 09 Jul 2007 20:09:42 GMT

You cannot. The only workarounds you have available (afaik) are:

1. Know the names before hand.

2. Place the names in a hidden sheet and have a well known range name for the range that contains all the named ranges. Then use that to get the names.

re: First "Hello World" code sample with the Excel Services APIs!

Frank van de Groep — Thu, 26 Jul 2007 15:03:01 GMT

Hi there,

My project/app is called Webexcel1. I added a webreference called ES. But it doesn't recognize the namespace ES.

I tried it with the first using and the second one.

...

//using Webexcel1.ES;

using System.Web.Services.Protocols;

using (ES.ExcelService excelService = new ES.ExcelService())

{

excelService.Credentials = System.Net.CredentialCache.DefaultCredentials;

}

...

Thanks!

Frank

re: First "Hello World" code sample with the Excel Services APIs!

frankjnf — Sat, 28 Jul 2007 14:19:43 GMT

Already solved my problem. It was due to a lack of knowledge in VS. I had the using declarations in the wrong spot of my project. Basics....

Works fine now.

Thanks and good luck.

re: First "Hello World" code sample with the Excel Services APIs!

Sachin Vyas — Thu, 27 Sep 2007 16:23:05 GMT

Thanks for nice article.

But i am getting an Soap Exception error "An error has occured" message. in foolowing line

string test = es.OpenWorkbook(targetWorkbookPath, "en-US", "en-US", out outStatus);

can anyone help me why i am getting this exception and how i can solved it.

Thanks in advance.

re: First "Hello World" code sample with the Excel Services APIs!

thana — Fri, 28 Sep 2007 09:08:12 GMT

hi!

my servlet return excel file i am getting excel file for java script request,but let me know how do open or display excel file through ajax responseText

regards

Thana

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Tue, 02 Oct 2007 01:45:56 GMT

That's not something you can do today.

The only thing you can do is use AJAX to get data from Excel Services.

re: First "Hello World" code sample with the Excel Services APIs!

VVS — Fri, 23 Nov 2007 11:13:46 GMT

is it necessary to install office 2007 and devloper's machine or they can access from share point server. if Office 2003 is present on the local system

what are the minimum requirements for developer machine

if share point server machine has share point 2007 and excel 2007

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Thu, 29 Nov 2007 02:37:10 GMT

You dont need anything installed on the Developer machine - just a connection to the Excel Services SharePoint.

re: First "Hello World" code sample with the Excel Services APIs!

Jason — Fri, 22 Feb 2008 22:04:57 GMT

I'm running into a soap exception error that a few of you mentioned previously. I get a "You do not have permissions to open this file on Excel Servcies" error when on the line of code where the ExcelService.OpenWorkbook function is called. I'm passing into the function the default credentials and a valid location. I've added the location of the xlsx workbook as a trusted WSS file location but i still get this error. I'd like to know if there are any possible explanations for this error. Thanks in advance guys.

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Fri, 22 Feb 2008 22:21:53 GMT

Can you open the file via EWA?

When you run into issues like that, that's the first thing you should check - that will tell you whether the issue is with the server or with your software.

re: First "Hello World" code sample with the Excel Services APIs!

Jason — Fri, 22 Feb 2008 22:58:49 GMT

I can open it via EWA. Sorry bout leaving that part out before. I'm thinking it might have something to do with either the default credentials I'm passing into the function. Or that it has to do with the workbook location. The workbook is located in a content database path (http://servername/site/subsite/filename.xlsx).

re: First "Hello World" code sample with the Excel Services APIs!

Phaneendra — Mon, 25 Feb 2008 14:37:13 GMT

Can i set security on Sheet level in a published workbook in Excel Services? My intension to publish a workbook with four sheets( i.e. user1,user2,user3,Admin). Every user have only access to his/her sheet only.

But Admin can view all sheets as well as by using excel built-in formulas he can go for some calculations by taking input from some/all other user sheets information.

Does it possible in Excel Services?

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Wed, 27 Feb 2008 04:12:54 GMT

Jason:

If your user can open it in a browser, they should be able to open it through the API. What type of application is this?

Phaneendra:

We do not support this level of granularity with security - sorry.

re: First "Hello World" code sample with the Excel Services APIs!

Anshuman — Thu, 28 Feb 2008 10:28:20 GMT

I am facing a similar kind of issue regarding SOAP exception at OpenWorkBook method.

i am able to open the sheet in browser, i.e. it is working fine in EWA, but not coming up using web service.

I have checked that the workbook is stored at the trusted location. also I have checked the permission of the user. It's not working even by providing the Full Control.

What else could be the possible reason for this SOAP Exception?

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Thu, 28 Feb 2008 21:06:23 GMT

Can you paste the skeleton of your code (everything relevant up to and including the OpenWorkbook call)?

re: First "Hello World" code sample with the Excel Services APIs!

Anshuman — Fri, 29 Feb 2008 10:29:42 GMT

Here is that snippet of code:

private void button1_Click(object sender, EventArgs e)

{

ExcelService proxyService = new ExcelService();

proxyService.SoapVersion = SoapProtocolVersion.Soap12;

proxyService.Credentials = System.Net.CredentialCache.DefaultCredentials;

Status[] status = null;

string SessionId = null;

string pathWorkbook = "http://litwaredemo:13300/sites/mysitecollection/ExcelWorkBooks/Calculator.xlsx";

SessionId = proxyService.OpenWorkbook(pathWorkbook, String.Empty, String.Empty, out status);

status = proxyService.SetCellA1(SessionId, "Calculator", "Loan", textBox1.Text);

status = proxyService.SetCellA1(SessionId, "Calculator", "Rate", textBox2.Text);

status = proxyService.SetCellA1(SessionId, "Calculator", "Years", textBox3.Text);

status = proxyService.CalculateWorkbook(SessionId, CalculateType.CalculateFull);

object result = null;

result = proxyService.GetCellA1(SessionId, "Calculator", "Payment", true, out status);

if (result != null)

textBox4.Text = result.ToString();

proxyService.CloseWorkbook(SessionId);

}

Its just a small application for calculation.

SessionId = proxyService.OpenWorkbook(pathWorkbook, String.Empty, String.Empty, out status);

this line of code is throwing the SOAP exception.

re: First "Hello World" code sample with the Excel Services APIs!

Satish — Thu, 13 Mar 2008 08:55:12 GMT

hey guys i have s problem........

While using UDF's i get the return values in a data table.

Now i wannt to show this entire table in the excle sheet as it is.

How can I do that?

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Thu, 13 Mar 2008 21:24:34 GMT

Can you further explain what the issue is?

what do you mean by Data table? What tdo you mean "as it is"?

re: First "Hello World" code sample with the Excel Services APIs!

Sanjay — Wed, 26 Mar 2008 16:29:14 GMT

Hi,

The OpenWorkbook() is throwing the following exception:

"Excel Web Services could not determine the Windows SharePoint Services site context of the calling process"

Please note:

1> I'm using Excel Web Reference not static binding

2> The excel file is in trusted location.

3> I'm able to browse the excel file using IE.

Please let me know what colud be the problem?

re: First "Hello World" code sample with the Excel Services APIs!

Kiran Reddy — Mon, 17 Aug 2009 17:47:40 GMT

Hi Sahar,

This is kiran reddy. i Want to know how to convert excel data in Visual Basic code language

re: First "Hello World" code sample with the Excel Services APIs!

Shahar — Mon, 17 Aug 2009 21:55:33 GMT

Not sure I understand the question, Kiran.

re: First "Hello World" code sample with the Excel Services APIs!

kiran reddy — Tue, 18 Aug 2009 17:08:56 GMT

how to learn visual basic through online? is there anybody to teach VB