Showing posts with label sps2010. Show all posts
Showing posts with label sps2010. Show all posts

Tuesday, March 30, 2010

Developer Dashboard

hi,
A new capability to debug and deep analysis is named "Developer Dashboard". Actually it gives the much information about the rendered page, once this is 'ON' the developer can see ->
  1. Time taken to render by each method in page life cycle
  2. information about page, current user, page status etc
  3. Time taken by database queries
  4. Time taken by web part to render [each web part]
etc
The command to enable Daveloper Dashboard is -
stsadm -o setproperty -pn developer-dashboard  -pv ondemand
[The -ov options are On, off, Ondemand]
after the command is completed successfully a small icon on top left [next to currentlyLog in user] will appear.

The informtion on bottom of page is - This informtion can be used for deeper
analysis of performance.

 

Cheers for debugging !!

Wednesday, March 24, 2010

Document Set, Knowledge Managment And MetaData

Hi,

 
I was just going through knowledge management options with SPS 2010, I find some very basic steps to create a KM store within minutes [of course you should have taxonomy or atleast some thoughts in ready :) ]

 
Document Set and Meta Data service plays a important role in KM management. So let;s have a one liner of both of these -

 
Document Set -> Obvious from name documents can be grouped within one set, can be created from base content type 'Document set'.

 
Meta Data Service -> Another service given by SPS 2010, helps in adding meta data with documents. Since this is a service, term set defined in one service can be consumed by different web applications in different FARM altogether.

 
So below is the idea for KM in sps 2010 [The first step is optional, you can directly start from CA]-

 
  • Choose on source web app [from thsi web app you can easily modify content type]
  • Goto CA -> ManageService Application
  • Select the Manage ServiceApplication proxy. The UI will look like [Fig-1]

 
 
 
  • After creating term set, goto Site->Site Settings->Galleries -> Site Content Type
  • Create New contet type with base type as 'DocumentSet'.
  • Goto Document Library, from advanced settings, enable content type.
  • Now come to document upload of Document Library, you will see 'DocumentSet' right there !!.

 
In part 2 we will see KM from these information.

Thursday, March 11, 2010

ASP.net Integration with SharePoint 2010

Hi,

 
from Couple of days I was trying to integrate asp.net application into SPS 2010. The integration was simple, but the glitch was the asp.net files were written in asp style, those pages were written in early days of .net. So I did we appraoch to this problem, below are some technical points in this direction -

 
Some how we need the old story , .aspx pages and corresponding dll deployed to bin or GAC.

 
For this simple requirement, we created new project of type 'web application' [this ensures out put as dll], deployed it to bin and added entry in <safe control> in web.config. [I was getting can not load type as not registred as safe, after struggling with this stupid error, I created simple console application, used reflection and cheked out what are the classes in this namespace, once done, the code was running like anything]

 
now comes the tricky part, how to integrate the pages, I tried importing them to contentDB using SPD [nothing worked]
Then used features to deploy the pages and worked like charm :)
The integration done :)

 
Few more technical points in this journey -
  • Added each page within master page.
  • used ContentPlaceHolderMain for displaying the pages.
  • When integrating frame and iframe gave some problems.
  • controls were accessible using document.getElementById(), rather then document.formname.elementName.[even within window.opener]
  • Since the controls were simple html control need not to use &lt%=.ControlID%&gt
  • have to remove runat="server" from &ltForm&gt
Hope this will help you if you are trying something similar on these lines :)

Tuesday, March 9, 2010

V4.0 master page with just placeHolder

hi,

