Okay, I'd like to demonstrate now how we're
going to make use of this spreadsheet inside this Excel Web Access
Web Part. I just wanted to point out that you'll
find step-by-step instructions for this, for what we're doing right
now, in the, it's the DataLink
for Excel Services Guide that you'll find available with
the class materials, either on your CD or
available for download if you just go to the Main,
the Main Page when you open your CBT and download
the class materials. So, this is where you'd
find step-by-step instructions of everything I'm going to be doing right now.
So, we start by opening
up a spreadsheet, and in
this spreadsheet, well, we just want to make sure we've got some
DataLink Functions or the whole
thing's kind of pointless. We'll demonstrate something Microsoft's can do
but it won't show you much about DataLink. Yeah, here we go. Here's
something that we did in a previous exercise, this DataLink
5 exercise. We just did a Production Level
Report where we did some filtering with this PI Sample
Data Option.
So, I'd like to make use of this.
We're not going to be passing arguments or using Named
Ranges now. That's something we do in our full Web Parts class
if you're interested. But, I just want to make sure that this
is available somewhere where I can
make reference to it within the Web
Part Page. In moving this spreadsheet
onto the Document Library's pretty simple if you're working within
Office 2007. You just click on this Windows Button here,
choose Publish, and within Publish
you can choose Excel Services, and then Browse
through your network places. It's not always easy to find
but I'll go to the Top Level of my Server here
and, if I scroll down here, I can see -- yeah, here
it is. Here's my SharePoint Site.
Now I'm going to be putting this into, not the
ProcessBook Files Document Library, I'm going to put it into the same
Document Library as where I store the
WebPart Page that goes with this particular spreadsheet.
I just think it's better to keep them all together. So, I
would double-click on that and go ahead and Save
this here. Now, I do want to point out that I could have just
as easily Saved this locally, and
then uploaded this to the Document Library. So there's no real requirement
that you do it this way using this particular
Publish Option. Also one more point.
This Check Box is going to either
force Excel to open this up in the
WebPart Page as soon as you finish, you finish saving
this, or not. And, I think, in this case,
I'll go ahead and select that just to show you what it looks like.
I'll go ahead and Save. It's going into that
Document Library. You'll notice what happens is
Excel's going to go ahead and launch a browser to look at that.
You know, look at that Display. There we go.
But, that's not what we're interested in here. We're interested
in putting it on a specific Display, so let me close
that out. And, let's put this
back where I've been putting all of my Demo stuff. If you
remember, I had a nice little Demo Page going here called My
WebPart Page. I built it right at the beginning of the class.
I'm going to put this on there, so I'll
scroll down, give myself some room here. Let's go
into Edit Mode.
And,
we'll add this, you know, add this to the very bottom,
to the Footer here.
And, this time, instead of going to the
PI WebParts, we look in the Business Data
Section here, and under
Excel Web...err under there, choose Excel Web
Access. Now, as I pointed out, this is a Microsoft WebPart.
So, we did modify,
or did, did, you know, some coding to make sure that
DataLink works with it, but, for the most part this is
Microsoft's WebPart here.
Yeah, there we go. Let me pick this up and move it down
so it's a little easier to see
at the very bottom. There we go. Yeah, so you're
presented with the Wizard, but I'll be honest,
I really don't like those Wizards 'cause they keep changing
from one version to the next, whereas we tend not to change
this method. So, let's go and use this method. I'm going to go
ahead and modify this Shared WebPart by
going in here. You can see the Options as well.
We're going to go in here and specify
the Name of the workbook. So the workbook
is what I had uploaded to my,
this was, I put it into this CBT Demo.docs.
If you remember, that was the Document Library that contains it.
And, here it is.
Now we can choose,
you know, what we, what we display.
In this case, it's showing 75 rows.
I can Increase this, Decrease this,
as I choose to, and I can also
control the types of things that are happening
here in terms of recalculation. You know, all the
these kind of Options: the Size, the
Shape, etc. All that's available.
So, for example, let me, I want to make this larger
I go ahead and
say let's make this, oh, let's make this 700 pixels.
I'll go ahead and say OK.
And, you probably can't see it, but,
there we go. It updated awfully quick.
Let's go into Build, err, out of Build Mode, into
Run Mode.
Can't really see it, but that was refreshing this
screen, and there's our, there's our
report now.
Again, this is a web page, so you don't have the Option
here to Edit.
If you stick around for our
full WebParts class, the PI WebParts
class, we go into details on how you can actually add
parameters and pass parameters to this from one web part to another,
to actually change those Values. Alternately,
here, you can choose Open, in Excel,
and then from there you can go ahead and make your changes and Save it, just like
what we did with ProcessBook.