<< . .

. 29
( : 51)



. . >>

copy a chart into FrontPage, assign a transparent background, save it as a .gif file, and
make it into an image map with linked hotspots.

Cross-
For a full discussion of all of FrontPage™s picture-editing features, see Chapter 12 of Wiley™s
Reference
FrontPage 2003 Bible.

To preserve cell formatting or to convert your entire spreadsheet (either one tab or all of
them) into a Web site, you can save your spreadsheet to an HTML file.

Copying tables into FrontPage
The quick and easy way to move a table into FrontPage is to copy the cells in Excel and
paste them into an open Web page in FrontPage. Copying and pasting cells preserves most
formatting, including font color, font size, alignment, shading, and border formatting. In
addition, you can always use FrontPage™s own table formatting to restore or add table and
cell formatting. Figure 14-4 shows a table from Excel moved into a FrontPage Web page.
Chapter 14 ¦ Integrating FrontPage with Office Applications 323




Figure 14-4 Charts copy and paste well in Office 2003 between Excel and FrontPage.


Exporting Excel sheets as HTML pages
You can send either a selected range of cells or an entire workbook to a Web page in Excel
by selecting File _ Save as Web Page from the Excel menu. If you first select the cells that
you want to convert, you can use the Selection Chart radio button in the Save As dialog box,
as shown in Figure 14-5.




Figure 14-5 You can send convert a selected range of cells into a chart with the Select
Chart option.
Part II ¦ Collaborating and Integrating with Office 2003
324

In the Save As dialog box, click the Selection: Chart button, choose a filename and
destination folder, and then click Save.
The Add Interactivity checkbox in the Save As dialog box creates a page with an Office
spreadsheet. For an explanation of how these interactive spreadsheets work in a Web page,
see the “Adding Office spreadsheets” section later in this chapter.

Sending charts to FrontPage
You can copy Excel charts into FrontPage Web pages through the Clipboard. The results
improved with Office 2003 ” copied charts come into FrontPage as nice, clean embedded
.gif images. When you save your page, you™ll be prompted to save the chart as well.
Another option is to save a selected chart as an HTML page in Excel.
To save a chart as an HTML page, follow these steps:
1. Open the Excel workbook and select the chart that you want to save.
2. Select File _ Save as Web Page. The Save As dialog box appears.
3. Click the Selection: Chart option button in the dialog box.
4. Select a folder in the Save In box to which you want to save your file.
5. Enter a filename for your chart in the File Name box, and click Save.
You can now import the HTML file into your FrontPage Web and use it in Web pages.

Saving Excel workbooks as folders
You can convert an Excel workbook with two or more tabs into a set of Web files. When you
do, Excel simulates a tabbed workbook that can be used to create a familiar format for Web
visitors who are used to looking up information in spreadsheets, as shown in Figure 14-6.
Chapter 14 ¦ Integrating FrontPage with Office Applications 325




Figure 14-6 You can use Excel to generate framed Web pages that look like workbooks.

To generate an Excel-based Web folder, follow these steps:
1. Open an Excel workbook with multiple tabs.
2. Select File _ Save as Web Page.
3. Select the Entire Workbook option button.
4. Navigate to the folder to which you want to save the generated Web files. Select
Save to save the entire workbook, or select Publish to save selected elements of the
workbook.
As you save or publish your workbook as a Web “page,” a set of files is generated in a
separate folder, which uses the name of your file followed by an underscore and the word
“files.” For example, if you save a workbook called Scores as a Web page, a folder is created
called Scores_files. That folder includes several files required for a Web site that is
based on your file. In addition, an .htm file is created in the parent directory (the one to
which you saved your file in the Save As dialog box), with the name of the file (for
example, Scores.htm).
When you import this generated Excel Web into FrontPage, you need both the .htm file
generated in the folder that you specify in the Save As dialog box and all the files in the
additional (_files) folder.
Part II ¦ Collaborating and Integrating with Office 2003
326


From PowerPoint to FrontPage
PowerPoint in Office 2003 converts slideshows to HTML pages when you select File _
Save as Web Page. As with Excel, a whole batch of files, including HTML and image files,
is generated when you do this conversion. In fact, rather than saving a “file” to a “page,”
you save many files to a folder filled with Web pages and other files.
The folders generated by PowerPoint don™t mesh well with FrontPage Web sites. Basically,
PowerPoint gives you a highly specialized Web site with complex page designs and links.
Use PowerPoint™s Publish as Web Page option, shown in Figure 14-7, if you want a seamless
slideshow on your Web site.




Figure 14-7 PowerPoint can generate Web pages.