Today I created very basic master page i just has required placeholder, since I could not find it over net I thought let's post it, may be some body else will find it usefull :) below is code -
<%@ Master Language="C#" %>
<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Import Namespace="Microsoft.SharePoint" %> <%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Import Namespace="Microsoft.SharePoint.ApplicationPages" %>
<%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register TagPrefix="wssuc" TagName="Welcome" src="~/_controltemplates/Welcome.ascx" %>
<%@ Register TagPrefix="wssuc" TagName="MUISelector" src="~/_controltemplates/MUISelector.ascx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html lang="<%$Resources:wss,language_value%>" xmlns:o="urn:schemas-microsoft-com:office:office" runat="server" dir="<%$Resources:wss,multipages_direction_dir_value%>" __expr-val-dir="ltr">
<head runat="server">
<meta http-equiv="X-UA-Compatible" content="IE=8"/>
<meta name="GENERATOR" content="Microsoft SharePoint"/>
<meta name="progid" content="SharePoint.WebPartPage.Document"/>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta http-equiv="Expires" content="0"/>
<SharePoint:RobotsMetaTag runat="server"/>
<title id="onetidTitle"><asp:ContentPlaceHolder id="PlaceHolderPageTitle" runat="server"/></title>
<SharePoint:CssLink runat="server" Alternate="true"/>
<SharePoint:Theme runat="server"/>
<SharePoint:CssRegistration Name="minimalv4.css" runat="server"/>
<SharePoint:CssRegistration Name="layouts.css" runat="server"/>
<SharePoint:ULSClientConfig runat="server"/>
<SharePoint:ScriptLink language="javascript" name="core.js" OnDemand="true" runat="server"/>
<SharePoint:CustomJSUrl runat="server"/>
<SharePoint:SoapDiscoveryLink runat="server"/>
<asp:ContentPlaceHolder id="PlaceHolderAdditionalPageHead" runat="server"/>
<SharePoint:DelegateControl runat="server" ControlId="AdditionalPageHead" AllowMultipleControls="true"/>
<SharePoint:SPShortcutIcon runat="server" IconUrl="/_layouts/images/favicon.ico"/>
<SharePoint:SPHelpPageComponent Visible="false" runat="server"/>
</head>
<body onload="javascript:if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();">
<form runat="server" onsubmit="if (typeof(_spFormOnSubmitWrapper) != 'undefined') {return _spFormOnSubmitWrapper();} else {return true;}">
<asp:ScriptManager id="ScriptManager" runat="server" EnablePageMethods="false" EnablePartialRendering="true" EnableScriptGlobalization="false" EnableScriptLocalization="true" />
<WebPartPages:SPWebPartManager id="m" runat="Server"/>
<SharePoint:FormDigest runat="server"/>

<asp:ContentPlaceHolder ID="SPNavigation" runat="server">
</asp:ContentPlaceHolder>

<div >


<asp:ContentPlaceHolder id="PlaceHolderHelpButton" runat="server">

</asp:ContentPlaceHolder>
<asp:ContentPlaceHolder id="PlaceHolderWelcomeMenu" runat="server">

</asp:ContentPlaceHolder>
<asp:ContentPlaceHolder id="PlaceHolderDeveloperDashboardLauncher" runat="server">

</asp:ContentPlaceHolder>
</div>



<asp:ContentPlaceHolder id="PlaceHolderSiteName" runat="server">
</asp:ContentPlaceHolder>



<asp:ContentPlaceHolder id="PlaceHolderPageTitleInTitleArea" runat="server" />


<asp:ContentPlaceHolder id="PlaceHolderPageSubTitle" runat="server" />



<div>
<asp:ContentPlaceHolder id="PlaceHolderTitleBreadcrumb" runat="server" />
</div>
<div id="maincontent">
<asp:ContentPlaceHolder id="PlaceHolderMain" runat="server" />
</div>
<div style="display:none;">
<asp:ContentPlaceHolder id="PlaceHolderLeftNavBar" runat="server" />
<asp:ContentPlaceHolder id="PlaceHolderNavSpacer" runat="server" />
<asp:ContentPlaceHolder id="PlaceHolderBodyLeftBorder" runat="server" />
<asp:ContentPlaceHolder id="PlaceHolderPageImage" runat="server" />
<asp:ContentPlaceHolder id="PlaceHolderTitleLeftBorder" runat="server" />
<asp:ContentPlaceHolder id="PlaceHolderSearchArea" runat="server" />
<asp:ContentPlaceHolder id="PlaceHolderTitleAreaClass" runat="server" />
<asp:ContentPlaceHolder id="PlaceHolderTitleAreaSeparator" runat="server" />
</div>
<div id="DeveloperDashboard">
<SharePoint:DeveloperDashboard runat="server"/>
</div>
</form>
</body>
</html>

Friday, February 12, 2010

