Microsoft Office Tutorials and References
In Depth Information
Authoring Your First Excel Sheet and Publishing It to Excel Services
One fine morning, my program manager came to me and said, “Hey, why not take the tasks from Team Foundation
Server (TFS), export them to Excel, and display status charts based on those tasks on our intranet web site?” Well,
that’s a great idea, and it can serve as a dashboard for our project status. So we exported tasks for all work items from
TFS and saved the file to one of our local drives as TeamTasks.xlsx, as shown in Figure 5-10 .
Figure 5-10. Sample data exported from TFS into Excel
■ We recommend you create an excel file with the data as shown in Figure 5-10 , because we’ll be using it in
most of the examples in this chapter.
Since the idea is to have this information on our intranet SharePoint site, we created a document library named
Excel Library to act as a container for the TeamTasks.xlsx file. We then followed these steps to publish TeamTasks.xlsx
to Excel Library:
Selected “Save to SharePoint” from the Backstage View 1 of Excel.
Clicked the Save As button under Locations.
In the Save As dialog, provided the URL and the document library name and clicked on Save.
■ to open an excel file in your browser, you’ll have to perform a preliminary step. On the ribbon, click library
tools ➤ library tab ➤ Settings and then click the library Settings button. then, under General Settings, click on
advanced Settings and, in the “Opening Documents in the Browser” section, ensure that the default behavior of opening
browser-enabled documents is set to “Use the server default (Open in the browser).”
Opened our intranet SharePoint site, and accessed the Excel Library document library.
1 Backstage View, introduced in previous version of Office, has an interface you can view when you click it on the File tab. This view
has features that are not available as part of the ribbon.
Search JabSto ::