Converting slides to Web pages
You don™t have to convert an entire PowerPoint slideshow to a Web site. If you want only a
single slide, you can save that slide as a .gif or .jpg (or .png) image. These picture
files can then be added to a Web page just like any other image from a file.
To save a single slide as an image file, follow these steps:
1. Open the slideshow and the slide that you want to convert to a graphic file.
2. With the slide in view, select File _ Save As. The Save As dialog box opens.
3. From the Save as Type drop-down list, select an image file format, such as .jpeg
or .gif.
Chapter 14 ¦ Integrating FrontPage with Office Applications 327

4. Navigate to a file folder and enter a filename in the File Name box.
5. Click the Save button.
6. When prompted with a dialog box that asks if you want to export every slide in the
presentation, click No. You will save only the slide that you are viewing.

Integrating a slideshow into FrontPage
A useful Office-to-FrontPage option is converting PowerPoint slideshows into FrontPage
Webs. The result is a JavaScript-driven online slideshow with expanding outlines and a full
set of navigation buttons that enable you to jump around in your slideshow. Figure 14-8
shows a PowerPoint slideshow dumped into FrontPage.




Figure 14-8: PowerPoint can generate automated online slideshows.

To convert a slideshow into a Web-based slideshow, choose File _ Save as Web Page, and
click Publish (not Save).
In the Publish as Web Page dialog box (Office 2003 really means Publish as Web Site dialog
box), select the slides you wish to export to your new Web folder. Additional options enable
you to include (or exclude) speaker notes. The three option buttons in the Browser Support
area allow you to choose the generation of browsers for which you will generate Web pages.

Generally, selecting Microsoft Internet Explorer 4.0 or later won™t harm anything. This option will
Note
embed some features (such as expanding outlines) that are not recognized by older browsers.
Viewers using older browsers, however, will still see the content of your slideshow.
Part II ¦ Collaborating and Integrating with Office 2003
328

After you select options in the Publish as Web Page dialog box, click the Publish button.
A set of HTML and image files will be generated. You can import these files into a
FrontPage Web.

Importing files into Webs
Each of the applications in Office 2003 that have been examined thus far can be used to
generate HTML files, and other Web files as well. You can use FrontPage™s Import menu to
integrate these generated Web pages or Web sites into FrontPage.
In many cases, when you import a file from Word, Excel, or PowerPoint, you must convert
the original file into an entire folder full of Web files. The folder will likely include image
files, but may also include scripts necessary to convert a slideshow, for example, into a Web
site. To import an entire folder, you can use the Folder option in the Import dialog box.
To import a file or folder with Office Web files into FrontPage, follow these steps:
1. With a Web already created, select File _ Import. The Import dialog box appears.
2. Click the Add File button to import one or more files, or click the Add Folder button
to import an entire folder with files.

If you import a folder, that folder becomes a folder in your FrontPage Web, and the files within
Note
it are kept together in the folder.

3. You can use the Add File and/or the Add Folder buttons as often as you want, until
you have selected all the files and/or folders that you want to import.
4. After you select your files, click OK in the Import dialog box to copy files to your
Web server or FrontPage Web folder.
If you are creating a new Web site from files generated by an Office 2003 application, you can
select File _ New _ Web and double-click the Import Web Wizard in the New dialog box.
The Import Web Wizard walks you through the process of selecting a folder to import.
You can also use the Import dialog box to add files to a Web generated from imported
files.
The following exercise requires a minimal knowledge of Word and Excel. If you can create
a simple document in Word and a small spreadsheet and graph in Excel, you can test
FrontPage™s ability to integrate these files into a Web site.

Importing Word and Excel files into a Web site
Here are the steps to bring Word and Excel files into your Web site:
1. Create a document in Word with text at the top of the page that says “Welcome to
My Web Site.” Add a line of text with your name.
Chapter 14 ¦ Integrating FrontPage with Office Applications 329

2. Assign a Heading 1 style to the top line of text, and a Heading 2 style to your name.
3. Add a paragraph of text below your name. Assign formatting to the text, such as
boldface, italic, font styles, and colors. Center all the text.
4. Select File _ Save as Web Page. Create a new folder called Web Files, and name
the file index. Click Save.
5. Create a new Excel workbook. In cell A1, enter Visitors this year. In cells A2, A3,
and A4, enter January, February, and March, respectively. In cells B2, B3, and
B4, enter numbers.
6. Click and drag to select cells A2 through B4 and click the Chart Wizard button in
the toolbar. In the first Chart Wizard dialog box, click Finish to accept the default
chart settings.
7. Leave Excel open. In FrontPage, select File _ New _ Web. Enter a filename for
your Web in the “Specify the location of the new web” box of the New dialog box.
8. Double-click the Import Web Wizard icon in the New dialog box.
9. Select the From a Source Directory of Files option button in the Import Web Wizard
dialog box.
10. Click the Browse button and navigate to the folder in which you saved your Word
file (Index.htm). Click OK in the Browse for Folder dialog box.
11. Click Next. The Add File to Import List dialog box displays all the files in the
folder, as shown in Figure 14-9. Click Next, and then click Finish.