First DashBoard in SharePoint 2010

hi,

Today I created first dashboard, since I invested time in gathering information, I thought lets blog all at one place.
1. Create site using BI template [this particualr point took whole lot of time to find]

2. Click Start using performace Point service, Run DashBoard designer.


Now you are required to create dashboard.
Dashboard is collection of score cards, KPIs and Reports. The PPS team is giving good start in form PDF file at technet. Few starting points which I like are
http://technet.microsoft.com/en-us/library/bb794633.aspx
http://blogs.adatis.co.uk/blogs/timkent/archive/tags/PerformancePoint+Monitoring/default.aspx
http://performancepointblog.com/

Enjoy!!

Monday, January 18, 2010

SharePoint 2010 (Beta) Training Kit

download it from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=f1599288-a99f-410f-a219-f4375dbe310c

Monday, January 11, 2010

Completely Remove Left Navigation from v4. master Page

hi,

yesterday i was goign through the htmls of master page, the big difference I found is tables has been replaced by <Div>. The team gave OOB minimal v4.0 Master page also v3.0 master pages are present.

I was trying to remove left navigation completely, after investing some time below are the steps to do it -
look for div id="s4-leftpanel" class="s4-notdlg"
right click on it, select tag, remove that complete portion. you just removed the left navigation..every thing Quick launch,Recycle Bin. But to work the master page properly add the removed contentPlace Holders again, below are the contentPalce holder which should be added at minimum to work it proper -
<asp:ContentPlaceHolder id="PlaceHolderLeftNavBarDataSource" runat="server" />
<asp:ContentPlaceHolder id="PlaceHolderCalendarNavigator" runat="server" />
<asp:ContentPlaceHolder id="PlaceHolderLeftActions" runat="server"></asp:ContentPlaceHolder>
<asp:ContentPlaceHolder id="PlaceHolderLeftNavBarTop" runat="server"/>
<asp:ContentPlaceHolder id="PlaceHolderLeftNavBar" runat="server"></asp:ContentPlaceHolder>
<asp:ContentPlaceHolder id="PlaceHolderQuickLaunchTop" runat="server"></asp:ContentPlaceHolde>

now to use the complete space occuiped by left nagivation ->
Div with ContentID = MSO_ContentTable has a style class s4-ca which sets left margin to 115, make it to 0 and you are done.
it should look like -
div class="s4-ca s4-ca-dlgNoRibbon" id="MSO_ContentTable" style="margin-left:0px"

Done..use compelet space now!!

Friday, January 8, 2010

Silverlight ClientObject Model, uploading File to Document Library

Hi,
I want to share the new learning with all of you,I was trying to upload file to document library suing client object model. the client Object Model for Managed code gives option for 'SavebinaryDirect()' but no such thing for silverlight, then how to achieve the same goal using silverligt. hey below is the code -

private void uploadFileToDocumentLibrary(string fileName, byte[] fileContent)
{
ClientContext cnt = ClientContext.Current;

listForUpload = cnt.Web.Lists.GetByTitle("Redmond");

this.Dispatcher.BeginInvoke(delegate()
{
cnt.Load(listForUpload);
cnt.Load(listForUpload.RootFolder);
cnt.Load(listForUpload.RootFolder.Files);
cnt.ExecuteQueryAsync(succeedUploadFileListner, failureUploadFileListner);
});

}


private void succeedUploadFileListner(object sender, ClientRequestSucceededEventArgs e)
{

// byte[] dataArray;
Microsoft.SharePoint.Client.File file1 = listForUpload.RootFolder.Files[0];
this.Dispatcher.BeginInvoke(delegate()
{
byte[] dataArray = allFiles[lstFiles.Items[0].ToString()];
FileCreationInformation file = new Microsoft.SharePoint.Client.FileCreationInformation();

file.Content = dataArray;
file.Overwrite = true;
file.Url = lstFiles.Items[0].ToString();
listForUpload.RootFolder.Files.Add(file);
listForUpload.Update();
ClientContext.Current.ExecuteQueryAsync(s1, f1);


});


}

