Thursday, July 12, 2007

Let's Talk about .. MOSS2007-Excel Services

My division executive suggessed the member of the division to read the MSDN article about the Excel Services. I think MSDN article is very useful when we want to know about the features of Microsoft's products.

The Excel Services is one of the new technology in MOSS 2007. The users can load, calculate, and display the Excel worksheets on SharePoint Server 2007. The important thing is the ability that user can the data to display, and maintain a single version of Excel worksheet without writing custom code.

Two primary interfaces for Excel Services are available:-
(1) Excel Web Access Web Part: you can view and interact with a live worksheet via browser.
(2) Excel Web Services: for programmatic access.

The user can view live, interact worksheets and save it within portal sites. It's able to analyze PivotTable reports and charts by browser.

The selected cells in worksheets can be edited by making the parameters to them. When saving the items that users choose to make viewable, they will appear in the Parameters pane in Excel Web Access.

Anyway, the users have to create a workbook by MS Office Excel 2007 because creating function is not enable in Excel Services.

No comments: