Showing posts with label Excel Services. Show all posts
Showing posts with label Excel Services. Show all posts

Friday, April 3, 2009

Office Server Search and Excel service missing

Scenario:
While installing new MOSS server , I found some of the services missing. After checking all the components, I found out the cause.

Reason:
It was my mistake. I choose Web-Front End option and not Complete install.

Take away:
Office SharePoint Server Search service missing : This can be because of more than one reasons
a. You might have installed only WSS
b. Web Front end option installed, use Complete install.

Excel Calculation Service missing : This can be because of more than one reasonsa. You might have installed only WSS
b. Web Front end option installed, use Complete install.
c. You have installed MOSS Standard edition , its only available with Enterprise version

Article
Similar post

Monday, September 8, 2008

Creating User-Defined Function for Excel

Code:

using System;
using System.Collections.Generic;
using System.Text;

using Microsoft.Office.Excel.Server.Udf;

namespace ExcelSamples
{
[UdfClass]
public class MyFirstUDF
{
[UdfMethod]
public Int32 RandomNo()
{
Random r = new Random();
return (Int32)((r.NextDouble()*5)+1);
}
}
}
Article:
http://msdn.microsoft.com/en-us/library/bb428649.aspx
http://www.wrox.com/WileyCDA/Section/Excel-Services-User-Defined-Functions-UDFs-.id-305100.html