private void s1(object sender, ClientRequestSucceededEventArgs e)
{
this.Dispatcher.BeginInvoke(delegate()
{
MessageBox.Show("File Uploaded");
});
}
private void f1(object sender, ClientRequestFailedEventArgs e)
{
this.Dispatcher.BeginInvoke(delegate()
{
if (string.IsNullOrEmpty(e.Message))
{
MessageBox.Show(e.Exception.InnerException.Message);
}
else
{
MessageBox.Show(e.Message);
}
});
}
Key things are - First list should be loaded, then you can access .rootFolder and add files to it. this is the reason why I am writting actual file upload code in succeddLisnter of List load.

File.Url is file name and list.rootFolder gives the address like http:///.

In this snippet the error which bugged me most is 'Remote server returned error:Not found'. this error comes when the requested object is not reachabel, reasons could be typo error or invalid url or like in my case I was giving file.Url = "http://... full url where as it should be file Name like try.txt.

the second error I found at I was trying to add files before list lost, the moment I replaced to add file code to succeddLisnter it worked like charm. try this

Cheers :)

Friday, January 1, 2010

Client OM,Delete multiple items from Document Library Asynchrously[silverlight]

hi All,
Very happy new year to all of you. first day of 2010 gave me new information while working with client object model asynchrnously, which I want to share with all of you.

Below is the code to delete obect from list, using Client OM ->
private void btn_Delete(object sender, RoutedEventArgs e)
{

foreach (GridData data in dataSource)
{
if (data.IsChecked)
{

if (!(selectedItems.ContainsKey(data.DocID)))
{

selectedItems.Add(data.DocID, data.DocUrl);
}
}
}
if (selectedItems.Count > 0)
{
foreach (var grd in selectedItems)
{
deleteItem(grd.Key, grd.Value);
}

}

else
{
MessageBox.Show("Please select atleast one item");
}
}
private void deleteItem(string itemID, string itemUrl)
{

if (cnt == null)
{
throw new Exception("connection failed");
}
else
{

List olist = cnt.Web.Lists.GetByTitle(listName);
ListItem item = olist.GetItemById(itemID);
item.DeleteObject();
this.Dispatcher.BeginInvoke(delegate()
{
cnt.Load(olist, list => list.Title);

cnt.ExecuteQueryAsync(delete_succeedListner, delete_failureListner);
});
}
}
private void delete_succeedListner(object sender,ClientRequestSucceededEventArgs e)
{

this.Dispatcher.BeginInvoke(delegate()
{
MessageBox.Show("Item deleted");
});

}

this is perfactly fine to delete single item from list. Why I am saying so? just look at code once again, actually item is getting deleted at succeddListner, where nothing otherthan messageBox, which means it will always delete the last item from for loop (where I am caling deleteItem()), it will loose all the previous information and will not work as in synchrouse way. what to do for multiple delete in this case? ideally in succeedLisnter, when one item is deleted. deleteItem() should be invoked again to delete the second item, and so on.check the below code for multiple item delete -
private void btn_Delete(object sender, RoutedEventArgs e)
{

foreach (GridData data in dataSource)
{
if (data.IsChecked)
{

if (!(selectedItems.ContainsKey(data.DocID)))
{

selectedItems.Add(data.DocID, data.DocUrl);
}
}
}
if (selectedItems.Count > 0)
{
string tobeDeleted_key = string.Empty;
string tobeDeleted_value = string.Empty;


tobeDeleted_key = selectedItems.First().Key;
tobeDeleted_value = selectedItems.First().Value;
deleteItem(tobeDeleted_key, tobeDeleted_value);


}

else
{
MessageBox.Show("Please select atleast one item");
}


}
private void deleteItem(string itemID, string itemUrl)
{
cnt = new ClientContext(serverUrl);
if (cnt == null)
{
throw new Exception("connection failed");
}
else
{
MessageBox.Show(itemUrl + " From listName " + listName);
oList = cnt.Web.Lists.GetByTitle(listName);
ListItem item = oList.GetItemById(itemID);
item.DeleteObject();
oList.Update();
this.Dispatcher.BeginInvoke(delegate()
{
cnt.Load(oList, list => list.Title);
cnt.ExecuteQueryAsync(delete_succeedListner, delete_failureListner);
});
}
}
private void delete_succeedListner(object sender,ClientRequestSucceededEventArgs e)
{
string tobeDeleted_key = selectedItems.First().Key;
this.Dispatcher.BeginInvoke(delegate()
{
MessageBox.Show("Item deleted");
selectedItems.Remove(tobeDeleted_key);
if (selectedItems.Count > 0)
{
string tobeDeleted_value = string.Empty;
tobeDeleted_key = selectedItems.First().Key;
tobeDeleted_value = selectedItems.First().Value;
deleteItem(tobeDeleted_key, tobeDeleted_value);
}
else
{
fillDataGrid();
}
});

}

Cheers!!

Thursday, December 31, 2009

Currently Logged-In username

Its easy to get currently loggedin user name in clientObject Model. below is the code used in silverlight application.

private string GetLoggedUserName()
{
string name = string.Empty;
try
{
ClientContext cnt = new ClientContext("serverUrl");
if (cnt != null)
{
user = cnt.Site.RootWeb.CurrentUser;
cnt.Load(user);
cnt.ExecuteQueryAsync(loginNameSuccess, loginNameFailure);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " Inner Exception:" + ex.InnerException.Message);
}
return name;
}

private void loginNameSuccess(object sender, ClientRequestSucceededEventArgs e)
{

this.Dispatcher.BeginInvoke(delegate()
{
MessageBox.Show(user.LoginName);

});

}

Monday, December 21, 2009

Add Excel Web Renderer Webpart From SilverLight ObjectModel

Hi,
First in How To's :)
To add a Excel Webpart from Silverlight oject Model -





ClientContext cnt = new Microsoft.SharePoint.Client.ClientContext("http://hydhtc130180d:3333/");
if (cnt == null)
{
throw new Exception("connection failed");
}
else
{
string ewaWebpart = "<?xml version='1.0' encoding='utf-8'?><webParts><webPart xmlns='http://schemas.microsoft.com/WebPart/v3'><metaData>";
ewaWebpart +="<type name='Microsoft.Office.Excel.WebUI.ExcelWebRenderer, Microsoft.Office.Excel.WebUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' />";
ewaWebpart +="<importErrorMessage>Cannot import this Web Part.</importErrorMessage>";
ewaWebpart +="</metaData>";
ewaWebpart +="<data>";
ewaWebpart += "<properties>";
ewaWebpart += "<property name='Title' type='string'>ExcelWebRenderer</property>";
ewaWebpart += "</properties>";
ewaWebpart +="</data></webPart></webParts>";
LimitedWebPartManager limitedWebPart = cnt.Web.GetFileByServerRelativeUrl("/SitePages/mypage.aspx").GetLimitedWebPartManager(PersonalizationScope.Shared);

WebPartDefinition ewaWebPartDef = limitedWebPart.ImportWebPart(ewaWebpart);
limitedWebPart.AddWebPart(ewaWebPartDef.WebPart,"Left",1);


cnt.ExecuteQueryAsync(s1, f1);

Friday, December 18, 2009

Developer's Attraction for Sharepoint 2010

In previous post I tried to expalain some of the new terms with respect to SharePoint 2010, which business is asking since last version. This post is devoted to developers with same vision in mind.

  • Windows PowerShell Administration : This is really powerfull tool which is there to replace stsadm. stsadm is there to maintain backward compatibiltiy but goign forward cmdlet will rule the sharepoint world. These are command line option which can take result of previous command and can produce objects. This eventually helps is getting small items in working just in few line without wirtting console application for the same, like getting webID. they even can be used in back up restore with vast improvements in performance.
  •  Visual Studo2010 : Lets user to do F5 for sharepoint project, allows user to create visual webpart,  deploy the solution over sandbox, lets developer to create BCS project, content Type and list schema etc.
  • LINQ to SharePoint - This is news to developers...let's learn LINQ, this is new coding style.
  • ClientObject Model - Marvoul point, the team introduced Object Model for javascript,Silverlight and managed code. dev can use the dlls like Microsoft.Sharepoint.Client.Silverlight to work at client side. [will post some how'to very soon]
  • SharePoint Designer2010: allows developer to create new list, new Fom, new content Type and many activties from Designer interface.
 Keep watching for some how to's

Business Attraction for sps2010 / SharePoint 2010

Hi,
Sorry for not being able to post for a long time. In this Post I will try to describe some of new functionalities  which can be described as selling point for the business.

  • Claim Based Authentication -  Authentication can be done against - Active Directory, LDAP,application specefic database,user centric model like LiveID.It is based on 'GENEVA' technology, which it self is comibination of Geneva Server, geneva CardSpace and Geneva FrameWork. In one line - Identity is kept in token, token cotains one or more information about user.
  • BCS - Business Connectivity Services- New generation BDC, open scope for external list though which data can be inserted into LOB system.
  • High Availability-
  • FAST Search [Need extra licensing]-As of now fast search has been integrated as it is in the product.
  • Remote Blob Storage- It is possible to have BLOB  and customised pages in the database stored in out side database such as file system.
  • Performance Control [thorttling]- Two options avaiable
        a. Performance throtlling - Provides a way to administrator where he can define the threshhold values for the server.
        b. list control - provides a way to limit the number of rows returned by a list. Alhtough the maximum number of items has increased upto 50 million items.
  • Backup and Restore- list level backup is possible though UI.
  • SharePoint Online and Multi tanancy- Service architecture gives support for better design in case of SharePoint online. the tenants are managed by subscriotion ID, and each tenatnt can subscribe to its needed service.
  • WorkOffline - workspace2010- Gives support for to bussiness user to work offline to sharepoint Libraries, where he becomes online, the library gets synchronised.
We will talk about more from dev's perspective in next post :)

Tuesday, November 10, 2009

The Diagram

Hi,

Let's Discuss the SharePoint 2010 as per the new diagram -








Sites : Work across firewall, to engage people in effective manner .

Communities : To find people across the network easily.

Content : Manage complete life cycle of content. which means , creation, review , publishing and disposal of the content.

Search : wow, new Fast search is waiting for you :) ..but separate licensee is needed to get FAST search..

Insights : Using Information in more effective manner as per business Need, next generation of Dashboard.

Composites : Creating business solution using OOB features of SharePoint





By the way..I came across most awaited feature in SharePoint -

When you change the site title , the new version even give you option to change the URL as per new title ..cool right !!

keep watching more stories are coming out .............

Tuesday, October 27, 2009

Ban is over to talk about sps2010 !!

VERY good morning with great news :)
Now it is legal to talk about sharepoint 2010 ..
I am trying to list very basic changes / enhancements..in very brief

