About Me

I am a Software Engineer presently working in Microsoft as vendor.The main aim of this blog is to Share my knowledge in Sharepoint,AZURE and Silverlight.

Sunday, 18 May 2008

Publishing Excel webpages for Sharepoint.

Requirement: user should be able to see the data of excel sheet in SharePoint without grid lines and in a single page scrolling(Rather than scrolling in excel web part and SharePoint pageview webpart).

Solution:

1) Create a SharePoint document library for excel.
2) Open Excel from your desktop or using new from SharePoint excel document library menu.
3) Paste the required data in to sheet or input some values which is required to display.
4) Format the excel sheet as per your requirement to Display. The formatting done in excel sheet gets effect in SharePoint page.(Ex: Numbers to show in left align or right align see in the below image I aligned numbers to left)
5) And click on Saveas button and Save the excel sheet as webpage which is having .htm extension in the SharePoint library EX: http://sasikp-v:720/MyEXcelsheets (easy way is to open library in windows explorer mode and copy the url and paste).
6) Go to the library of excel and click on the excel u saved it opens in SharePoint as webpage.

You can directly edit the excel sheet and save the changes. Here is the sample I done.
We can give Title also by clicking on Change title button while saving the sheet.