Figure 14-9 Selecting files to import

12. Switch to Navigation view. Your imported Word file has become your home page.
Right-click on it and choose Open With from the context menu, and then select
FrontPage in the Open with Editor dialog box to open the page in Page view.
Part II ¦ Collaborating and Integrating with Office 2003
330


Caution Double-clicking on the icon in Navigation view opens up the document in Word rather than in
FrontPage Page view.

13. Switch back to Excel. Select the chart and choose Edit _ Copy.
14. Switch to FrontPage and, in Page view, click to set the insertion point in your open
Web page. Select Edit _ Paste to insert the cells.
15. Save the Web page. The embedded chart will be saved as an image file.
The copied spreadsheet cells become a table in FrontPage, and the copied chart becomes an
embedded image file.


Adding Office Web Components to Web Pages
You can add spreadsheets, PivotTables, and graphs to FrontPage Web pages as interactive
elements. Visitors who have Office 2003 installed on their systems can come to your Web
site, enter data in a table, make calculations, and watch a graph display their input. Visitors
who don™t have Office 2003 can still download viewers that enable them to interact with
your spreadsheets, charts, and PivotTables.
You can place interactive PivotTables in Web pages. PivotTables summarize information
from spreadsheet or database tables and are somewhat complex. If, however, your visitors
want to synthesize data from a database live at your Web site, you can provide the tools to
do that.

Adding Office spreadsheets
You can use an interactive spreadsheet element that enables visitors to your Web site to
make all kinds of calculations. For example, you can create a worksheet on which a visitor
can calculate the cost of his or her purchase, including sales tax. You can protect some cells
and leave others open for visitor input.
To place a spreadsheet on your Web page, follow these steps:
1. Open a Web page.
2. Select Insert _ Web Component _ Spreadsheets and Charts, and click Office
Spreadsheet.
3. Click Finish to generate the spreadsheet.
4. Click and drag on side or corner handles to resize the spreadsheet, as shown in
Figure 14-10.
Chapter 14 ¦ Integrating FrontPage with Office Applications 331




Figure 14-10: It™s easy to embed and resize a spreadsheet in FrontPage.




Formatting Embedded Spreadsheets
Formatting, cell protection, and other display and function properties for embedded spreadsheet
components are controlled by a combination of ActiveX control properties and spreadsheet proper-
ties. There is no particular rhyme or reason as to which options are controlled where. Some options
can be defined in either dialog box, and some options (such as chart and cell protection) require
attributes from both dialog boxes.
Let™s face it ” embedded spreadsheets are not the most frequently used feature of FrontPage, and
Microsoft hasn™t paid the same level of attention to organizing their use that was devoted to more
popular features. However, If you persevere through both spreadsheet and ActiveX control proper-
ties, you can indeed create an interactive spreadsheet on your Web page.
The process of formatting an embedded spreadsheet is divided into two sections in this chapter:
defining ActiveX control properties and defining spreadsheet properties.
Part II ¦ Collaborating and Integrating with Office 2003
332


Defining ActiveX control properties for a spreadsheet
You can control some of your spreadsheet attributes in the ActiveX Control Properties
dialog box. These properties include alignment (such as left or right), borders, and spacing
around the spreadsheet.
To define ActiveX control properties, follow these steps:
1. Right-click the spreadsheet and choose ActiveX Control Properties. The ActiveX
Control Properties dialog box appears, as shown in Figure 14-11.




Figure 14-11 Use the ActiveX Control Properties dialog box to define how your
spreadsheet will be displayed.

2. Use the dialog box to define any of the following attributes:
• In the Workbook tab, specify the spreadsheet name: A name is required if you
plan to link the spreadsheet to a chart (see “Adding Office charts,” later in this
chapter). You can also name sheets within the worksheet in this area. Use the
checkboxes in the Show/Hide area to display (or hide) scroll bars, a sheet selector
tab area, and a toolbar. Finally, choose one of the radio buttons to set calculations
to automatic or manual (you will probably want your spreadsheet to calculate
formulas automatically).

Note You aren™t likely to need the options in the Format or Formula tabs of the ActiveX Control
Properties dialog box. You can create formulas and define most formatting in the spreadsheet.

