OSIsoft: Directed Exercise on Excel Web Access (EWA). v2.2

Uploaded by OSIsoftLearning on 24.05.2011


Now we are just about
ready to do our next directed exercise, the
grand finale which is to use the Excel Web Access
WebPart to show this on a webpage.
But before we do that, I want to mention that
this is something that is only
installed with Microsoft Office SharePoint Server
and not Windows SharePoint
Services. So if you
only have the free version of
SharePoint, you will not have this Excel Web Access
WebPart that is not going to be available to you.
So let's go ahead and look at our next directed exercise.
The directed exercise here is
I'd like you to open up the
Excel spreadsheet that we used in the previous
exercise, and publish it to Excel Services.
Actually that's something that I just demonstrated but we'll
go over that again. We'll upload that spreadsheet
to a document library. Again we've done that before
but I'll go over those steps. We are going to
add that Excel Web Access WebPart to a webpart page,
modify that WebPart page for
that WebPart to show that specific
spreadsheet that we uploaded to the document library and then
we'll test everything. So that's how we are going to
proceed. I'll start by going into

this is a SharePoint document
library to which I had uploaded that spreadsheet.
So the first step was to
publish that spreadsheet
and set its parameters up.
So if I open this up, I can show
you how to set those parameters.
Actually a couple of things. First you have to save that spreadsheet
and then upload it to this document library.
And I've already done that and I'm not going to do it again.

I would just choose upload and upload the spreadsheet.
Next open this up in Excel.

Once this opens, there is an option
called server that allows you to specify
what parameters you are going to be using in this document.
So if you recall in the previous
video I had already set this up so that I was using
end time, start time and tag name as the there
paremeters associated with this spreadsheet. And I'm showing just the first sheet.
Again the way we did that
was by going into
this Server option here.
Now I just showed you
two steps to use. You can upload and then configure
the server. Again for some folks,
if you have
the proper version of Office or certain
versions of Office, you can do both those steps at once by
doing Publish, Excel Services and then publishing
directly to that document library and setting the
parameters at that time.
OK, so I'm ready and I can go ahead
and close this out. And I don't want to save any
of that. I had already saved that after
I had set this. So it is important for
you to save after you've set the server options,
to save that again. Now the next thing is to
add a WebPart, the Excel
Access WebPart.
I should say the Excel Web Access WebPart.

I'll do that by going off to, let's go up one
level to my labs site here.
I'm in my document library right now. I'll go up
to my lab site and I'm just going to add this
to one of the existing zones.
So I'll go into edit this
page. This could be really any WebPart
page. I'm just going to
add the Excel Web Access.
So under all
WebParts, you see this Excel Web Access WebPart?
I'll go ahead and choose Add.
Now where it appears, it first appears
with no configuration set. We have no
Excel spreadsheet associated with it.
So like most WebParts, we need to modify that
shared WebPart. We need to specify what
it is going to be reading. And in this case,
it's going to be reading that spreadsheet that
I just published to that SharePoint document library.
So I'm defaulting to my current location.
If I remember correctly, my spreadsheet
was uploaded to this Shared Documents, and there it is.
I'll go ahead and select it.
Click on OK.
And that's it, we are done. Actually the rest of it, the only thing I'm going to
do right now is just to try and make this look a little better.
So I'll go into appearance and I'm going
to set the width to, let's just go
with 1000px.
And when I click on OK,
that should be the big finish to this.
There we go. If you notice, here is my
Excel spreadsheet.
And if you look at
the current value, the current value
is the current time. You can't see it from
here but that is the current time on this machine.
So it is updating in realtime. And the big finish
to this would be if I scroll over

you can see those parameters. These are the parameters
that are used in this
workbook. And I think we can see them all at the
same time. So now I'm going to go ahead and
change the tag name to a different tag name,
BA:Level1 and I'm putting this in the tag name field.
I'll go ahead and choose Apply.
And that's the big finish to this exercise.
As you can see, we now have substituted
whatever we had put in here as an argument. And I can do the same
for the start time and end time.