Using the Excel Services 2010 REST API

Discover Items in a Workbook
http://myserver/mywebsite/_vti_bin/ExcelRest.aspx/Shared%20Documents/Sales_Report.xlsx/Model

Retrieve Various Items in Different Formats
http://myserver/mywebsite/_vti_bin/ExcelRest.aspx/Shared%20Documents/Sales_Report.xlsx/Model/Range




http://msdn.microsoft.com/en-us/library/ff961897(v=office.14).aspx

Working with SharePoint 2010 Projects on Visual Studio Without Installing The Server

How many times we suffered from the error “A SharePoint server is not installed on this computer. A SharePoint server must be installed to work with SharePoint projects.”  when you try to create sharepoint solution? How many of us tried to create his own SharePoint Server 2010 development environment under Windows 7 OS but he faced this problem?

After spending unreasonable amount of time searching through the internet, reading blog posts and forums the only answer that I found to solve this problem was, “it is not possible, you have to install sharepoint server 2010 on your machine”, and if your operating system is windows 7, then the best thing you have to do is to find and install the beta version of sharepoint server 2010.

First step, from server machine (production server) run regedit and export the folder

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Shared Tools/Web Server Extensions/14.0]

Second step, on your local development machine, import the regedit file that you exported before or you can just only double click on exported regedit file. it will create a “Web Server Extensions” folder and the 14 hive registry for you.

 Finally, You will now be able to create a Sharepoint Project in Visual Studio 2010. When asked where the Sharepoint server is, tell Visual Studio it’s on your local machine. You will not be able to deploy locally (unless you actually *do* have Sharepoint installed), but you will now be able to create Sharepoint projects, and will be able to build package them.

NOTE: to be able to work on sharepoint developmentm for sure you will be need to add some sharepoint server assemblies to your project which will be not on your development machine like Microsoft.Sharepoint.dll.

I suggest you to copy those assemblies from your server machine (production server) and add them as references to your projects.

All SharePoint Server 2010 assemblies can be found under:

C:Program Files/Common Files/Microsoft Shared/Web Server Extensions/14/ISAPI

 Testing the environment

Create a project. To test, I simply created a Blank Sharepoint Project (first one was sandboxed, second one was full trust (farm)), and added a webpart with a label displayed.

protected override void CreateChildControls()

{

      base.CreateChildControls();

      Label l = new Label() { Text = "BLAH!" };

      this.Controls.Add(l);

}

Build the solution (so that you generate .pdb files) and then right click on the project in the Solution Explorer and choose “Package”. This will generate a .wsp file.

Now deploy your sandbox and the farm solutions as usual and see the results.