• In the Sheet tab, you can search your spreadsheet or use checkboxes to define
how sheets are displayed.
• The Import tab is used to import an existing XML file, and the Data Source tab is
used to connect your spreadsheet to an existing database.
Chapter 14 ¦ Integrating FrontPage with Office Applications 333

• The Object Tag tab (“tag” refers to the ActiveX control properties) defines the
width and height, alignment, and spacing around your spreadsheet. The Width
and Height boxes are an alternative way to size the spreadsheet (you can also
resize in Page view by clicking and dragging sizing handles). The relevant
options in the Alignment drop-down list are Left or Right. Use them to let text
flow around the spreadsheet. Border thickness defines the width of a border
around the spreadsheet. The HTML box defines a message, and URL displays if
a visitor™s browser doesn™t support interactive spreadsheets. The default HTML
informs visitors that they need a viewer to use this feature.
• The Advanced tab has some useful features, including the Autofit Spreadsheet
checkbox, which enables you to define your spreadsheet as a fixed percentage of
the browser window™s width.
• The Protection tab enables you to define what editing features are accessible to
visitors, including the capability to enter data in cells. You can modify the
protection you define in the ActiveX Control Properties dialog box in the
Spreadsheet Properties dialog box.
3. After you define properties, click Apply in the dialog box.
An embedded spreadsheet is shown in Figure 14-12.




Figure 14-12: This interactive spreadsheet can be edited both in FrontPage and in a
Web browser.
Part II ¦ Collaborating and Integrating with Office 2003
334


Defining spreadsheet properties
You can enter text, values, and formulas the same way that you do in Excel. Many other
Excel functions are also available using the Commands and Options dialog box. Some, but
not all, of these property controls can be made available for visitors. For example, visitors
can be allowed to enter data into cells and change cell formatting, but visitors cannot be
given access to features such as Protection (a feature that defines which cells, if any, a visitor
can change).
Figure 14-13 shows the Commands and Options dialog box as it appears to visitors using
Internet Explorer 5.5 and later.




Figure 14-13: Most of the formatting attributes available in Excel are stashed in the
Commands and Options dialog box, which can be made available to visitors who have
Office 2003 on their computers.

The Format, Formula, Sheet, and Workbook sections of the Commands and Options dialog
box are available in browser windows provided that Commands and Options were enabled
in the Protection tab of the ActiveX Control Properties dialog box. Therefore, these features
are defined not only by the page author (you), but also by visitors who work on the
spreadsheet at your Web page.
A detailed description of all the features of the Commands and Options dialog box would
really require a book about Microsoft Excel, but here is a quick overview of the features
available in each tab:
Chapter 14 ¦ Integrating FrontPage with Office Applications 335

¦ The Cell Lock/Unlock Cells button in the Format tab enables you to disable
protection from selected cells. This feature is not available for visitors. The rest of
the Format tab has a fairly full-featured Formatting toolbar for defining font type,
style, size, and color. Other boxes in this section refine cell display. Of particular
usefulness is the Number Format drop-down list, which includes currency and date
formats.
¦ The Formula tab is redundant, because formulas are normally defined in cells.
¦ The Sheet, Workbook, Advanced, Import, and Data Source tabs duplicate the same
tab settings in the ActiveX Control Properties dialog box.
For an example of defining a spreadsheet Web component, see the exercise at the end of this
chapter.

For all practical purposes, you must publish your Web to a server with FrontPage 2002 or
Note
FrontPage 2000 extensions to link an embedded spreadsheet to an embedded chart. (There
are no new 2003 extensions.)

FrontPage will manage the process of connecting your data and your chart, as long as you
confine your work to a FrontPage extension site.

Adding Office charts
You can generate Office charts in FrontPage using three sources of data: a spreadsheet on
the Web page, data you enter specifically to be charted, or data from a server database.
The focus here is on Office charts that are linked to embedded spreadsheets in FrontPage.
These charts can interactively display spreadsheet content, enabling visitors who change
data in your spreadsheet to see the new data charted on the Web page.
To link a chart to a spreadsheet, follow these steps:
1. Start by creating an embedded spreadsheet in a Web page (see instructions in the
previous section). Be sure to name the sheet (in the Object Tag tab of the ActiveX
Control Properties dialog box, which you can access by right-clicking on your
selected chart).
2. Next, insert a chart. This can be done right next to the spreadsheet if you wish (as
illustrated in Figure 14-14). To insert the chart, select Insert _ Web Component _
Spreadsheets and Charts _ Office Chart. Click Finish. The Commands and Options
dialog box appears.
Part II ¦ Collaborating and Integrating with Office 2003
336




Figure 14-14: An interactive chart can be placed next to a spreadsheet.

<< . .

. 29
( : 51)



. . >>