(It works only on 64bit OS)
  1. The New logo..
  2. The New diagram .. of course..new represenation with new diagram..a pie chart with dark blue back ground . 




Some addition on Licensing Model


The New features..we will talk about in coming weeks are -

Business Connectivity Services (BDC)


Enterprise Content Management (ECM)


Enterprise Search


Performance Point Services


Excel Services


User Profile and Social Data

I will talk about these in coming post..till then..bye


Tuesday, September 22, 2009

External List

Good Morning--
The Normal sharepoint but it gets data from Line of Business Object..confusing right?
This is new feature of Sps2010 where the sharepoint list can import all data from any external system using 'Business Connectivity System' [BDC in MOSS]
The cool feature is after getting all data from external system, the developer can play with it like normal sharepoint list, can add column, data into column etc.

Wednesday, September 16, 2009

Excel Services and soap

Excel Services and Soap call.

javascript enabled web services can be used to get client side activites in Excel services.
Below is the code snippet for getRangeA1 -

request = new ActiveXObject("Microsoft.XMLHTTP");
var url = "http://localhost/_vti_bin/excelservice.asmx";
var envelope = "<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">"+
"<soap:Body>"+
"<getcella1 "+
"xmlns=\'http://schemas.microsoft.com/office/excel/server/webservices\'>"+
"<sessionid>"+ EwaGetSessionId('WebPartWPQ3') +"</sessionId>"+
"<sheetname>"+"Sheet1" +"</sheetName>"+
"<rangename>"+"B3"+"</rangeName>"+
"</GetCellA1></soap:Body></soap:Envelope>";

alert(envelope);
request.open("Post",url,false);
request.setRequestHeader("Content-Type","text/xml");
request.send(envelope);
alert(request.statusText);